© 2020 by RPBC

  • Facebook Social Icon

Access 2016 Level 1

The skills and knowledge acquired in Microsoft Access 2016 - Level 1 are sufficient to be able to create database systems, enter, edit and delete data in database files, produce information in forms and reports and generate queries on the data.


Learning Outcomes

At the completion of this course you should 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

  • 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 forms

Access 2016 Level 2

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.


Learning Outcomes

At the completion of this course you should 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

Access 2016 Level 3

The skills and knowledge acquired in Microsoft Access 2016 - Level 3 are sufficient to design and create a multi-table database and automate operations using macros and have a general understanding of the programming environment in 
Microsoft Access 2016.


Learning Outcomes

At the completion of this course you should be able to:
 

  • Design a relational database project

  • Create a relational database file with multiple tables

  • Set table relationships and join tables together

  • Export records to and import records from a wide variety of sources and applications

  • Create queries based on one or more tables

  • Create and work with aggregation queries

  • Create and use a series of action queries

  • Make your Microsoft Access data and computer more secure

  • Understand and use a variety of tools that ensure the wellness of your database files

  • Create some simple programming code using VBA