You've covered many of the basic functions of Microsoft® Access®, and now you're ready to learn advanced Access features such as database management, advanced form design, packaging a database, encrypting a database, preparing a database for multiple-user access, and more. Knowledge of these features separates database professionals from the casual database users or occasional designers.

This course is the third part of a three-course Specialization that covers the skills needed to perform basic database design and development in Access. This course may be a useful component in your preparation for the Microsoft Access Expert (Microsoft 365 Apps and Office 2019): Exam MO-500 certification exam. Students taking this course are database administrators or prospective database administrators who have experience working with Access for Microsoft 365 and need to learn advanced skills. In this course, you will: share data across applications; use action, unmatched, and duplicate queries to manage data; create complex reports and forms; use macros to improve user interface design; use VBA to extend database capabilities; perform database management tasks such as backup, compacting, repairing, performance analysis, checking object dependencies, and documenting; and implement security strategies and distribute a database to multiple users. This course requires that you have Microsoft Access installed on a Windows PC. The course setup instructions provided in the first module of the course go into more detail about the hardware and software requirements.