Primary key in MS Access, add or Remove
- First, open your database.
- Then select on the left of the table in which you want the primary key to add or remove.
- Now you should do a right click on the table name and select "design view".
- The primary key of a row to assign, you need to make a right click on this and click the "primary key" go.
- Because the primary key may only occur once per table, it will automatically be removed from the old selection.

Access: add primary key
How you Access your user interface clean-up, we show you in our next practice tip.