The primary key of a table is a table’s main index. In addition the field or fields that make-up the primary key are used to uniquely identify each record. No two records can have the same value stored in the primary key field. Open table in Design View. Click on the grey field selector to the left of the field name that we want to be the primary key, the field row will be selected. From menu bar choose Edit and then click on the primary key.