Learn how to add and remove Primary Keys from an Access database table. The primary key's purpose is to promptly associate data from multiple tables and combine that data.

The Primary Key indicator appears as a side-arrow button on the left-side of the field name. You can change the primary key at any time however, there’s only one primary key for each table.