Chapter 23: Getting Started with Access VBA
IN THIS CHAPTER
Working with VBA
Reviewing VBA terminology
Understanding VBA code basics
Creating your first procedure
Adding branching constructs
Learning looping constructs
Understanding objects and collections
Exploring the Visual Basic Editor
Most Access developers use macros now and then. Although macros provide a quick and easy way to automate an application, writing Visual Basic for Applications (VBA) modules is the best way to create applications. VBA provides data access, looping and branching, and other features that macros simply don't support — or at least not with the flexibility most developers want. In this chapter, you learn how to use VBA to extend the power and usefulness of your applications.
On the Web
Download the database file Chapter23.accdb from this book's website.