Mastering VBA for Microsoft Office 2016

Chapter 28Understanding the Access Object Model and Key Objects

If you work with Access databases, forms, or reports, you'll find that customizing Access using VBA can streamline your work and that of your colleagues. For example, you can program Access to automatically extract datasets you need, to create custom reports on a regular schedule, and to perform many other tasks.

Even if your work in Access consists simply of entering data into databases and checking that it is correct, you may want to create macros to make mundane tasks less onerous. For example, you can use VBA to simplify data entry or to validate data that the user enters to avoid problems further down the line.

However, because Access implements VBA in a different way from ...