The primary key is an important field in an Access table. Please describe a primary key. Does Access create the primary key or can you create it yourself?
What will be an ideal response?
- 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 key. For example, you could use each contact's Social Security number as the primary key.
You might also like to view...
In Visual Basic we work with objects, which have ________________.
a. programmer preference b. projects and solutions c. classes and actions d. properties and methods
Windows does not include troubleshooting for networks.
Answer the following statement true (T) or false (F)