Add a primary key to a table in Access
Add a primary key to a table
Create a primary key to associate data between multiple tables.
In the Navigation Pane, right click a table, and select Design View.
Select the field or fields you want to use as the primary key.
Select Design > Primary Key.
For more info, see Add or change a primary key.