Access Advanced

Course length: 1 day
Prerequisites: Access Introduction and Intermediate or equivalent knowledge.
Overview: 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 your forms.

Course content

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

Using hyperlinks
Access tools for working on the Internet

Return to Courses