Exam 4: Access: Querying a Database

A(n)____ query adds a group of records from one table to the end of another table.

In the accompanying figure, the criterion for Current Due is 0.To find all clients whose current due amount is $2,000.00, erase the 0 in the Current Due column and enter _____ in the Criteria row of the Amount Paid column.

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

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.

To change the design of a query, right-click the query and then click ____ on the shortcut menu.

To organize entries in the Navigation Pane by table, click ____ on the Navigation Pane menu.

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

You can filter individual fields by clicking the arrow to the right of the field name and using one of the common filters that are available for the field.

For group calculations, Microsoft Access supports ____ built-in statistics.

To update records using an update query, enter the field to be updated in the design grid, enter any necessary criterion, and then click the ____ button to update the records.

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

If you plan to move your data to SQL Server at a later date, do not use ____________________ fields.

You can add a record to a table by ____.

The results of a query display in ____________________ view.

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

To print the results of a query that is open, click File on the Ribbon, click the _____ tab in the Backstage view, and then click Quick Print.

A(n)____________________ is a window containing the various properties of the object.