Chapter 2: Creating Access Tables
35
Figure 2.8 shows how the Tables and Related Views works. The Categories group
has been expanded to show that nine other in the Northwind Traders database are all
related to the Categories table. This information helps a developer to understand that
changing the Categories table affects a number of other objects in the database.
FIGURE 2.8
The Tables and Related Views setting is a powerful tool for analyzing an Access
database.
In addition to the Categories group, there are several other table-related groups, such as
Customers, Employees, Order Details, and so on.
l (^) Created Date and 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.
l 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 (refer to Figure 2.7). For example, selecting Created Date changes the
options under Filter By Group to the following options: Today, Yesterday, Last
Week, Two Weeks Ago, and so on.