Access 2007/2010/2013/2016 Advanced

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

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

Duration

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.

Participants

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.

Pre-requisite

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

Login to your account

Contact the Victorian Chamber of Commerce and Industry

On-site Training Quote

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