Microsoft® Office Access 2007 Level 3

Description: You will learn how to use a variety of complex query techniques, create more efficient forms and reports, and create and use macros to automate their forms. In addition, you will gain experience with Internet-related features, including hyperlinks and the web toolbar.

Suggested Prerequisites:  Access Level 1 and Access Level 2 or equivalent knowledge

Attend and You Will Learn

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 Interaction and Automation

• 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 and the Internet

• Using hyperlinks
• Access tools for working on the Internet