Exam 3: Querying a Database

You cannot create a form for a query.

To enter a number in a criterion, type the number without any dollar signs or commas.

To change the design of a query, right-click the query and then click ____ on the shortcut menu.

____________________ are symbols that represent any character or combination of characters.

To save a query, click the Save button on the ____.

In the accompanying figure, Business Analyst Number is the ____ key.

Unless you specify otherwise, Access assumes that the criteria you enter involve equality (exact matches).

To include the Total row in the design grid, click the _____ button on the Design tab.

To include all fields for a table in the design grid, click the ____________________ in the field list .

In the accompanying figure, you can remove a column by clicking just above the field name to select the column and then clicking the ____ key(s).

To change the caption for a field in a query, click the field in the design grid, click the _____ button on the Design tab, click the Caption box, and enter the new caption.

The caption for the Incentive YTD field should be Inc YTD when the query results display. How can Camashaly change the caption?

Wildcards are symbols that represent any character or combination of characters.

The only calculated fields you can create in Access are those involving addition.

To create a new query in Design view, click Create on the Ribbon to display the Create tab and then click the ____ button to create a new query.

To sort records in a query, specify the sort order in the _____ row of the design grid below the field that is the sort key.