Microsoft Access Training - Intermediate Course

Course Content

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 Exel
• Create Chart

Who Should Attend

The Microsoft Access training course is designed for existing users of Access who have attended a Foundation course This course is aimed at those people who will be designing the database.

Venue & Duration

This is a one-day course held either at Smart Learning Solutions premises or on-site.