Exam 17: Access: Maintaining a Database

You can search for a record in Form view but not in Datasheet view.

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

Validation rules can indicate a ____.

As an alternate to using the Find button,you can press ____ to search for a specific record and display the Search and Replace dialog box shown in the accompanying figure.

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

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 order the records in the Customer table by city in alphabetical order,use the ____ button.

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

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.

Case 3-1 Bavant Publishing has decided to add some additional validation rules to the Customer table shown in Design view in the accompanying figure.They have asked you to create these validation rules. -Because many of the customers that Bavant Publishing services are located in Pennsylvania,management would like to minimize any data entry in this field.What property do you need to change and what would you enter in the property box?

Maintaining a database can include ____.

The wildcard symbols for use with filters are ____.

When you use Advanced Filter/Sort to filter records using complex criteria,create the filter and then tap or click the ____ button on the HOME tab to view the results.

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

To display the Total row in a datasheet,tap or click the Sum button on the ribbon.____________________

A multilookup field is a field that contains more than one value.____________________

The relationship in the accompanying figure was created by tapping or clicking the ____________________ check box in the Edit Relationships dialog box.

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

Identify the letter of the choice that best matches the phrase or definition. -Rules that a user must follow when entering data.

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