Access 2016 (Introductory and Intermediate)

Learning Outcomes

By the end of this course participants will be able to:

• Understand how Access is used and how to navigate around it

• Design a database with lookup tables  

• Create a database structure using Access 2016

• Modify the structure of an existing table

• Add records to a new table

• Add transactional records to a lookup database

• Work with the records in a database table

• Sort and filter records in a table

• Create simple and effective queries

• Create meaningful reports from tables

• Create and use a variety of forms

Prerequisites

• It is recommended that participants have basic experience with the underlying operating system, i.e. an ability to navigate the environment using a mouse and keyboard plus an understanding of computer file storage.

Customisation

• In addition to our standard courseware, we can adapt course content and flow to your specifications.