Chapter 5: Introducing the VBAProgramming Environment

Overview

In Part I we examined how not to program. We took a look at Access’s built-in tools that save us from the need to program. For example, in Chapter 4, we edited existing command bars and created customized ones.

Eventually, however, we reach a limit to what Access can do on its own. At that point, we need to call in VBA in order to give Access additional instructions.

In this chapter, we begin with a discussion of the history of VBA. From there we will have an overview of the components of VBA, including objects, procedures, attributes, and modules. We will be discussing a lot of the terminology associated with these components.

The chapter ends with an introduction to the place where you will be doing your VBA programming: the VBA Editor.