Exam 11: Exploring Pivottable Design

To display the VBA code for a form, click the Build button in one of the form's event properties.

In an If statement, the _____ statement is executed when all If and ElseIf statements evaluate to false.

The On Current event of a form is triggered when you navigate through records.

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

Clicking a command button or making an entry in a field is considered a(n) ____. ​

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

Standard modules are also called universal modules.

Which of the following are event procedures you can assign to a report? Select all the options that apply.

What is the first step to convert a report's macros to VBA code?

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

Class modules are stored in an individual form or report.

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

When do most class modules run?

What can you use to test logical conditions and execute statements only if the conditions are true?

Which VBA keyword(s) do you use to declare the name and arguments that create a new function procedure?

In a macro's conditional expression, you refer to a value of a form control using the following syntax: ____.

Which of the following text colors have meaning in VBA? Select all the options that apply.

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

How do you begin an If statement that determines whether an employee's salary is less than $50,000?

A macro is an Access object that stores Visual Basic for Applications (VBA) programming code.