Exam 69: Data-sheets and Forms

To remove a sort that you just applied,click the Remove Sort button.

In Access,when building a mathematical formula,an asterisk represents multiplication.

A recently applied sorting action can be removed by clicking the Undo button in the Quick Access Toolbar.

In Access,a subform can be defined as ____.

When table data is sorted in ascending order,it is sorted ____.

When a record is deleted from a table,the action can be reversed.

You can locate a record in a table by typing search text in the Search box in Datasheet view.

The Form Wizard supports adding only primary and foreign keys to a new form.

Access sorting tools are found on the ____ tab in the Sort & Filter group.

Once a calculated field is completed,it can subsequently be changed.

Changing the layout of a form changes the layout of its underlying table.

When table data is sorted in descending order,it is sorted ____.

Which of the following is a valid expression in an Access table calculation?

To quickly create a new form,click the CREATE tab on the ribbon and select ____ in the Forms group.

In Access,the Expression Builder is used to create a table.

When a calculated field is set to ____,the field is formatted with dollar signs and decimal places.

After clicking the Form button to create a new form,its displayed fields and layout can be changed.

A form can be used to add a new record to a database table.

When you create a lookup field list and enable the Limit to List check box,entries can be manually typed or selected from the lookup list.

An Access table that is closed and then reopened will sort and display its records by its ____.