Exam 11: Exploring Pivottable Design

In a report,label controls display data from underlying fields.

A function created in a standard module can be used in any query in the database.

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

How can you prevent the security warning with the Enable Content button from appearing when you open an Access database?

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

When does the Visual Basic Editor display text in red?

Class modules most commonly run in response to an event,such as a user clicking a command button.

A_____ procedure is generally executed when an event occurs.

To display the Visual Basic window,you click the Create tab on the ribbon,and then click Visual Basic.

A _____ module is stored as a part of the form or report in which it was created.

Tables contain and execute class modules.

Visual Basic for Applications (VBA)is only available for Microsoft Access. ​

In VBA,comments appear in _____ text.

Using the incorrect spelling of a VBA keyword is an example of a _____ programming error.

Which of the following controls would you use to describe another control on a report?

What happens when you click the Build button for a property on the Event tab of a form's Property Sheet?

_____ are statements in the code that document the code and do not affect how it runs.

What happens if you write VBA code in all lowercase letters?