Exam 5: Access: Querying a Database

The results of a query display in ____________________ view.

To create a crosstab,click the ____ button on the CREATE tab.

To create a parameter query,enter a parameter rather than a specific value as a criterion in the design grid.The parameter must be enclosed in ____.

The type of join that finds records from both tables that have identical values in matching fields is called a(n)____________________ join.

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 -Either individual criterion must be true in order for the compound criterion to be true.

-In the accompanying figure,Book Rep Number is the ____ key.

Joining tables in a query creates an ad hoc relationship,that is,a relationship between tables created for a specific purpose.

Crosstab queries are useful for summarizing data by category or group.

To use the Report Wizard to create a report for a query,select the query in the Navigation Pane,tap or click ____ on the ribbon,and then tap or click the Report Wizard button.

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 list.

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

A(n)____________________ function is a function that performs some mathematical function against a group of records.

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 collection of characters.

To use the Expression Builder to create a calculated field,select the column in the Field row,right-click to display the shortcut menu,and then click ____.

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 -Each individual criterion must be true in order for the compound criterion to be true.

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

To indicate grouping in Access,select ____ as the entry in the Total row for the field to be used for grouping.

-In the accompanying figure,the ____ line between matching fields in the two tables indicates that the tables are related.

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 -A mathematical operator for division.

You can include ____ in calculations to indicate which calculation should be done first.