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…

The correct answer is C. You cannot change the datatype of a previously defined field to the AutoNumber datatype. 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…

Building Tables

Question

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?

Options

AType a number and then select the AutoNumber datatype.
BClick on the Fields tab and then choose the AutoNumber datatype.
CYou cannot change the datatype of a previously defined field to the AutoNumber datatype.
DRight-click the field and choose the AutoNumber datatype.

How the community answered

(20 responses)

A
5% (1)
B
5% (1)
C
75% (15)
D
15% (3)

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.

Topics

#AutoNumber#datatype constraints#field modification#data types

Community Discussion

No community discussion yet for this question.

Full 77-885 Practice