Centre for Continuing Education

Microsoft Access Course: Level 2

Microsoft Access. Create databases fast without being a developer.

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

This course 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

Delivered as presenter-taught computer-based training in a Microsoft Windows environment.


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

Additional information

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.


  • $50 repeat class - Conditions apply
  • Expert trainer
  • Dedicated computer for every participant
  • 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>This Microsoft Access training course builds on the introductory skills and


What others say.

  • Our tutor did a wonderful job! I learnt so much and can't wait to put it to use!
  • The Excel level 2 course was as good as level 1. Again, a wonderful tutor - professional, knowledgeable and funny.
  • An excellent and highly knowledgeable facilitator who made the content interesting, relevant, and enjoyable to learn. The course was well structured with an easy-to-follow format. I strongly recomment the MS Access courses delivered by CCE.