Chapter 2: Creating Access Tables
33
FIGURE 2.6Opening an obsolete Access data file invokes the Database Enhancement dialog box.
On the CD-ROM
The CD-ROM that comes with this book contains multiple database files. The completed file containing all the
data and other database objects is named CollectibleMiniCarsData.accdb.
The CD-ROM also contains a single example database file for most chapters in this book. The example file for a
chapter is named ChapterXX.accdb or ChapterXX.mdb, where XX is a chapter number. If a chapter uses
files where the data is split from the other objects, the names are usually ChapterXX_FrontEnd.accdb and
ChapterXX_BackEnd.accdb. This chapter describes building a single database file named
MyCollectibleMiniCars.accdb.
The Access 2010 Environment
The initial Access screen, after creating a new database, is shown in Figure 2.5. Across the top of
the screen is the Access ribbon, which was new at Access 2007 and replaces the toolbars and
menus seen in previous versions of Access. The ribbon is divided into a number of groups. I show
you each of the groups and the controls in each group in the next several chapters.The Navigation Pane
The Navigation Pane, at the left of the screen, is your primary navigation aid when working with
Access. By default, the list is filled with the names of tables in the current database, but it can also
display other types of objects by clicking on the drop-down list in the Navigation Pane’s title bar to
reveal the navigation options (shown in Figure 2.7).The Navigation Pane shows queries, forms, reports, and other Access object types. It can even dis-
play a combination of different types of objects.