You are working on a table named Employees created in Microsoft Office Access 2010. You want to
change the datatype of a previously defined field of the table to the AutoNumber datatype. What
will you do?
A.
Type a number and then select the AutoNumber datatype.
B.
Click on the Fields tab and then choose the AutoNumber datatype.
C.
You cannot change the datatype of a previously defined field to the AutoNumber datatype.
D.
Right-click the field and choose the AutoNumber datatype.
Explanation:
You cannot change the datatype of a previously defined field of the table to the AutoNumber
datatype. If you try to change the datatype, you will get the following error:Once you enter data in a table, you can’t change the data type of any field to AutoNumber, even if
you haven’t yet added
data to that field.
You should simply add a new AutoNumber field and start working with this field.
Answer D, A, and B are incorrect. You cannot change the datatype of a previously defined field of
the table to the AutoNumber datatype by these steps.