Exam 3: Querying a Database

To change the design of a query that is not currently open, right-click the query in the Navigation Pane and then click  ____________________ on the shortcut menu.

To display the Join Properties dialog box, right-click the join line and click ____ on the shortcut menu.

In the accompanying figure, the Client table was added to the query by selecting the table and clicking the Add button in the ____ dialog box.

A question that is asked of Access or any other database management system is called a(n) ____________________.

In the accompanying figure, the lower pane in the window where you enter criteria is called the ____.

After you create and save a query, you can use it in a variety of ways. Name three of these ways.

To find all clients whose amount paid is greater than $1,000.00 or whose business analyst is analyst 11, enter each criterion on the same line.

The accompanying figure shows a join of the Business Analyst and Client tables. ____________________ joins are used to show all the records in one table as well as the common records; that is, the records that share the same value in the join field.

To include all fields in the design grid, double-click the question mark (?) in the field list.

The accompanying figure shows a join of the Business Analyst and Client tables. If two tables have matching fields, that is, fields with the same name, Access draws a line called a(n) ____________________ line between the matching fields to indicate that the tables are related.

For group calculations, Microsoft Access supports ____ built-in statistics.

To enter a criterion for a particular field without displaying the field in the results of the query, include the field in the design grid, enter the criterion, and remove the check mark from its Show check box.

In the accompanying figure, Amount Paid is the ____ key.

To print the results of a query that is open, click File on the Ribbon, click the _____ tab in the Backstage view, and then click Quick Print.

To use the Report Wizard to create a report for a query, select the query in the Navigation Pane, click _____ on the Ribbon, and then click the Report Wizard button.

When tables are joined in a query, it is not possible to restrict retrieval by using criteria.

To find all clients whose names begin with Gr, enter _____ in the Criteria row of the Client Name field.

When you sort data, duplicates normally are included.

When you enter text data in a criterion, you must enclose the text in quotation marks.

When you sort data in a query, the records in the underlying table are actually rearranged.