This MSAccess tutorial explains the VBA environment in Access 2007 (with screenshots and step-by-step instructions).
This is what the VBA environment looks like in Microsoft Access 2007:
VBA standards for Visual Basic for Applications and is the language embedded within your database in Access 2007.
You use VBA whenever you do one of the following:
These are just some of the examples of when you might be running VBA code.
(scroll to see more)