Exam 4: Maintaining a Database

To add the Business Analyst and Client tables to the Relationships window shown in the accompanying figure, click the Add button in the ___________________ dialog box.

One reason to include a foreign key for a table is to eliminate duplicate records.

To order the records in the Client table by city in alphabetical order, use the ____ button.

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

The Unfilter button toggles between filtered and unfiltered displays of the records in a table.

To find records in one table that have no matching records in another table, use the _____ Query Wizard.

To delete a field from a table, open the table in ____ view, click the row selector for the field to be deleted, and then press the DELETE key.

When a filter is in effect, you can redisplay all records by clicking the ____ button on the Home tab.

A(n) ____ query adds records from an existing table to a new table, that is, a table that has not yet been created.

Restructuring the database includes adding new fields to a table, changing the characteristics of existing fields, and removing existing fields.

Normally, Access prohibits the deletion of a record in which the primary key matches a foreign key in another table.

Modified Multiple Choice Computations available for the Total row in a column that contains currency include ____.

To use the shortcut menu to create an update query, right-click any open area in the upper pane, point to ____ on the shortcut menu, and then click Query Type on the submenu that appears.

When you have created a filter using Advanced Filter/Sort, you can save the filter settings as a query by using the ____________________ command on the Advanced menu.

A(n) _________________________ is a field in one table whose values are required to match a primary key in another table.

You can convert a Number field to a Currency field but you cannot convert a Currency field to a Number field.

Modified Multiple Choice Maintaining a database can include ____.

To open a form in Form view from the Navigation Pane, right-click the form and click Form View on the shortcut menu.