Question

Which data type can always be assigned to a field to be used as a primary key?

A. AutoNumber
B. Memo
C. Date/Time
D. Currency
E. Text

Answer 1

The AutoNumber data type can always be assigned to a field to be used as a primary key.

Step-by-step explanation:

The AutoNumber data type can always be assigned to a field to be used as a primary key. An AutoNumber field automatically generates a unique number for each record that is added to the table. This ensures that each record has a unique identifier, which is essential for a primary key.

For example, let's say we have a table for student records. We can use an AutoNumber field as the primary key, so each student will have a unique identifier.

The other data types listed, such as Memo, Date/Time, Currency, and Text, can also be used as field types in a table, but they may not always be suitable as primary keys.