Exam 4: Access: Querying a Database

When you create a calculated field, users can update the field.

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

The ____________________ wildcard represents any collection of characters.

Business analysts at Camashaly would like to be able to calculate the total of their Salary YTD and their Incentive YTD.Assume that the result should be stored in a field called Total Compensation.What is the formula to calculate total compensation?

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

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

Filter By Query allows you to filter based on multiple criteria, for example, to find only those clients whose postal code is 27036 and whose amount paid is 0.

A(n)____________________ query adds, deletes, or changes data in a table.

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

A secondary key is a field in one table whose values are required to match the primary key of another table.

To find all clients whose amount paid is greater than $1,000.00 and whose business analyst is analyst 11, enter each criterion on different lines.

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

To change gridlines in a datasheet, open the table in Datasheet view, select the entire datasheet, and click the ____________________ button on the Home tab.

When specifying referential integrity, one way to handle the update of a primary key is to _________________________; that is, have Access allow the update but then automatically make the corresponding change in any related records in other tables.

To create a split form, select the table in the Navigation Pane, click Create on the Ribbon, and then click the ____ button on the Create tab to display a menu and click Split Form on the menu.

When you use a split form, you only can add records using the simple form.

You can restore filter settings that you previously saved in a query by using the ____________________ command on the Advanced menu.

To quit Access, click the ____ button on the right side of the Access title bar.