Chapter 2. Access, VBA, and Macros

Chapter 1 introduced the various object designers available in Access to add functionality to your database. One of these, the Macro designer, enables you to add automation to your database, but at this point you're still not satisfied. Your database needs more. It is just about time to write some VBA code to work with your Access database. Before you do this, you'll need a basic understanding of VBA and how it is used in Access. This chapter covers the differences between VBA and macros in Access, as well as a bit about using VBA in Access. It also provides information about the differences you'll find between Access VBA and other forms of VBA, such as VBA in Excel or VBA in Word. Finally, this chapter takes a closer look at the new features that have been added to macros in Access 2007. Yes, that's right. New features.

Get Access™ 2007 VBA Programmer's Reference now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.