Access: Add and remove primary keys - how it works

In a database, each table can only have one primary key. This practical tip shows you how to add or remove it from Microsoft Access.

Add or remove primary key under Access

1. First open your database.
2. Then select the table on the left in which you want to add or remove the primary key.
3. Now right-click on the table name and select the item "Design view".
4. To assign the primary key to a row, you have to right click on it and go to "primary key".
5. Since the primary key can only exist once per table, it is automatically removed from the old selection.