Overview & Prerequisite

This course is designed for existing users of Access 2007 or those who have attended a foundation course. This course is aimed at those people who will be designing the database.

Course content

Getting Started with 2007
Using the Ribbon instead of menus
The Quick Access Toolbar
Command Tabs
Contextual Command Tabs
The New File Menu

Query
Action Query
Parameter Query
Crosstab Query
Ad hoc Joins
Setting Counter
Calculated Fields

Introduction to Relational Database
Concepts
Basic Relationships
Referential Integrity
One-to-One
One-to-Many
Cascade Delete
Cascade Update

Advanced Form
Main/Sub
Lookup
Command Buttons
Combo Boxes
Calculated Fields

Reports
Design
Mailing Labels
Group/Sort
Word Mail Merge
Analysis with Excel
Create Chart