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 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 (see Figure 34-7).

FIGURE 34-7
Choosing an alternate display for the Navigation pane.

The navigation options are:

• 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 next.
• 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.
• Tables and Related Views: The Tables and Related Views setting requires a bit of explanation. Access 2007 tries very hard to keep the developer informed of the hidden connections between objects in the database. For instance, 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, before Access 2007, no effective tool was built into Access to help you understand these relationships. Figure 34-8 shows how the Tables and Related Views works. The Shipp ers table has been expanded to show that it is related to six other objects in the Northwind Traders database. This information helps a developer to understand that changing the Shippers table affects a number of other objects in the database.

  FIGURE 34-8
  The Tables and Related Views setting is a powerful tool for analyzing an Access database.

  

• Created Date, Modified Date: These options group the database objects by either the created date or the modified date. These settings are useful when you need to know when an object was either created or last modified.
• Filter By Group: The Filter By Group option filters the selected object type (tables, forms, and so on) by a number of grouping options. The grouping option is determined by the navigation category chosen in Navigate To Category selected at the top of the Navigation pane. For instance, selecting Created Date changes the options under the Filter By Group to the following options: Today, Yesterday, Last Week, Two Weeks Ago, and so on. The Filter By Group option is really only helpful when you have a fairly large number of objects in your Access database. If you have an Access database containing several hundred different forms, you’ll find it very useful to filter by forms that were modified within the last week or so. But when there are only a few objects in a database, the Filter By Group option has little effect.
• Unrelated Objects, All Tables: These options appear in Figure 34-7 because the Tables and Related Views is selected as the primary navigation option. The Unrelated Objects is the opposite of the Tables and Related Views. When selected, the Unrelated Objects option shows you all of the objects that are not related to the selected table, query, or other Access object.

The All Tables setting is the default when choosing to view tables in the database.

• Business Marketing Performance Objectives and Indicators (download a pdf version) This diagram needs an orientation... First, the diagram shows different types of coloured box that have...
• Annoucement: The Ultimate 6 Figures Strategy Guide is Now Ready ! Finally! The Ultimate 6 Figures Strategy Guide is now ready for download! Below is the Table of Content. This Guide...
• Snowboarding Glossary Continued Sky - This is a term that is used to describe when big air is achieved by a rider. Slalom...
• Top Best 100 Incredibly Useful & Free Mac Apps [/caption] Everyone loves free applications. One of the greatest things about Macs is the wealth of extremely talented developers that...
• Lake Pillsbury    Lake Pillsbury   Lake Pillsbury is located in: Upper Lake, CA Phone: (707) 275-2361 About the Lake: Lake Pillsbury...