How to Set Primary Key in MS Access
When you create a table, you can define the primary key as part of the design process. Here’s how to do it:
- 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.
This website uses cookies to ensure you get the best experience on our website. Learn More
Got it