Microsoft Access Advanced

The topics listed under this level of training are a snapshot only of the skills which fall under the Access Advanced category. If you are interested in this level of training, please contact us to register your interest using the form below. As we provide customised training, for multi-student training sessions the next step after you contact us involves us assessing your current skills to determine exactly which topics you require training in. If this level of training is too complex for you, you may want to consider the Microsoft Access Intermediate course.

This level includes:

Tables

  • More Table properties
  • Creating bridging Tables
  • Many to Many Relationships

Forms

  • Lookup Fields
  • Tab ordering
  • Filtering Record Sources
  • Calculations on Forms
  • Sub Forms
  • Editable vs Viewable Record status
  • Altering the ‘New Record’ Form
  • Switchboards
  • Modal status

Queries

  • Aggregates
  • Calculated Fields
  • Formatting data type Query results
  • Linking Tables in a Query
  • Parameter Queries
  • Append Queries
  • Update Queries
  • ‘Create Table’ Queries
  • Building Expressions
  • Functions using Expression Builder
  • Applying advanced Filters

Reports

  • A detailed look at Properties
  • Applying Grouping
  • Applying Sorting
  • Applying Totals
  • Input Masks

Databases

  • Designing a Database from Scratch
  • Planning of a Database
  • Provisions for a Database
  • Understanding Object and Action Events
  • Applying Referential Integrity
  • Applying Cascade Settings
  • Understanding User needs
  • Understanding the “Backend”
  • Locking a Database
  • Introduction to Event procedures
  • Hiding of System Tables
  • Setting up Database Documenter
  • Object Dependancies
  • Table Analyzer
  • Performance Analyzer

Request for Training

Your Name (required)

Your Email (required)

Your Contact Number (required)

Any prior experience with Access?

Motivation for Training? (upskilling / applying for a job...)

How soon do you need this Access Advanced training?

How many people require this training?