Chapter 24Getting Started with Access VBA


  1. Working with VBA
  2. Reviewing VBA terminology
  3. Understanding VBA code basics
  4. Creating your first procedure
  5. Adding branching constructs
  6. Learning looping constructs
  7. Understanding objects and collections
  8. 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.

Get Access 2016 Bible now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.