Home » Microsoft Access » 07 - Viewing Tables
7
Setting or Changing a Primary Key
Primary keys are what link records in one table to records in another. Here we go over how to set them.
How do you set a Primary Key?
- Open a table in design view.
- Select the field you want to define as the primary key.
- Click the primary key button on the toolbar.
Note: A Primary key is specified for a field containing data. If null/duplicate values exist then a message is generated. This can be resolved by choosing a different field, or adding an auto number field and setting it as the primary key or using a ‘find duplicates query’ to locate records with duplicate/null values.
