Exam 13: Access_Module_3

Filter By Query allows you to filter based on multiple criteria, for example, to find only those accounts whose returns are $0.00 and whose account manager is 38.

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

Validation rules can indicate a ____.

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

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.

Case 3-1 PrattLast Associates has decided to add some additional validation rules to the Account table. They have asked you to create these validation rules. -PrattLast would like to make sure that if a manager enters the letters pa in the State field that it displays in the database as PA. What property do you need to change and what would you enter in the property box?

When a filter is in effect, you can redisplay all records by clicking the ____ button on the HOME tab.

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

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

In the PrattLast Associates database, a one-to-many relationship exists between the Account Manager table and the Account table.

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

To find records in one table that have no matching records in another table, use the _____ Query Wizard.

Restructuring the database includes adding new fields to a table, changing the characteristics of existing fields, and removing existing fields.

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.

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