Microsoft Access 2021 Advanced

A refined and professional database application can require varying levels of customization. Mastering the basics of the Visual Basic for Applications programming language is an important skill, which is why this course will show you how to write custom code for use in your Microsoft Access 2021 applications. It will also show you how to turn your custom code into custom functions that can be used in validation rules, conditional formatting, calculated values, and custom queries. Learning how to use flexible database application design architectures to create distributed database applications can allow you to create an environment for distributed users. Microsoft Access also has numerous security measures you can use to protect sensitive data within your database and the database file, as well as protect yourself from malware that could be contained in database files or add-ons downloaded from the internet.

In this course, you will learn about application design and customization, including the many startup options offered by Microsoft Access. We will also discuss how to design distributed and split databases and how to write custom code using Visual Basic for Applications. We will also explain the best practices to help end users get their work done easily and efficiently, as well as how to secure your data and protect yourself from malware.