Access 2007/2010/2013/2016 Advanced

$AUD 830.00 (no GST applicable)

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

Available

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
Australia

 Location map

Course Overview

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.

Alternative Dates/Locations for this course

Date Code Suburb or town Member Non-member Register
02 Nov 2017 TITAA1705
Melbourne $789.00 $830.00
06 Nov 2017 TITAA1706
Melbourne $789.00 $830.00

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.