Absolute Beginner’s Guide to Databases

The Sample Northwind Traders Database

Figure 2.3 illustrates the main database form for an Access database. From this form, you can view the various objects in the database, as well as the data in the database.

The Database’s Relationships

To get a sense of the database’s purpose, you need to see the relationships among the various database entities. Figure 2.4 illustrates the relationship view for a database. In order to access the relationship view, you need to click the Relationship View button (also shown in Figure 2.4).

Figure 2.4. The relationship view enables you to view all the tables in a database as well as how the tables are related.

In reviewing the database diagram illustrated in Figure 2.4, the purpose of the Northwind Traders ...