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...
Proper collection of evidence and handling procedures must be followed to ensure the evidence is ________
Fill in the blank(s) with correct word
The efficiency of the binary search is ____.
A. O(n) B. O(n log n) C. O(log n) D. O(n/2)