• Call Us: +61 409551614

Microsoft Access Advanced

The topics listed under this level of training are a snapshot only of the skills related to Microsoft Access Advanced. If you are interested in this level of training, please contact us to register your interest using the form below. For group training, we provide customised multi-student training sessions for Microsoft Access. To initiate your group training session in Access, we’ll need to assess your team’s current skills. This helps to determine exactly which topics you require training in, so staff don’t need to sit through repetitive topics. If this level of training is too complex for you or your team, you may want to consider the Microsoft Access Intermediate course. Many people find Microsoft Access a complex software app to learn. Hence, a knowledgeable trainer is required who can comprehensively convey the steps necessary to operate Microsoft Access.

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
  • Grouping fields
  • Sorting records
  • Applying Totals
  • Input Masks

Databases

  • Designing a Microsoft Access 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?