Exam 4: Maintaining a Database

If the Client Number field in a record always should display the two characters in the client number in uppercase, then the correct format for this field is ____.

A secondary key is a field in one table whose values are required to match the primary key of another table.

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

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

To use Filter By Form to filter records, click the ____ button on the Home tab and then click Filter By Form.

To move to the first record using the form shown in the accompanying figure, click the ____ button on the Navigation bar.

To display the Total row in a datasheet, click the Sum button on the Ribbon.

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

To change gridlines in a datasheet, open the table in Datasheet view, select the entire datasheet, and click the ____________________ button on the Home tab.

You can filter individual fields by clicking the arrow to the right of the field name and using one of the common filters that are available for the field.

To use Filter By Selection to find all clients located in Burles, click the City field for any record where the city is Burles and then click the ____ button on the Home tab shown in the accompanying figure.

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

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

If you add a field to a table and later realize the field is in the wrong location, you can move the field. To move the field, click the ____________________ for the field and then drag the field to the new location.

Four types of filters are available in Access: Filter By Selection, Common Filters, Filter By Form, and Advanced Filter/Sort.

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.

You cannot preview the data to be deleted in a delete query before actually performing the deletion.

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

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