Access 2007 Intermediate Course Contents

Hover over the content header to see more details

Click to view Course Contents as PDF file

Access Database Terminology

Primary Key
Indexing Fields
Referential Integrity
Access Help

Tables

Table design recap
Relationships between tables
Relationship window
Add/hide tables in relationship window
Relationship layout
Create a relationship report
Create simple joins
Create referential integrity
Join types
Subdatasheets overview

Queries

Multiple table queries
Parameter queries
Calculation in queries
Functions in queries
Grouped queries
Query object properties

Forms

Predesigned Forms
Create a Form with a subform
Form and subform design and layout
Aligning and sizing form objects
Adding lines and rectangles
Tab Order
Create a Switchboard (menu form)

Reports

Mailing label reports
Grouped reports - create
Edit report design and layout

Access 2007 Courses

No events