Exam 5: Access: Querying a Database

To calculate statistics for only those records that satisfy certain criteria,select ____ as the entry in the Total row for the field,and then enter the criterion in the Criteria row.

To find all customers whose returns are greater than $0.00 and whose book rep is book rep number 42,enter each criterion on the same row.

To show the Navigation Pane if it is hidden,click the ____ Button.

You cannot create a report for a query.

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. a.* f.NOT b.? g.BETWEEN c./ h.OR criterion d.Total i.IN e.AND criterion j.FIRST -Use to select values in a given range.

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

To find all customers whose names begin with S,enter S? in the Criteria row of the design grid.

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

In fixed-width files,each record is on a separate line and the fields are separated by a special character.

To find all customers whose names begin with Sr,enter ____________________ as the criterion for the Customer Name field.

The asterisk (*)wildcard represents any collection of characters.

MATCHING Identify the letter of the choice that best matches the phrase or definition. a.* f.NOT b.? g.BETWEEN c./ h.OR criterion d.Total i.IN e.AND criterion j.FIRST -Represents any individual character.

To view the results of a query,open it by pressing and holding or right-clicking the query in the Navigation Pane and tapping or clicking ____ on the shortcut menu.

To re-use saved export steps,tap or click the Saved Exports button on the ____ tab on the ribbon.

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

To combine criteria with ____________________,place the criteria on the same row.

The ____________________ function finds the smallest value in a group of records.

The ____ operator allows you to search for a range of values in one field.

To find all individuals whose name is Robin or Robyn,enter ____ in the Criteria row of the appropriate column.