Microsoft Access 2000 Advanced

Duration:	1 day
Prerequisite:	Microsoft Access 2000 Level 2 or equivalent experience
Course Materials:	Course manual (074402S3)
Prices:	$195 for 1 student (one-on-one training) $160 each for 2 to 3 students $130 each for 4 to 6 students $130 for the first 6 students, $100 for each additional student
Description:	Students 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, students will gain experience with Internet-related features, including hyperlinks and the Web toolbar.

Parameter and Action Queries

Creating Parameter Queries
Creating Action Queries

Query Joins and Crosstab Queries

Joining Tables and Working with Join Properties
Creating Crosstab Queries
Editing Limitations in Query Datasheets

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

Creating Basic Macros to Automate Forms

Macro Basics
Attaching a Macro to a Command Button
Revising a Macro

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