Exam 5: Access: Querying a Database

To sort records by amount paid within book rep number,specify Book Rep Number as the ____________________ key.

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

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

If a Security Warning appears when you open an Access database,tap or click the ____________________ button.

If the criterion for Current Due field is 0,the query results for this query will display ____ in the Current Due field.

To combine criteria with ____________________,each criterion must go on separate rows in the Criteria area of the grid.

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

To include calculated fields in queries,enter a name for the calculated field,a(n)____,and then the expression in one of the columns in the Field row.

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 comparison operator.

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 -Row that displays in the design grid when aggregate functions are used.

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

-The accompanying figure illustrates using a query to ____ tables;that is,to find records in two tables that have identical values in matching fields.

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 -An aggregate function.

To find all customers whose names begin with S,enter ____ in the Criteria row of the Customer Name field.

The expression for a calculated field can be typed directly into the Field row.

If you specify more than one sort key,the sort key on the left will be the major sort key and the one on the right will be the minor sort key.

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

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

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

To use a parameter query,press and hold or right-click the query in the Navigation Pane and then tap or click ____ on the shortcut menu.