Got a question? Call 1800 853 276   |   

Access 2016 – Level 2

  • Length 1 day
  • Price $440 inc GST
Course overview
View dates &
book now
  • Register interest

Why study this course

The skills and knowledge acquired in this course are sufficient to be able to ensure that data is entered correctly, to create more sophisticated and complex queries, and be introduced to some basic automation techniques involving macros.

This course builds on the introductory skills of Level 1. You may also be interested in our Level 3 course which covers more advanced topics.

Request Course Information

By submitting an enquiry, you agree to our privacy policy and receiving email and other forms of communication from us. You can opt-out at any time.

What you’ll learn

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

  • Use various data validation features in Access to protect data

  • Format the data in a table

  • Perform more advanced queries using a variety of querying techniques

  • Create and use parameter queries

  • Create calculated queries

  • Modify and adapt an existing form according to specific needs

  • Create a navigation form for a database in Access 2016

  • Create forms using a combination of wizards and manual techniques

  • Create and use macros in Access

  • Work with a number of macro techniques

  • Create and work with macros in forms

  • Create and manage custom categories and groups in the Navigation Pane

Microsoft Apps at DDLS

DDLS is your best choice for training and certification in any of Microsoft’s leading technologies and services. We’ve been delivering effective training across all Microsoft products for over 30 years, and are proud to be Australia’s First and largest Microsoft Gold Learning Solutions Partner. All DDLS Microsoft courses follow Microsoft Official Curriculum (MOC) and are led by Microsoft Certified Trainers. Join more than 5,000 students who attend our quality Microsoft courses every year.

Stay ahead of the technology curve

Don’t let your tech outpace the skills of your people

Quality instructors and content

Expert instructors with real world experience and the latest vendor- approved in-depth course content.

Partner-Preferred Supplier

Chosen and awarded by the world’s leading vendors as preferred training partner.

Ahead of the technology curve

No matter your chosen technologies or platforms, we can help you stay one step ahead.

Who is the course for?

This course is designed for users who have an understanding of how tables are created, records are entered, modified and deleted, and how simple queries, reports and forms are created.

We can also deliver and customise this training course for larger groups – saving your organisation time, money and resources. For more information, please contact us on 1800 U LEARN (1800 853 276).

Course subjects

Data Validation

  • Assigning Default Values

  • Validation Rules and Text

  • Validating Numbers

  • Setting Required Fields

  • Working With Validations

Formatting Tables

  • 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

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

  • 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

Modifying Forms

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

  • 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

  • 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

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


This course assumes some knowledge of Microsoft Access 2016 to create basic databases and generate reports. It would be beneficial to have a general understanding of personal computers and the Windows operating system environment.

Terms & Conditions

The supply of this course by DDLS is governed by the booking terms and conditions. Please read the terms and conditions carefully before enrolling in this course, as enrolment in the course is conditional on acceptance of these terms and conditions.

Request Course Information

By submitting an enquiry, you agree to our privacy policy and receiving email and other forms of communication from us. You can opt-out at any time.