Microsoft Access Intermediate

Course Description

The Microsoft Access Intermediate course aims to build on the skills covered in the Introduction level course. Participants will learn how to ensure that data is entered correctly, how to create more sophisticated and complex queries, and will cover an introduction to some basic automation techniques involving macros.

Learning Outcomes

At the completion of Microsoft Access Intermediate you should be able to:


Microsoft Access Intermediate assumes the participant has the knowledge required to create a table and basic query plus design a simple form.

Course Duration

The Microsoft Access Intermediate course is run over one-day but can be customised to suit your needs.

Course Overview

  • Assign Default Values
  • Validation Rules and Text
  • Set Required Fields
  • Work with Validations
  • Change Column Widths
  • Format Cells in a Table
  • Move and freeze columns in a Table
  • Hide and Unhide Columns in a Table
  • Modify a Saved Query
  • Create an AND and OR Queries
  • Query Numeric Data or Dates
  • Using a Range Expression
  • Query Opposite Values
  • Sort Query Data
  • Query Using Wildcards
  • Query with a Lookup Table
  • Sort Query Data Numerically
  • Display NULL Values
  • Create a Parameter Query
  • Use Parameters to Display a Range
  • Use Parameters in Expressions
  • Use Parameters with Wildcards
  • Create a Calculated Field
  • Summarise Data Using a Query
  • Calculate with Dates
  • Use Criteria in Calculations
  • Concatenating String Fields
  • Work with a Control Stack
  • Change Control Widths
  • Move and Align Controls on a Form
  • Add an Unbound Control
  • Add a Control Source
  • Change the Tab Order
  • Insert the Date into the Form Header
  • Create a Simple Navigation Form
  • Create a Complex Navigation Form
  • Create Subsidiary Pages
  • Apply a Theme
  • Modify Properties
  • Automatically Start the Navigation Form
  • Create a Multiple Item Form
  • Adjust the Layout of a Form
  • Disable Fields
  • Add an Easy Lookup Field
  • Add Buttons to a Form
  • Adjust Form Properties
  • Create a Macro
  • Run a Macro
  • Modify an Existing Macro
  • Interact with the User
  • Create a Print Macro
  • Create a Sequence of Conditions
  • Use the MsgBox Function
  • Reconfigure a Message Box
  • Use the InputBox Function
  • Create Navigation Macros
  • Create Unassigned Buttons
  • Run or Modify an Event Macro
  • Set Echo Off
  • Add a Close Button
  • Create and run a Search Macro
  • Understand the Navigation Pane
  • Create Custom Categories
  • Create Custom Groups
  • Add Objects to a Group
  • Hide Groups and Objects
  • Show Hidden Groups and Objects

Course Inclusions

Skills Analysis

Take advantage of our free online skills analysis prior to your training to ensure you’re enrolled in the right course.


After completing the course you’ll receive a certificate to show off your new-found Microsoft Outlook knowledge.

We come to you

To save your business time, money and unnecessary travel, we come to you, delivering our training at your premises.

Hands-on training

We’re big believers in hands-on learning so you’ll be on a computer and building your skills in real-time.

Email Support

Access unlimited support following your training course to build on your learning and ask any burning questions.

Real-world examples

There’s nothing better than working through real-world examples to reinforce learning and increase your confidence.

Course Pricing

Pricing as of 1st July 2019. All prices are exempt of GST. All prices are PER SESSION, not per person.

Number of participants Investment (per day)
1-on-1 Training $500.00
2-3 participants $650.00
4-6 participants $800.00
7-8 participants $950.00
9-10 participants $1,200.00

Above costs are for training conducted within the Sydney region and is subject to travel fees dependent on location. Pricing provides a guide only and will be confirmed at time of booking enquiry.

View other course outlines

Microsoft Access Computer Training Courses

Access Introduction

- 1 day course duration

Scroll to Top
Call Now Button