Exam 17: Access: Maintaining a Database

To use Filter By Selection to find all customers located in Greer,tap or click the City field for any record where the city is Greer and then tap or click the ____ button on the HOME tab.

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

To specify that a field is to be required,change the value for the _____ property from No to Yes.

When an update query is created,a(n)_________________________ row displays in the design grid.

You can use the asterisk (*)wildcard in a filter but not the question mark (?)wildcard.

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

Identify the letter of the choice that best matches the phrase or definition. -A value that Access will display on the screen in a particular field before the user begins adding a record.

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

To print a copy of a relationship,tap or click the _____________________ button shown on the accompanying figure.

To specify that entries in the Returns field must be between $0.00 and $30,000.00,enter ____ in the Validation Rule property box.

Identify the letter of the choice that best matches the phrase or definition. -Allows you to add the results of a query to a new table.

To delete record PLI22 shown in the accompanying figure,tap or click the record selector in the datasheet for the record on which the client number is PLI22 and then press ____.

Identify the letter of the choice that best matches the phrase or definition. -Allows you to add the results of a query to an existing table.

To create a split form,select the table in the Navigation Pane,tap or click CREATE on the ribbon,tap or click the ____ button on the CREATE tab to display a menu,and then tap or click Split Form on the menu.

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

To create a validation rule for the State field to restrict entries to TN or TX,enter ____ in the Validation Rule property box.

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

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

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

To exit Access,click the ____ button on the right side of the Access title bar.