Exam 4: Maintaining a Database

To indicate that the only allowable values for the Client Type field are NON, RET, and SER, enter ____ in the Validation Rule property box.

To remove a total row that appears in a datasheet, click the ____ button on the Home tab.

To move from Layout view to Form view, click the ____ button on the Access Status bar.

A(n) _____ field is a field that can be computed from other fields.

To create a multivalued field, create a ____ field being sure to check the Allow Multiple Values check box.

When an update query is created, a(n) _________________________ row displays in the design grid.

Maintenance of a database can involve the need to _________________________ periodically; that is, to change the database structure.

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

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.

Filter By Query allows you to filter based on multiple criteria, for example, to find only those clients whose postal code is 27036 and whose amount paid is 0.

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

A(n) ____________________ is a form that allows you to simultaneously view both simple form and datasheet views of the data.

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 click the _____ tab in the Field Properties pane.

As an alternate to using the Find button shown in the accompanying figure, you can press ____ to search for a specific record.

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

To add a record using the form shown in the accompanying figure, click the ____ button on the Navigation bar.

Looking for the client whose number is GF56 is an example of searching.

Explain what happens if you upsize a database containing multivalued fields to SQL Server.

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