Description: Move beyond the basics of Access by learning advanced table designs, relationships, and how to analyze tables. Learn advanced querying and reporting and how to design sub forms and sub reports as well as customized toolbars. Import data into Access from other data sources such as delimited files or Excel. Add-in ActiveX controls to your forms and display your data in charts.

Objective: Students expand upon introductory level knowledge of Access to use numerous additional database features.

Course Content:

Creating a Database Using a Wizard

Advanced Table Design

Importing Data

Creating Relationships

Using Operators in Queries

Creating Action Queries

Analyzing Tables

Using Advanced Form Design

Advanced Report Design

Using Subforms / SubReports

Using Charts

Creating Custom Toolbars

Using ActiveX Controls