Part I: Access Building Blocks
34
FIGURE 2.7
Choosing an alternate display for the Navigation Pane
Here are the navigation options:
l (^) Custom: The Custom option creates a new tab in the Navigation Pane. This new tab is
titled Custom Group 1 by default and contains objects that you drag and drop into the
tab’s area. Items added to a custom group still appear in their respective “object type”
view, as described in the next bullet.
Tip
Custom groups are a great way to group dissimilar objects (like tables, queries, and forms) that are functionally
related. For example, you could create a Customers custom group, and add all the database objects related to
customer activities. Items contained in a custom group can appear in other groups as well.
l (^) Object Type: The Object Type setting is most similar to previous versions of Access.
When selected, Object Type transforms the selection list to display the usual Access
object types: tables, queries, forms, reports, and so on.
l Tables and Related Views: The Tables and Related Views setting requires a bit of
explanation. Access tries very hard to keep the developer informed of the hidden connec-
tions between objects in the database. For example, a particular table may be used in a
number of queries, or referenced from a form or report. In previous versions of Access,
these relationships were very difficult to determine, and no effective tool was built into
Access helping you understand these relationships.