Microsoft Access Course: Level 2 (Intermediate)

Microsoft Access Course: Level 2 (Intermediate)

Short courses in Sydney, open to everyone.

Create and share database apps without being a developer with our Microsoft Access courses in Sydney.

Microsoft Access is one of the world’s leading relational database software applications. In our Microsoft Access courses, learn how to build sophisticated database applications to track, report and share information, and sort, filter and group data in ways that provides valuable insights for your organisation. Learn Microsoft Access with our Microsoft Access courses in Sydney – short courses open to everyone.

This Microsoft Access course is an intermediate Access course that will build on the introductory skills of Microsoft Access Course: Level 1 (Beginners). You’ll 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. Completion of this Microsoft Access course provides sufficient knowledge for learners to proceed to Microsoft Access Course: Level 3 (Advanced).

Learning Outcomes

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

  1. Use various data validation features in Access to protect data.
  2. Format the data in a table.
  3. Perform more advanced queries using a variety of querying techniques.
  4. Create and use parameter queries.
  5. Create calculated queries.
  6. Modify and adapt an existing form according to specific needs.
  7. Create a navigation form for a database in Access 2016.
  8. Create forms using a combination of wizards and manual techniques.
  9. Create and use macros in Access.
  10. Work with a number of macro techniques.
  11. Create and work with macros in forms.
  12. Create and manage custom categories and groups in the Navigation Pane.

Course Content

The following content will be covered in this Microsoft Access course:

Microsoft Access Data Validation

  • Assigning Default Values.
  • Validation Rules and Text.
  • Validating Numbers.
  • Setting Required Fields.
  • Working With Validations.

Formatting Tables in Microsoft Access

  • Changing Column Widths.
  • Formatting Cells in a Table.
  • Changing Fonts.
  • Moving Columns in a Table.
  • Freezing Columns in a Table.
  • Hiding Columns in a Table.
  • Unhiding Columns.

Microsoft Access Querying Techniques

  • Modifying a Saved Query.
  • Creating AND Queries.
  • Creating OR Queries.
  • Querying Numeric Data.
  • Querying Dates.
  • Using a Range Expression.
  • Querying Opposite Values.
  • Moving Fields in a Query.
  • Sorting Query Data.
  • Removing Fields From a Query.
  • Querying Using Wildcards.
  • Problem Characters.
  • Querying With a Lookup Table.
  • Sorting Query Data Numerically.
  • Displaying NULL Values.
  • Querying for Uniqueness.

Parameter Queries in Microsoft Access

  • Creating a Parameter Query.
  • Displaying All Records.
  • Using Parameters to Display a Range.
  • Using Parameters in Expressions.
  • Using Parameters With Wildcards.

Calculations in Queries with Microsoft Access

  • 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.

Modifying Forms in Microsoft Access

  • Understanding Form Design and Layout.
  • Switching Between Form Views.
  • Selecting Form Objects.
  • Working With a Control Stack.
  • Changing Control Widths.
  • Moving Controls on a Form.
  • Aligning Controls.
  • Understanding Properties.
  • Changing Label Captions.
  • Adding an Unbound Control.
  • Adding a Control Source.
  • Formatting a Control.
  • Checking the Current Tab Order.
  • Changing the Tab Order.
  • Inserting the Date Into the Form Header.

Using a Microsoft Access Navigation Form

  • Creating a Simple Navigation Form.
  • Creating a More Complex Navigation Form.
  • Creating the Navigation Form Page Tabs.
  • Creating Subsidiary Pages.
  • Adding Subsidiary Pages.
  • Editing Page Tab Names.
  • Applying a Theme.
  • Modifying Properties.
  • Automatically Starting the Navigation Form.

DIY Forms in Microsoft Access

  • 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.

Creating and Using Macros in Microsoft Access

  • Understanding Macros and VBA.
  • Creating a Macro.
  • Running a Macro.
  • Modifying an Existing Macro.
  • Interacting With the User.
  • Stepping Through a Macro.
  • Documenting Macros.

Microsoft Access 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 in Microsoft Access

  • 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.

Microsoft Access Navigation Pane Protection

  • 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

Providing comprehensive and thorough coverage of intermediate use of Microsoft Access, this Access course is ideal for new or existing users seeking to learn Access tasks outlined in the course content.

Delivery Style

This Microsoft Access course is presented as a practical, instructor-led computer-based course in a Microsoft Windows environment. You’ll have dedicated access to a computer exclusively for your use so you can follow instructor training and work through examples.

BYOD (Bring Your Own Device)

This course is available to participants who are seeking a BYOD (Bring Your Own Device) course option. Participants are able to bring their own Windows laptop provided that they have a recent version of the software installed on their device. BYOD course participants are required to contact our team on 02 8262 6400 (Option 1) between 9AM to 5PM Monday to Friday before enrolling in the course. This option may also be available for any classes currently marked as full.

Course Prerequisites

This Microsoft Access course assumes some knowledge of the software 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 the Basic Computer Skills Course before attempting this course.

Get $25 off

Get $25 off

Receive a $25 gift voucher to use toward your first enrolment.



Available for alumni, concession cardholders, seniors, staff and students.

Employer Sponsorship

Employer sponsorship

Your employer may be willing to pay for your course. Find out more.


Need an invoice to make payment?

Use our invoice authorisation to request one for your organisation.


Training for groups of employees

Learn more about enterprise training for organisations.


Self service enrolment for organisations

CorporatePass enables you to enrol participants with deferred payment.

Course Features

Available dates for Microsoft Access Course: Level 2 (Intermediate)

This course has no dates available. Be the first to know when we schedule more. Join the waiting list.