MONROE BUSINESS ASSOCIATES

INTERMEDIATE ACCESS

(6 hours)

Who should attend:

Individuals attending this course should be familiar with the Windows operating system and have some knowledge of Access.

Prerequisites:

A working knowledge of the skills outlined within Introduction to Access is required.

Course Outline:

Relational Database

· Referential Integrity

· Relationships

Second Step Queries

· Saving Queries

· Updating Queries

· Totals

· Adding to a Table via a Query

· Multiple Table Queries

· Joining Related Tables

Creating Form

· Autoform

· Form Wizard

· Modifying Forms

· Bound and Unbound Controls

· Snap to Grid Options

· Setting Properties

· Form Tools

· Customizing a Blank Form

Main and Subforms

· Creating and Embedding Subforms

· Editing Subforms

· Changing Subform Properties

Creating Reports

· Source of Report Data

· Report Style

· Converting Forms to Reports

· Multi-Table Reports