Datasheet
Using the Navigation pane
The Navigation pane is where you access the objects in your database. You can collapse
the Navigation pane so you have more room to work with the database objects. You can
also change how the objects are listed in the Navigation pane. Figure 1-4 shows a few dif-
ferent views in the Navigation pane.
Exercise 1-9: Manipulating the Navigation Pane
In this exercise, you change the look of the Navigation pane. Open the Exercise1-9.
accdb
file in the Chapter01 folder and do the following:
Click the Shutter Bar Open/Close button to alternate between collapsed and open
views.
Press F11 to alternate between collapsed and open views.
With the Navigation pane open, click the drop-down list icon to the left of the
Shutter Bar Open/Close button and click Object Type to list the objects by type
(tables, queries, forms, reports, macros, modules). In this view, you can
expand/collapse each section using the arrows.
Click the drop-down list icon and select Tables and Related Views to see the
objects listed by what table each object is based on.
Click the drop-down list icon and select Created Date to see the objects listed by
when they were created.
Click the drop-down list icon and select Modified Date to see the objects listed by
when they were last modified.
In each open view, click the drop-down list icon and select a different option under
Filter by Group to narrow the list of objects. This is particularly useful when your
database contains many objects.
Experiment with the different views and use whichever one works best for you. What
works in one database may not work in another.
Figure 1-4:
Different
views of the
Navigation
pane.
19
Chapter 1: Getting Started with Access
05_179536 ch01.qxp 10/29/07 7:47 AM Page 19