Microsoft Access 2010 Bible

(Rick Simeone) #1

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.

Free download pdf