Microsoft Access Advanced

Duration 1 Day

Who should attend?

This course is valuable for anyone who plans to prototype, build and integrate relational databases using Access to an advanced level.

Learning Outcomes

  • Create Cross Tab Queries
  • Create Make Table Queries
  • Modify Start-up options
  • Create Macros on Forms
  • Create Macros on Reports
  • Create Database Macros
  • Compact and Repair Databases
  • Database Password Protection
  • Split a Database

Course Content

  • Cross Tab Queries
  • Make Table Queries
  • Change Start-up Form
  • Database Switchboards
  • Create Macros
  • Understand Form Events
  • Understand Report Events
  • Create Autoexec & Autokeys Macros
  • Compacting Access Databases
  • Adding Password Protection To Databases
  • Creating Frontend / Backend Databases