nerdexam
Microsoft

77-885 · Question #34

You work as a Database Designer for Tech Perfect Inc. The company has a Windows Vista-based computer that has Microsoft Office 2010 installed on it. The computer has a database named Sales created…

The correct answer is B. Select the column and click on the Ascending button. C. Right-click on the column header and choose the Sort Smallest to Largest option. In order to accomplish the task, you will have to perform one of the following tasks: Select the column and click on the Ascending button. Right-click on the column header and choose the Sort Smallest to Largest option. Both these tasks will display the incomplete or missing…

Building Tables

Question

You work as a Database Designer for Tech Perfect Inc. The company has a Windows Vista-based computer that has Microsoft Office 2010 installed on it. The computer has a database named Sales created in Microsoft Office Access 2010. The database contains a table named Products. Some records in the table are incomplete or missing. You need to complete the records. For this reason, you want to rearrange the table in such a manner that it displays the incomplete or missing records on the top of the respected column. What will you do to accomplish the task? Each correct answer represents a complete solution. Choose two.

Exhibit

77-885 question #34 exhibit

Options

  • ASelect the column and click on the Descending button.
  • BSelect the column and click on the Ascending button.
  • CRight-click on the column header and choose the Sort Smallest to Largest option.
  • DSelect the column and click on the Toggle Filter button.

How the community answered

(25 responses)
  • A
    12% (3)
  • B
    80% (20)
  • D
    8% (2)

Explanation

In order to accomplish the task, you will have to perform one of the following tasks: Select the column and click on the Ascending button. Right-click on the column header and choose the Sort Smallest to Largest option. Both these tasks will display the incomplete or missing records on the top of the column as shown in the image given below: Answer: A is incorrect. When you perform this, you get the incomplete or missing records on the bottom of the column. Answer: D is incorrect. The Toggle Filter option is used for filtering the data of a table.

Topics

#sorting#ascending sort#null values#missing records

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 77-885 Practice