Tel: 1300 TO TRAIN

Email: info@advancedtraining.com.au

IT Training with Advanced Training



Microsoft Access 2016 Level 2


Introduction

The aim of this course is to build on the introductory skills of Level 1. The student learns how to ensure that data is entered correctly, how to create more sophisticated and complex queries, and is introduced to some basic automation techniques involving macros. 

Outcomes

At the completion of this course, participants will 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.



User Reviews

Not yet rated. You will need to follow this course before you can write a review.

Course Info


Schedule

  • Melbourne
  • 21/05/2019 - 21/05/2019
  • 20/08/2019 - 20/08/2019
  • 15/10/2019 - 15/10/2019
  • 11/12/2019 - 11/12/2019
  • Canberra
  • 23/04/2019 - 23/04/2019
  • 18/07/2019 - 18/07/2019
  • Sydney
  • 27/05/2019 - 27/05/2019
  • Brisbane
  • 8/07/2019 - 8/07/2019
  • Adelaide
  • 27/06/2019 - 27/06/2019
  • Darwin
  • 23/04/2019 - 23/04/2019
  • 18/07/2019 - 18/07/2019

Next Step

Book Course Now
Enquire Now
Tell a Friend
Email Course Outline

Course files