Chapter 23: Getting Started with Access VBA


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.

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

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