Center for Academic Computing:

It is advisable to create the primary key before entering data in a table because Access will prevent duplicate values being create in the designated field. It is particularly important to set a primary key when creating relationships between tables as Access uses it to link tables together. ................
................