Exam 5: Access: Maintaining a Database

To preview data to be deleted in a delete query, click the ____ button after you create the query, but before you run it.

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.

Changing a column width changes the format , or design, of a table.

The simplest type of filter is called Filter By Form.

To create a Lookup field, select ____________________ from the menu of available data types.

Figure 3-2 To delete record EA45 shown in the accompanying figure, click the record selector in the datasheet for the record on which the client number is EA45 and then press ____.

Critical Thinking Questions Case 2 JSP Recruiters has just realized that they need to make some additional changes to the Client table shown in Design view in the accompanying figure. They have asked you to make these changes. Figure 3-4. JSP would like to add a telephone number field to the Client table. The field should appear after the postal code field. What do you need to do to add the field?

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

To specify that entries in the Amount Paid field must be between $0.00 and $100,000.00, enter ____ in the Validation Rule property box.

The command on the shortcut menu that displays data in Form view is Form View.

Six guidelines are available for you to use when determining database maintenance tasks. What are these six guidelines?

Critical Thinking Questions Case 1 JSP Recruiters has decided to add some additional validation rules to the Client table shown in Design view in the accompanying figure. They have asked you to create these validation rules. Figure 3-4 JSP would like to make sure that if an employee enters the letters co in the State field that it displays in the database as CO. What property do you need to change and what would you enter in the property box?

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

To create a simple form, select the table in the Navigation Pane, click Create on the Ribbon and then click the ____ button on the Create tab.

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

If the TAB key is used to move from field to field in a record, press F2 to produce an insertion point in a field.

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