Add a primary key

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.

Tools group on the Design tab

Leave a Reply

%d bloggers like this: