How to Set Primary Key in MS Access
- George Apostolov
- 05 Sep 2025
Guide
Go to the 'Create' tab on the ribbon.
Click 'Table' to create a new table.
Open the table in 'Design View'.
Enter the field names and data types in the design grid.
Click the row selector for the field you want to set as the primary key.
Click the 'Primary Key' button in the 'Table Design' tab on the ribbon.
That's it! You have set the primary key in MS Access.
Click on the 'Save' button.
Create your first interactive demo in minutes
No credit card required • Start building today