Microsoft Exam 77-885 Topic 10 Question 13 Discussion

Actual exam question for Microsoft's exam

Question #: 13
Topic #: 10

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?

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.

Show Suggested Answer

Suggested Answer: C

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.

by Nieves at May 03, 2022, 09:09 AM

Limited Time Offer

25%

Off

Get Premium Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!