This course code is no longer available for purchase. Click here for alternate dates/locations.

Access 2007/2010/2013/2016 Advanced

$AUD 830.00 (no GST applicable)

Access 2007/2010/2013/2016 Advanced (TITAA1705)


Course dates

This course is run over 2 session(s):

See below for alternative dates & locations, or return to the course overview

More Information

Delivered by Wizard Corporate Training

Course Location

Wizard Corporate Training
446 Collins Street Level 6
Melbourne, VIC 3000

 Location map

Course Overview

Gain an understanding of highest level database design so you can create more complex tables, queries, forms, reports and macros.


Two days

Learning outcomes

During this program you will increase your knowledge of how to:

  • Be more precise in your table, query, form and report design
  • Get the most out of your table designs
  • Generate statistics using complex calculations and pivot tables
  • Restrict end user access to the various objects within a database
  • Design an interface for to make it easy to access automated processes.


This course is suited to those who want to:

  • Fine tune your table design skills and learn advanced use of fields, indexes and properties
  • Create complex queries to extract and manipulate data and statistics
  • Design complex queries which reference criteria entered in forms
  • Gain a basic overview of simple SQL queries
  • Analyse statistical data through pivot tables and pivot charts
  • Learn advanced form design techniques, including multiple tab controls and form-specific default values and validation rules
  • Generate advanced reports using sub reports, running totals and multi column reports
  • Automate both simple and complex procedures using macros
  • Make it easy to access macros by customizing your interface
  • Enhance your database security
  • Set a database that allows access to multiple users over a network.


To gain the most from this course, ideally you should have experience in working with Microsoft Access 2007/2010/2013 at an intermediate level.

Alternative Dates/Locations for this course

Date Code Suburb or town Member Non-member Register
11 Jan 2018 TITAA1801
12 Apr 2018 TITAA1802
19 Jun 2018 TITAA1803

Login to your account

On-site Quote Request

Request an on-site training quote for Access 2007/2010/2013/2016 Advanced

This program can be customised to your needs and delivered on-site.

Quote request

Shopping cart

View your shopping cart.