Exam 13: Access_Module_3

The Unfilter button toggles between filtered and unfiltered displays of the records in a table.

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.

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

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

You can add a record to a table by ____.

Maintaining a database can include ____.

To order the records in the Account table by city in alphabetical order, use the ____ button.

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

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

Computations available for the Total row in a column that contains currency include ____.

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

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

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.

Case 3-2 ​PrattLast has just realized that they need to make some additional changes to the Account table. They have asked you to make these changes. -Because PrattLast may move the database to SQL Server, they have decided to delete the Resources Needed field. How do you delete the field?

You can search for a record in Form view but not in Datasheet view.

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

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

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.

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

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