The Primary Key Is an Important Field in an Access

Question

Examlex · Accepted Answer

The Answer is - A primary key is a field that uniquely identifies each record. It's very important that no two records are ever assigned the same value for this unique field.
- It's usually best to have Access create the primary key . If the ID field's data type is AutoNumber, Access automatically assigns a unique value to each record, beginning with 1 for the first record.
- As an alternative, you can select your own primary ke y. For example, you could use each contact's Social Security number as the primary key.

The Primary Key Is an Important Field in an Access

Definitions: