Lesson 1: Designing an Application

1. Examining the components of an application

2. Identifying the objectives of an application

3. Resolving design issues in an application

4. Planning application objects

Lesson 2: Automating Forms

1. Examining the properties of a dialog box

2. Examining the properties of controls on a dialog box

3. Examining and creating a macro group

4. Attaching a macro group to command buttons

5. Discussing VBA

6. Examining the VBE window

7. Examining a command button code

8. Programming a button on a form to open another form

9. Disabling and enabling command buttons

Lesson 3: Working with Switchboard and Splash Screen Forms

1. Creating a Switchboard form by using the Switchboard Manager

2. Testing Switchboard objects

3. Modifying a Switchboard form

4. Observing a Splash Screen form

5. Creating a Splash Screen form

6. Setting label properties

7. Setting the properties of a Splash Screen form

8. Displaying the Splash Screen form on database startup

9. Displaying the Splash Screen form for a specified time

10. Opening a Switchboard form automatically after the Splash Screen form

Lesson 4: Creating Custom Toolbars and Menu Bars

1. Creating a macro group to show or hide a toolbar

2. Replacing the built-in toolbar with a custom toolbar

3. Adding buttons to a custom toolbar

4. Examining a custom menu bar

5. Creating a custom menu bar

6. Adding commands to a custom menu bar

7. Creating a custom shortcut menu

8. Setting startup properties for toolbars, menus, and Access Special Keys

Lesson 5: Working with VBA Code

1. Discussing data types

2. Using variables and constants

3. Examining the Code window

4. Examining a VBA code

5. Creating a Sub procedure in a standard module

6. Calling a Sub procedure

7. Creating a Function procedure in a standard module

8. Calling a Function procedure

Lesson 6: Working with Advanced VBA Programming

1. Using the If…Then statement

2. Using the If…Then…Else statement

3. Using the If…Then…ElseIf statement

4. Using the For…Next loop

5. Using the Do While…loop

6. Assigning event handling code to a text box

7. Assigning event handling code to a combo box

8. Assigning event handling code to coordinate events across two forms

9. Assigning the Undo event procedure for a form

10. Assigning the Unload event procedure to a form

11. Adding error-handling code

12. Testing an error-handling code

13. Adding a Web browser control to a form

14. Displaying a Web site on the form

15. Creating an MDE file