Course Objectives

In this course, you will optimize an Access 2019 database. You will:

•   Provide input validation features to promote the entry of quality data into a database.

•   Organize  a database for efficiency and performance, and to maintain data integrity.

•   Improve the usability of Access tables.

•   Create advanced queries to join and summarize data.

•   Use advanced formatting and controls to improve form presentation.

•   Use advanced formatting and calculated fields to improve reports.