A good primary record key to use for a table of employee records that you might create in Access is the employee's last name.

Question

Quizplus · Accepted Answer

While last name could be a candidate key, it is not always unique and there is always the possibility of two employees having the same last name. It is better to use a unique identifier such as an employee ID or social security number as the primary key for employee records.

A Good Primary Record Key to Use for a Table