Exam 11: Exploring Pivottable Design

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

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

On Click is an example of a(n)_____.

To indicate you want to run the AssignGradeA submacro of the Grades macro,what do you enter in a control's event procedure property?

A(n)_____ procedure manipulates controls and objects.

Which of the following are form events? Select all the options that apply.

How do you add an If statement to a module in the Visual Basic window?

You might want to create a function to calculate a value based on your company's unique business rules.

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

Which of the following are errors that prevent VBA code from running successfully? Select all the options that apply.

You must use the correct _____,or rules,when creating a VBA statement.

_____ modules are displayed as module objects in the Navigation Pane.

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

_____ a database means to identify the database file as safe to open.

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

Comment lines start with an exclamation point (!)and are red in the Visual Basic Editor.

If you create a function in a standard module,it applies only to the current object.

To add VBA code to a macro embedded in a report,you can first _____ the macro to VBA code.

When you display the Visual Basic window,one line is highlighted in yellow.What does that mean?

Which of the following statements is required as the last statement to mark the end of the VBA code that defines a function?