Microsoft Access 2019/2021 Course (Level 2)

Building on your existing knowledge of Microsoft Access, this course will take you to the next level of database design and management. You will deepen your understanding of relational database design, enhance data input accuracy, boost database efficiency and maintain data integrity, and learn to utilize advanced features like tables, queries, forms, and reports. The outcome of the course will be a highly functional database that caters to your users’ needs.

The Microsoft Access course (Level 2) is part of a three-part series that covers all the skills required for database design and development in Access 2019/2021. Level 1 focuses on designing and constructing a database, including viewing, navigating, searching, and entering data, as well as basic relational database design and creating simple tables, queries, forms, and reports. Level 2 (this course) centers on optimizing the database, including improving performance and normalizing data, data validation, usability, and advanced queries, forms, and reports. Level 3 delves into managing the database and supporting complex designs, including data import and export, action queries, creating complex forms and reports, macros and VBA, and tools and strategies for managing, distributing, and securing the database.