• Call Us: +61 409551614

Microsoft Access Intermediate

The topics listed under this level of training for Access Intermediate are a snapshot only of the skills which fall under the Intermediate category. If you are interested in Access Intermediate training, please contact us to register your interest below, using this form. As we provide customised training, for multi-student training sessions the next step after you contact us involves us assessing your team’s current skills. This helps to determine exactly which topics your team requires training in. After you have completed the Access Intermediate level of training, you may want to up-skill to the next level: Microsoft Access Advanced. You may even want to view Microsoft’s website to see examples of Expressions, the correct syntax for them and use. If the Intermediate level of training is too complex for you, you can view the Microsoft Access Basics course.

Computer work at a desk with a Laptop

This level includes:


  • Correctly relating Tables
  • Linking Tables
  • Changing Field position
  • More data properties
  • Freezing/unfreezing Columns
  • Spellchecking/proofreading data


  • Filtering with Forms
  • Combo Boxes
  • Lists
  • Tabs
  • Command Buttons
  • Distributing & Aligning Fields evenly
  • Basic formatting of Controls
  • Stacking & Layouts


  • Grouping records in a Query
  • Summarising and Total Fields
  • Formulas in Queries
  • Date range Queries
  • Formatting Fields
  • Modifying existing Queries
  • Beginner Formula Expressions
  • Functions using Expression Builder


  • Changing design & format Report
  • Changing orientation
  • Consolidating formatting commands
  • Creating professional Reports with Logos
  • Adding Page headers & footers
  • Adding Report headers & footers
  • Managing space to enable Printing


  • Sort multiple Database Fields
  • Reversing & removing a Sort
  • Creating a built-in template Database
  • Importing Data
  • Importing Excel files
  • Compact & Repair a Databaes

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 Intermediate training?

    How many people require this training?