Microsoft Access Training - Advanced Course

Course Content

Database Efficiency

• Data Normalisation
• The Relational Strategy
• Keys in Relational Database
• Indexing
• Designing Suitable Tables
• Join Properties

Advanced Forms

• Main/Sub Form
• Setting the Record Source

Graphics

• Wizard Graph
• Editing Graph
• Graphics in Forms
• Graphics in Reports

Import/Export

• Databases
• Spreadsheets
• Liaising with Word
• Liaising with Exel

Macros

• Setting up Macros
• Attaching Macros Buttons
• Setting up Menus
• Keyboard Shortcut Macros

Administration

• Backup
• Compressing
• Repairing
• Security
• Encryption

Who Should Attend

The Microsoft Access training course is designed for experienced Access users who have attended the Foundation & Intermediate courses or who have similar knowledge.

Venue & Duration

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