How to Add Primary Keys
A Microsoft Access database should have a primary key to avoid duplicate entries from occurring. In a database, each entry is located in a record and each record is stored in a field that makes up a table. Microsoft defines a primary key as "a field or set of fields with a unique value for each record stored in the table." Access allows the addition of a primary key to any database you create.
Other People Are Reading
Instructions
-
-
1
Open the Microsoft Access database you want to edit.
-
2
Right-click on the table that you want to add the Access key to.
-
-
3
Select "Design View" from the shortcut menu.
-
4
Click the field in the table that you want to designate as the primary key.
-
5
Click the "Design" tab on the menu bar, and then click the "Primary Key" icon in the "Tools" group. A key icon will display to the left of the selected field. Press the "Ctrl" and "S" keys simultaneously to save the changes.
-
1
