A Brief Review of the Access Database Designer

In Chapter 2, “The Anatomy of a Real Database,” you were introduced to the Access Database Designer elements. In this chapter, you will work with these elements. Before going further, let’s take a few moments to review the lay of the land, using the Northwind Trader’s database as an example. Figure 5.8 illustrates the main components of the Access Database Designer.

Figure 5.8. The Microsoft Access Database Design Interface.

The following sections briefly outline and describe the main database design components you will be working with in this chapter.

Main Database Window

There are two windows ...

Get Absolute Beginner’s Guide to Databases now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.