Advanced Microsoft Access 2003

Duration: 12 hours

Description: This course is designed to provide students with an introduction to the advanced features of Access. Topics will include advanced queries, advanced report design, and creating and using macros. It is recommended that students have previous experience or training in the basics of Access.

Objective: Upon completion of the course, students will be able to use advanced features of the program such as queries, reports, and macros.

Course Content:

Creating Relationships

Designing Advanced Queries

Creating Action Queries

Using Advanced Query Wizards

Using Advanced Database Features

Using Subforms/Subreports

Using Other Form Techniques

Working with Indexes

Using Access and the Internet

Creating Macros

Using Macros

Using Switchboards

Creating Custom Toolbars

Exporting Data to Excel and Word

Replicating Databases