Access 2003
Database Tables
Primary keys
Every table in Microsoft Access must have at least one field that uniquely identifies each record in the table. This field is known as a primary key. This primary key essentially opens the door to the table and allows you to retrieve information from the table.
The primary key is the mechanism by which you relate different tables and combine information for viewing (query) or printing (report).
