Centre for Continuing Education

Microsoft Access Course: Level 2

Microsoft Access. Create databases fast without being a developer.

COVID-19 update: arrangement of our courses

We are now delivering courses online and in-person. Please check the delivery format of each class before enrolling.

Please note that course materials (excluding prescribed texts) are shared electronically within 48 hours of course commencement. Printing is not available.

This Microsoft Access training course builds on the introductory skills and knowledge covered in Microsoft Access: Level 1. You will learn how to ensure that data is entered correctly, how to create more sophisticated and complex queries, and be introduced to some basic automation techniques involving macros.


By the end of this course, you should be able to:

  • use various data validation features in Access to protect data
  • create and use parameter queries
  • create calculated queries
  • create and use macros in Access
  • work with a number of macro techniques
  • create and work with macros in forms
  • create and work with aggregation queries
  • create and use a series of action queries
  • understand and use a variety of tools that ensure the wellness of your database files
  • create forms using a combination of wizards and manual techniques
  • create and manage custom categories and groups in the Navigation Pane.


Data validation

  • Assigning default values
  • Validation rules and text
  • Validating numbers
  • Setting required fields
  • Working with validations

Parameter queries

  • Creating a parameter query
  • Displaying all records
  • Using parameters to display a range
  • Using parameters in expressions
  • Using parameters with wildcards

Calculations in queries

  • Creating a calculated field
  • Formatting calculated fields
  • Summarising data using a query
  • Changing the grouping
  • Calculating with dates
  • Using criteria in calculations
  • Concatenating string fields

Creating and using macros

  • Understanding macros and VBA
  • Creating a macro
  • Running a macro
  • Modifying an existing macro
  • Interacting with the user
  • Stepping through a macro
  • Documenting macros

Macro techniques

  • Creating a print macro
  • Using conditions to enhance a macro
  • Creating a sequence of conditions
  • Understanding the versatility of msgbox
  • Using the msgbox function
  • Reconfiguring a message box
  • Using the inputbox function

Macros on forms

  • Understanding macros on forms
  • Creating navigation macros
  • Accessing event macros
  • Creating unassigned buttons
  • Programming an event
  • Running an event macro
  • Modifying an event macro
  • Setting echo off
  • Adding a close button
  • Creating a search macro
  • Running the search macro
  • Understanding the search macro
  • Naming macros
  • Referencing macro sheet macros

Aggregation queries

  • Creating an aggregation query
  • Working with aggregation queries
  • Multiple aggregations
  • Modifying aggregation headings
  • Aggregating calculated fields
  • Applying criteria to aggregates
  • Understanding nested queries
  • Creating an assembly query
  • Creating the nesting query

Action queries

  • Creating a make table query
  • Using a make table query
  • Understanding expressions and update queries
  • Preparing an update query
  • Running an update query
  • Updating using expressions
  • Running an expression-based update
  • Creating a delete query
  • Running a delete query
  • Creating an append query
  • Running an append query
  • Turning action messages off

Database wellness

  • Compacting and repairing a database
  • Understanding database splitting
  • Using the database splitter
  • Managing linked tables
  • Checking object dependencies
  • Analysing database performance
  • Documenting a database

DIY forms

  • Creating a multiple item form
  • Adjusting the layout of a form
  • Typing into a form layout
  • Disabling fields
  • DIY sub forms
  • Removing subform redundancy
  • Splitting and merging layout cells
  • Adding an easy lookup field
  • Adding buttons to a form
  • Adjusting form properties
  • Understanding the navigation pane
  • Creating custom categories
  • Creating custom groups
  • Adding objects to a group
  • Hiding groups and objects
  • Showing hidden groups and objects

Intended audience

Suitable for anyone with a basic knowledge of MS Access, and/or those who have completed Microsoft Access: Level 1.


Assumes some knowledge of the software in order to create basic databases and generate reports.

You should be familiar with the basic functions of a computer operating system such as navigating the environment using a mouse and keyboard, starting applications, copying and pasting objects, formatting text, creating folders, opening files, saving files, familiarity with the accessing the Internet and use of common web browsers. If you do not have these skills, we recommend attending Basic Computer Skills Course and Effective Internet Use before attempting this course.

Delivery style

  • Presenter-taught training in a computer lab
  • Online training via the platform Zoom


You will be provided with a link to access and download your own personalised eBook prior to class.

Additional information

Face-to-face classes

These classes run in a computer lab and you do not need to bring your own device.

Please bring a USB flash drive to class if you would like to make a copy of your work or any relevant class materials. Alternatively, you can save these to a cloud storage space or email them to your personal email address.

Online classes

If you are attending an online class, you will need your own device.

Recommended operating system: Windows
Recommended software for PC: MS Access 2013, 2016, 2019, 365
Recommended browser: Chrome


  • $50 repeat class - Conditions apply
  • Expert trainer
  • Small class size
  • CCE Statement of Completion

Apply for the IT repeat discount.

What others say.

  • This is the best teacher I have come across after 5 years of high school and 5 and a half years of university. He is one of the rare few capable of teaching in a way that neglects neither the talented students, nor the students who are struggling in the class. I highly recommend these classes.

  • A very well structured course. The tutor was very helpful and friendly and had made the difficult concepts easy enough to understand and follow. The class was packed with information but I was never once bored or lost track of things.

  • Great one day course. Venue was very well located and equipped. Very impressed indeed. I’ll be back for Level 3!

  • It was a very busy day! I was most appreciative of the efforts of the presenter to outline details which would be essential in my work with MS Access. He was very knowledgeable and capable and ready to help all students including myself if/when difficulties arose.

Microsoft Access Course: Level 2

<p>{block name:“Course Tagline - Microsoft Access”}</p><p>{block name:“Course Message - Microsoft and Adobe”}</p><p>{block name:“Block - COVID 19 updates”}</p><p>This Microsoft Access training course


What others say.

  • Great one day course. Venue was very well located and equipped. Very impressed indeed. I'll be back for Level 3!
  • This is the best teacher I have come across after 5 years of high school and 5 and a half years of university. He is one of the rare few capable of teaching in a way that neglects neither the talented students, nor the students who are struggling in the class. I highly recommend these classes.
  • Our tutor did a wonderful job! I learnt so much and can't wait to put it to use!
We acknowledge the tradition of custodianship and law of the Country on which the University of Sydney campuses stand. We pay our respects to those who have cared and continue to care for the Country.