Exam 5: Access: Maintaining a Database

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

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

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

A default value is a value that Access will display on the screen in a particular field before the user begins adding a record.

When you specify referential integrity, you need to decide how to handle the update of the primary key. What decisions do you need to make?

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

A List field allows the user to select from a list of values.

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

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

To indicate that the only allowable values for the Client Type field are MED, DNT, and LAB, enter ____ in the Validation Rule property box.

To back up a database, open the database to be backed up, click the Office Button, point to ____ on the Office Button menu, and then click Back Up Database on the submenu that appears.

Maintaining the database means modifying the data to keep it up-to-date, such as adding new records, changing the data for existing records, and deleting records.

To move from Layout view to Form view, click the ____ button.

To redisplay all records after using a filter, click the ____ button on the Home tab.

Backing up the database as well as compacting and repairing a database are database maintenance tasks.

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

Validation rules ensure validity of the data in the database, while entity integrity ensures the validity of the relationships.

Figure 3-3 To print a copy of a relationship, click the _____________________ button shown on the accompanying figure.