Exam 8: Access

In Form Layout view, what happens when you select a text box and then click the Align Right button on the Home tab?

Which of the following Access options provides a way to set security, macro, and other privacy settings?

Which Access tool studies the structure and size of a database and recommends how to improve its speed?

When using the Chart Wizard, you can drag a Number field to the Data area of a chart to have the wizard automatically _____ the values in the field.

Which Action Catalog category contains the Comment, Group, If, and Submacro components?

Adam is creating a table with an AmtSold field for storing the number of items sold.He should assign the Currency data type to the AmtSold field.

Use the Align button on the Arrange tab to align the edges of the controls.

To rename a table, you must use the Navigation Pane.

If a field named Price displays values with three decimal places, what should you do to display the values accurately?

A macro always performs all the actions in an If program flow.

You can collapse all actions in a macro to hide its details.

Set the Locked property of a form control to Yes if you want to prevent users from entering data in the control.

The _____ property displays a value that is automatically entered in the field for

You use _____ to document and explain the statements in VBA code.

When you _____ a macro, you determine why it is not running correctly.

As you write a VBA statement, visual aids that are part of _____ help you complete it.

Mail fields are codes that Word replaces with field values when processing a mail merge.

What should you do if you want to make a copy of a database in a secure location?

To enter data in a table, open it in Table Datasheet view.

A(n) _____ provides a template for designing a form.