Lesson 1: Parameter and Action Queries

Creating parameter queries
Creating action queries

Lesson 2: Query Joins and Crosstab Queries

Joining tables and working with join properties
Creating crosstab queries
Editing limitations in query datasheets

Lesson 3: Using Advanced Form Techniques

Organizing field placement
Using functions to control data entry
Adding an option group to a form
Using a form as the user interface
Creating a form that contains a subform

Lesson 4: Creating Basic Macros to Automate Forms

Macro basics
Attaching a macro to a command button
Revising a macro
Attaching a macro to an event in a form

Lesson 5: Using Macros to Provide User Interaction and Automate Tasks

Using a macro to provide user interaction
Using macros to automate data entry
AutoKeys and AutoExec macros

Lesson 6: Using Advanced Report Techniques

Customizing the appearance and functionality of a report
Mailing and other types of labels

Lesson 7: Web Capabilities and Data Integration

Using hyperlinks
Data integration