O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Access 2007 Advanced

Video Description

This course builds on the Introduction and Intermediate courses to show you how to bring all of the different Access objects and development phases together to make a cohesive application. It also teaches you many different techniques to make Access even more interactive by using dialog boxes, subforms, and more controls. Finally, the course shows you how to create different types of macros and how to select the proper Control and Event for the best possible outcome. The course will cover programming tips as well.

Table of Contents

  1. Introduction
    1. Introduction 00:02:52
  2. Designing the Application
    1. The Access Development Phases 00:03:32
    2. Putting the Entire Database on a Server 00:02:23
    3. Splitting the Database 00:02:15
    4. Creating a Database Project 00:02:40
  3. Subforms
    1. Creating a Subform Automatically 00:06:57
    2. Creating a Subform Manually 00:06:37
    3. Linking a Subform 00:03:26
    4. Referencing Controls in a Subform 00:08:10
  4. Dialog Boxes
    1. Understanding Dialog Boxes 00:01:33
    2. Creating a Dialog Box 00:02:39
    3. Setting Dialog Box Properties 00:12:58
    4. Setting Dialog Events 00:09:38
  5. Controls
    1. Using the Option Group Control 00:06:01
    2. Using the Command Button Control 00:02:52
    3. Using the Combo Box Control 00:16:29
  6. Passing Form Values to Queries
    1. Examining the Query and Form 00:02:59
    2. Using the Expression Builder 00:04:18
  7. Simple Macros
    1. Understanding Macro types 00:02:47
    2. Creating a simple Macro 00:12:29
  8. Macro Groups
    1. Understanding Macro Groups 00:01:23
    2. Creating a Macro Group 00:10:24
  9. Conditional Macros
    1. Understanding Conditional Macros 00:02:35
    2. Creating a Conditional Macro 00:03:06
    3. Using the StopMacro Command 00:01:13
    4. Fixing Syntax Errors 00:01:56
    5. Handling a false condition 00:03:18
    6. Validating input 00:10:33
  10. System Wrap-Up
    1. Importance of Documenting the Database 00:01:59
    2. Using the Database Documenter 00:02:53
    3. Setting Autostart Options 00:03:52
    4. Setting a Password 00:02:03
  11. Programming Tips
    1. Data First 00:01:06
    2. Table Properties 00:00:37
    3. Form Design 00:00:50
    4. Follow Windows 00:00:53
    5. Close Buttons 00:00:39
    6. Simple is Best 00:00:58
  12. Conclusion
    1. Conclusion 00:01:32