Which of the following is true regarding the AutoNumber data type?
A)A sequential AutoNumber will generate a random number that is unique to each record within the table.
B)AutoNumbers are a great method for ensuring that records are uniquely identified.
C)An AutoNumber is a field added to a table to serve as a foreign key that is unique and sequential when records are created.
D)A random AutoNumber is the most common and is the default setting in Access when selecting the AutoNumber data type.

Question

Quizplus · Accepted Answer

AutoNumbers are specifically designed to guarantee that every record in a table is uniquely identified. A sequential AutoNumber is the default setting in Access and will generate a unique, sequential number for each record in the table. A random AutoNumber is not the default setting and should be used only in specific situations where a sequential AutoNumber would not be appropriate. An AutoNumber is not necessarily added to a table to serve as a foreign key, though it can be used in this way.

Which of the Following Is True Regarding the AutoNumber Data