Microsoft Access 2003: Advanced

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: Access 2000 and the Internet

• Using hyperlinks
• Access tools for working on the Internet