Name: 

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

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

To add a new record using Form view, click the Add Record button on the Navigation bar.

The Find button is available only in Form view.

You cannot apply a filter to the results of a query.

A change in outside regulations could cause changes to the structure of a table.

If you plan to move your data to SQL Server at a later date, do not use multivalued fields.

Access includes only three types of action queries: delete, update, and append.

Validation rules are rules that a user must follow when entering the data.

In the JSP Recruiters database, a one-to-many relationship exists between the Recruiter table and the Client table.

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 ____.

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

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

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

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

To order the records in the Client table by city in alphabetical order, use the ____ button.

When a database is damaged, you must return the database to a correct state. This process is called ____.

To close a database without exiting Access, click the Office Button and then click ____ on the Office Button menu.

To check for dependent objects, select the object that you want to check, click Database Tools on the Ribbon, and then click the ____ button on the Database Tools tab.

To delete a table or other object, right-click the object and then click ____ on the shortcut menu.

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

When you have created a filter using either Filter By Form or Advanced Filter/Sort, you can save the filter settings as a query by using the ____________________ command on the Advanced menu.

To delete a field in a table, the table must be opened in ____________________ view.

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

If you plan to move your data to SQL Server at a later date, do not use ____________________ fields.

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

A(n) _________________________ is a field in one table whose values are required to match a primary key in another table.

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.

In the type of relationship between the Recruiter and Client tables illustrated in the accompanying figure, the infinity symbol indicates that one recruiter is related to _________________________ clients.

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

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

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.

Because JSP may upsize the database to SQL Server, they have decided to delete the Specialties Needed field. How do you delete the field?