Database Tables

Learn how to read, manipulate, and create Access XP database tables in this free lesson.

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).

Primary Key in a Table