How to Set Primary Keys in Access

In Access, you can use the following method to detect and set a primary key:

1. When creating a table in Design view, select the fields you want to set as primary keys and click on the “Primary Key” button on the toolbar. This will add a primary key symbol next to the selected fields.
2. Select a field on the table in design view, then in the “Field Properties” pane, set the “Primary Key” property to “Yes”.
3. When creating a query in the Design View, you can choose the fields you want to set as primary keys and select “Primary Key” in the “Query Type” group on the “Query tools” tab.

Regardless of the method used, Access will confirm the uniqueness of the primary key and ensure there are no duplicate values. If attempting to insert a duplicate primary key value, Access will throw an error and prevent the insertion operation.