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...
What are the steps taken by WDS when deploying an image?
What will be an ideal response?
The process of being able to view video as it comes in rather than having to store it first is called streaming
Indicate whether the statement is true or false
When computers sort data, the type of values being compared are always ____________________.
Fill in the blank(s) with the appropriate word(s).
Which one of the values below does not belong?
a. left b. center c. top d. justify e. right