A primary key uniquely identifies a record in a database. For example, when you call up your credit card company they almost always first ask for your credit card number. Other agencies may ask for your social security number and then ask you to wait while they "pull up your record." In both cases the number (credit card or social security) is used as the primary key in their database. It uniquely identifies your record.
So one use of a primary key is to retrieve a specific record. Another use is to define relationships between tables in your database. Defining relationships between tables is an advanced topic only mentioned in this course.
You may have noticed the following message when creating a new table:
If you think your database will ever have more than one table (a likely possibility), you should select Yes.
Copyright 1997 by the Curators of the University of Missouri