A2K7AD
Access 2007 Application Development
Course Duration: 1 Day
Class Time: 9 am - 4:30 pm

LESSON 1 – Application Design

  • Examining the Components of an Application
  • Identifying the Objectives of an Application
  • Resolving Design Issues in an Application
  • Planning Application Objects
  • Making a Binary Executable

LESSON 2 – Advanced Form Design

  • Creating and Using Grouped Controls
  • Adding an Option Group Control to a Form
  • Modifying the Option Group Control
  • Checking for Errors in Forms
  • Adding a Tab Control to a Form
  • Making a Form Read Only
  • Examining and Using a Datasheet Style Subform
  • Examining an Unlinked Subform with a Chart
  • Creating a Datasheet Style Subform
  • Modifying a Subform

LESSON 3 – Dialog Boxes and Macros

  • Examining Dialog Box Properties
  • Creating a Dialog Box
  • Examining a Macro Group
  • Creating a Macro Group
  • Attaching a Macro Group to an Event
  • Examining a Combo Box that Finds Records
  • Creating a Combo Box to Find Records
  • Examining Embedded Macros for Form Navigation
  • Creating Command Buttons for Navigating Forms
  • Opening a Form to a Specific Record
  • Creating a Macro to Open a Form to a Specific Record
  • Examining Error Handling in Macros

LESSON 4 – Application Navigation

  • Examining a Switchboard
  • Creating a Switchboard
  • Testing Switchboard Objects
  • Modifying a Switchboard
  • Observing a Splash Screen
  • Making a Splash Screen
  • Automating a Splash Screen

LESSON 5 – Custom Menus and Navigation Groups

  • Examining and Modifying a Custom Menu Form
  • Customizing the Quick Access Toolbar
  • Creating Custom Categories and Groups in the Navigation Pane
  • Adding Objects to Custom Navigation Groups
  • Changing Navigation Pane Display Properties


Prerequisites: Access 2007 Mastery or equivalent working knowledge