INF1631 - Microsoft Access 2016 Intermediate

AUD$ 375
*
*
Academy IT strive to provide you with the training you need when you need it most. If you require a course and can’t attend on the dates provided or if they are not suitable to your staffing or project timelines – please call PH: (08) 7324 9800 to negotiate an alternative booking time.

About this course

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.

 

At Course Completion

After completing this course, students 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

 

Prerequisites

Microsoft Access 2016 - Level 2 assumes some knowledge of the software 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.

To view the course outline please ensure you have Adobe Reader installed.

Get Adobe Reader

Download INF1631 - Microsoft Access 2016 Intermediate (PDF)

| Powered by nopCommerce