nerdexam
Microsoft

77-885 · Question #71

Which of the following contains the names of the fields involved in the query and the criteria used to select records?

The correct answer is B. QBE grid. The QBE grid contains the names of the fields involved in the query and the criteria used to select records. In the QBE grid, each column consists of information about a single field from a query or table that is included in the upper pane. The image of the QBE grid is given…

Creating and Modifying Queries

Question

Which of the following contains the names of the fields involved in the query and the criteria used to select records?

Exhibit

77-885 question #71 exhibit

Options

  • ANavigation Pane
  • BQBE grid
  • CQuick Access Toolbar
  • DTitle bar

How the community answered

(18 responses)
  • A
    6% (1)
  • B
    72% (13)
  • C
    6% (1)
  • D
    17% (3)

Explanation

The QBE grid contains the names of the fields involved in the query and the criteria used to select records. In the QBE grid, each column consists of information about a single field from a query or table that is included in the upper pane. The image of the QBE grid is given below: Answer: C is incorrect. The Quick Access Toolbar in MS Access 2010 is a customizable toolbar which is displayed in the title bar of the Database window. It has a set of commands or functions (save, undo/redo, and print) that are independent of the tab on the ribbon currently displayed in MS Access. The Quick Access Toolbar can be moved from one of the two possible locations. A user can add any Access command as a button to the Quick Access Toolbar. Answer: A is incorrect. The Navigation Pane is displayed on the left side in a new or existing database. The pane contains different database Objects such as tables, queries, forms, reports, macros, etc. The database can be opened through the pane in different modes such as datasheet view, Design view, and layout view. A user can use the navigation Pane to show or hide the database objects. Answer: D is incorrect. The title bar is an area on the Database Window. It is used to show the name of the active database object.

Topics

#QBE grid#query design#query criteria#record selection

Community Discussion

No community discussion yet for this question.

Full 77-885 Practice