O'Reilly logo

Mastering VBA for Microsoft Office 2016 by Richard Mansfield

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required