nerdexam
Microsoft

77-885 · Question #125

You have created a table named Books in Microsoft Office Access 2010. You have created a new field to enter the Book ID. For this purpose, you need to set the Number datatype for the field. Which of…

The correct answer is A. Choose the Number datatype from the Formatting group. D. Simply insert a number in the field. In order to accomplish the task, you can do one of the following: Simply insert a number in the created field. When you insert a number in the field and press the 'Enter' key, Access automatically selects the Number datatype for that field. Choose the Number datatype from the…

Building Tables

Question

You have created a table named Books in Microsoft Office Access 2010. You have created a new field to enter the Book ID. For this purpose, you need to set the Number datatype for the field. Which of the following actions will you perform to accomplish the task? Each correct answer represents a complete solution. Choose all that apply.

Exhibit

77-885 question #125 exhibit

Options

  • AChoose the Number datatype from the Formatting group.
  • BRight-click the Field Header and choose the Number datatype.
  • CRight-click the field and choose the Number datatype.
  • DSimply insert a number in the field.

How the community answered

(28 responses)
  • A
    82% (23)
  • B
    11% (3)
  • C
    7% (2)

Explanation

In order to accomplish the task, you can do one of the following: Simply insert a number in the created field. When you insert a number in the field and press the 'Enter' key, Access automatically selects the Number datatype for that field. Choose the Number datatype from the Formatting group. Answer: B is incorrect. When you click on the Field Header, you do not find any option for the Answer: C is incorrect. When you right-click the field, you do not find any option for the datatype.

Topics

#data types#Number datatype#field configuration#table design

Community Discussion

No community discussion yet for this question.

Full 77-885 Practice