Exam 4: Access: Querying a Database

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

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

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

After you create and save a query, you can use it in a variety of ways. Name three of these ways.

Figure 2-2 In the accompanying figure, the criterion for Current Due field is 0. The query results for this query will display ____ in the Current Due field.

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

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

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.

If a Security Warning appears when you open a database, click the ____ button to display the Microsoft Office Security Options dialog box.

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

Critical Thinking Questions Case 2 Recruiters at JSP would like to be able to calculate their current commissions. Current commission is the result of multiplying Current Due by Rate. Assume that the result should be stored in a field called Current Commission. What is the formula to calculate current commission?

To use the Simply Query wizard to create a query, click the ____ tab on the Ribbon and then click the Query Wizard button.

To find all clients whose amount paid is more than $20,000.00, use the ____________________ operator.

When you sort data, duplicates normally are included.

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

____________________ joins are used to show all the records in one table as well as the common records; that is, the records that share the same value in the join field.

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