How to Set Primary Key in MS Access

Quick summary

Setting a primary key in MS Access ensures each record in a table is uniquely identified, which is essential for maintaining data integrity and enabling reliable table relationships. You can assign a primary key directly in Design View using the Primary Key button on the Table Design ribbon.

Steps

1. Go to the Create tab on the ribbon.
2. Click Table to create a new table.
3. Open the table in Design View.
4. Enter the field names and data types in the design grid.
5. Click the row selector for the field you want to set as the primary key.
6. Click the Primary Key button in the Table Design tab on the ribbon.
7. Confirm the primary key has been set successfully.
8. Click the Save button to save your table.