Exam 6: Access: Maintaining a Database

To change the list of choices in a single or multivalued lookup field,open the table in Design view,select the field to be modified,and tap or click the ____ tab in the Field Properties pane.

MATCHING Identify the letter of the choice that best matches the phrase or definition. a.append query f.validation text b.delete query g.required field c.make-table query h.default value d.update query i.calculated field e.validation rules j.< -Allows you to add the results of a query to an existing table.

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

The button on the Access status bar that displays a form in Form view is Form View.

In the Bavant Publishing database,a one-to-many relationship exists between the Book Rep table and the Customer table.

Filter By Query allows you to filter based on multiple criteria,for example,to find only those customers whose returns are $0.00 and whose book rep number is 42.

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

When specifying referential integrity,one way to handle deletions is to _________________________;that is,have Access allow the deletion but then automatically delete any related records in other tables.

If you add a field to a table and later realize the field is in the wrong location,you can move the field.To move the field,tap or click the ____________________ for the field and then drag the field to the new location.

To save validation rules,default values,and formats,tap or click the Save button on the ____ to save the changes.

To print a copy of a relationship,tap or click the _____________________ button shown on the accompanying figure.

The property that the value in a foreign key must match another table's primary key is called _________________________.

To change a query so that each item in a multivalued field occurs on a different row,use the ____ property.

To create a validation rule for the State field to restrict entries to TN or TX,enter ____ in the Validation Rule property box.

You can use the Find button on the HOME tab to search for records in datasheets,forms,query results,and reports.

You can use a make-table query to create an archive table.

To create an update query,create a new query and then tap or click the ____ button on the DESIGN tab.

MATCHING Identify the letter of the choice that best matches the phrase or definition. a.append query f.validation text b.delete query g.required field c.make-table query h.default value d.update query i.calculated field e.validation rules j.< -A value that Access will display on the screen in a particular field before the user begins adding a record.

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

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