Description
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.
