Access 2002:
Application development

Topic-Level Outline

Days: 1

Prerequisites: Access XP: Advanced or equivalent experience

Unit 1 : Designing an application

Topic A: 0 Examining an application

A-1: Examining the components of an application

Topic B: Planning an application

B-2: Identifying the objectives of an application

B-3: Resolving design issues in an application

B-4: Planning application objects

Unit 2 : Automating forms

Topic A: 0 Working with dialog boxes

A-1: Examining the properties of a dialog box

A-2: Examining the properties of controls on a dialog box

Topic B: 0 Working with macro groups

B-1: Examining a macro group

B-2: Creating a macro group

B-3: Attaching a macro group to command buttons

Topic C: 0 Automating navigation across forms

C-1: Discussing VBA

C-2: Examining the VBE window

C-3: Examining a command button code

C-4: Programming a button on a form to open another form

C-5: Disabling and enabling command buttons

Unit 3 : Working with Switchboard and Splash Screen forms

Topic A: 0 Working with Switchboard forms

A-1: Creating a Switchboard form by using the Switchboard Manager

A-2: Testing Switchboard objects

A-3: Modifying a Switchboard form

Topic B: 0 Working with Splash Screen forms

B-1: Observing a Splash Screen form

B-2: Creating a Splash Screen form

B-3: Setting label properties

B-4: Setting the properties of a Splash Screen form

Topic C: 0 Automating Splash Screen forms

C-1: Displaying the Splash Screen form on database startup

C-2: Displaying the Splash Screen form for a specified time

C-3: Opening a Switchboard form automatically after the Splash Screen form

Unit 4 : Creating custom toolbars and menu bars

Topic A: 0 Working with toolbars

A-1: Creating a macro group to show or hide a toolbar

A-2: Replacing the built-in toolbar with a custom toolbar

A-3: Adding buttons to a custom toolbar

Topic B: 0 Creating custom and shortcut menus

B-1: Examining a custom menu bar

B-2: Creating a custom menu bar

B-3: Adding commands to a custom menu bar

B-4: Creating a custom shortcut menu

B-5: Setting startup properties for toolbars, menus, and Access Special Keys

Unit 5 : Working with VBA code

Topic A: 0 Discussing VBA programming elements

A-1: Discussing data types

A-2: Using variables and constants

Topic B: 0 Working with modules

B-1: Examining the Code window

B-2: Examining a VBA code

Topic C: 0 Creating procedures

C-1: Creating a Sub procedure in a standard module

C-2: Calling a Sub procedure

C-3: Creating a Function procedure in a standard module

C-4: Calling a Function procedure

Unit 6 : Advanced VBA programming

Topic A: 0 Using control structures

A-1: Using the IF…Then statement

A-2: Using the IF…Then…Else statement

A-3: Using the IF…Then…ElseIf statement

A-4: Using the For…Next loop

A-5: Using the Do While… loop

Topic B: 0 Handling events

B-1: Assigning event handling code to a text box

B-2: Assigning event handling code to a combo box

B-3: Assigning event handling code to coordinate events across two forms

B-4: Assigning the OnUndo event procedure for a form

B-5: Assigning the Unload event procedure for a form

Topic C: 0 Resolving errors

C-1: Adding error-handling code

C-2: Testing an error-handling code

Topic D: 0 Displaying a Web site

D-1: Adding a Web browser control to a form

D-2: Displaying a Web site on the form

Topic E: 0 Working with MDE files

E-1: Creating an MDE file