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

Fri Sep 17
Access 2007 Advanced Course
Mon Oct 04
Access 2007 Introduction Course
Tue Oct 05
Access 2007 Intermediate Course
Mon Oct 11
Access 2007 Advanced Course
Tue Nov 02
Access 2007 Introduction Course
Wed Nov 03
Access 2007 Intermediate Course
Wed Nov 17
Access 2007 Advanced Course
Wed Dec 01
Access 2007 Introduction Course
Thu Dec 02
Access 2007 Intermediate Course
Thu Dec 09
Access 2007 Advanced Course