Exam 17: Access: Maintaining a Database

When you use Filter By Form to restrict records that appear,you create the filter and then tap or click the ____ button to apply the filter.

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

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

The property that the value in a foreign key must match another table's primary key is called _________________________.

To sort the data that appears in a datasheet on multiple fields,the major and minor keys must be next to each other in the datasheet with the major key on the right.

-To search for a specific record tap or click the ____ button on the HOME tab to display the Find and Replace dialog box shown in the accompanying figure.

Case 3-1 Bavant Publishing has decided to add some additional validation rules to the Customer table shown in Design view in the accompanying figure.They have asked you to create these validation rules. -Bavant would like to make sure that if an employee 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?

Case 3-2 Bavant has just realized that they need to make some additional changes to the Customer table shown in Design view in the accompanying figure.They have asked you to make these changes. -Because Bavant may move the database to SQL Server,they have decided to delete the Resources Needed field.How do you delete the field?

To delete a field from a table,open the table in ____ view,tap or click the row selector for the field to be deleted,and then press the DELETE key.

In the Bavant Publishing database,a one-to-many relationship exists between the Book Rep table and the Customer table.

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

You can add a record to a table by ____.

-To open the Relationships window in the accompanying figure,tap or click the _________________________ button on the DATABASE TOOLS tab.

Identify the letter of the choice that best matches the phrase or definition. -A field in which the user actually must enter data.

To indicate that the only allowable values for the Customer Type field are HS,COM,and UNI,enter ____ in the Validation Rule property box.

When you create a calculated field,users can update the field.

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

The Remove Filter command on the Advanced menu clears all filters.

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

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