Exam 4: Maintaining a Database

To change a query so that each item in a multivalued field occurs on a different row, use the ____ property.

To use a common filter with a field whose data type is Text, click the arrow to the right of the field name and point to the _____ command to display the common text filters.

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

To order the records in the Client table in reverse alphabetical order by City, click the ____ button.

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

Critical Thinking Questions Case 3-1 Camashaly Design 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. Because the majority of clients that Camashaly Design services are located in North Carolina, management would like to minimize any data entry in this field. What property do you need to change and what would you enter in the property box?

Critical Thinking Questions Case 3-2 Camashaly 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. Because Camashaly may upsize the database to SQL Server, they have decided to delete the Services Needed field. How do you delete the field?

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?

Modified Multiple Choice The wildcard symbols for use with filters are ____.

When you use a split form, you only can add records using the simple form.

Modified Multiple Choice You can add a record to a table by ____.

To include totals and other statistics at the bottom of a datasheet, click the ____ button on the Home tab to include the Total row in the datasheet.

To clear a filter, click the ____ button on the Home tab and then click Clear All Filters.

You can use a filter in either Datasheet view or Form view.

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

A(n) ____________________ query adds, deletes, or changes data in a table.

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 the Business Analyst table is related to the Client table, it is possible to view the clients of a given analyst when you are viewing the datasheet for the Business Analyst table. The clients for the analyst will appear below the analyst in a split form .