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.

1. In the Navigation Pane, right click a table, and select Design View.

2. Select the field or fields you want to use as the primary key.

3. Select Design > Primary Key.

For more info, see Add or change a primary key.