At first glance, this window with its new menu bar, containing menus for File, Edit, View,
Insert, Format, Debug, Run, Tools, Add-Ins, Window, and Help, might be confusing. It opens
as a separate application window, but it is still very much a part of the Access application. In
fact, this window opens up a whole new ball game in terms of what you can do with Access.
In the next section, I’ll explain the windows in more detail.VBA Project Explorer and Code Windows
The Project Explorer, which shows a Project tree, is on the left-hand side of the screen, just
below the menu and toolbar. It shows the VBA project for the database as it stands,
displaying the details in tree form so you can easily navigate between them. Notice that it
will only show modules and class modules you have created. If you are used to using VBA in
Excel, you will have noticed that each workbook and worksheet has its own module and the
structure of modules reflects the sheets in your workbook.6 Microsoft Access 2010 VBA Macro Programming
Figure 1-3 The standard Visual Basic Editor window