Access 3

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

• Filter

• Remove

• Advanced

• Select

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

• Change

• Edit

• Design

• Datasheet

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

• list

• lookup

• combo

• value

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

• aggregate

• combined

• total

• calculated

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

• Query Type

• Action

• Update

• Data Definition

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

• insert

• append

• add

• supplement

A(n) ____ query adds records from an existing table to a new table, that is, a table that has not yet been created.

• insert-table

• new-table

• add-table

• make-table

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

• Required

• No Blanks

• Necessary

• Completed

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

• >=0, <=30,000

• >=$0, <=$30,000

• >=0 and <=30000

• >=$0 and <=$30,000

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.

• Statistics

• Add Total

• Insert Total

• Totals