O'Reilly logo

Hands-On Microsoft Access: A Practical Guide to Improving Your Access Skills by Bob Schneider

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Exclusive Identification

One principle of database design that I'd like to re-emphasize is that a primary key should exclusively identify the value of each field within a given record. Each field value for any particular record should be unique in the database, except where it's used as matching data for establishing a relationship. If the primary key doesn't exclusively identify the field, either it's unnecessary or it belongs in another table.

This is a difficult concept to comprehend. Let's look at the final list of tables and fields in Table 3.26 to see how it applies. Consider the table Programs, where ProgramID is the primary key. Each of the nonkey fields—Name, Location, Synopsis, Notes—is uniquely identified by the primary key. GenreID ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required