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.

Computer Science & Information Technology

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

Computer Science & Information Technology

Windows does not include troubleshooting for networks.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology