Exam 8: Access

To change the color of the bars on a chart in a form, you must work in Form Format view.

The On _____ event occurs when focus moves from one record to another.

Sorting a table datasheet temporarily displays only those records that match given criteria.

Access adds # signs around textcriteria in Date/Time fields.

Dynaset is the default value of the _____ property in a query; it lets you update data in the query recordset.

Nina added a text box to a report to total the sales for each product type.Which Format property would be best for the new text box?

Which of the following are actions you can set for a command button when you use the Command Button Wizard? Select all the options that apply.

When you type a password in the Set Database Password dialog box, _____ appear instead of the characters you typed.

When you create a table with a Make-Table query, you can store the new table _____.

Where do you paste a copied query?

_____ fields allow you to make more than one choice from a field's lookup list.

To rename a form, open the form, and then use the Rename command on the Home tab.

If you want to add records from one table to a backup table, create a(n) Append query.

Each item on a form is called a _____.

When you convert an Access macro to VBA code, the VBA is stored in a standard module listed in the Navigation Pane with a name that starts with "New Macro."

Use Query Design view to display the results of a query.

In a Jobs database that contains an Employers table related to a Positions table, what do you expect to find in the subdatasheets of the Employers table?

If you often sort on a field, you should set its_____ property to Yes.

A(n) _____ file contains field values separated by a common character such as a comma or tab.

You use the _____ property of a query to document the purpose or author of the query.