Add a primary key to a table in Access

Applies To
Access for Microsoft 365 Access 2024 Access 2021 Access 2019 Access 2016

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.

Primary key and foreign key shown between two Access datasheets

Tools group on the Design tab