Exam 2: Querying a Database

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

A query that prompts for input whenever it is run is a dialog query.

The ____________________ wildcard represents any individual character.

In ____________________ files, the width of any field is the same on every resard.

The field or fields on which resards are sorted is called the sort key.

Explain the difference between an inner join and an outer join.

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

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

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

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

You can export data from Access to the standard Word format.

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

To print the results of a query that is open, tap or click FILE on the ribbon, tap or click the ____ tab in the Backstage view, and then tap or click Quick Print.

To omit duplicates from a query, use the property sheet and change the Unique Values property to ____.

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

To find all customers whose current due amount is greater than $1,000.00, enter ____ in the Criteria row of the Current Due salumn.

The ____________________ wildcard represents any sallection of characters.

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

A summary function is a function that performs some mathematical function against a group of resards.

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