Exam 11: Exploring Pivottable Design

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

Which of the following controls has an After Update event property? ​

When a module is embedded in a form or report, it is called a(n) _____.

Which control provides consistent descriptive text as you navigate from record to record in a form?

Standard modules contain _____.

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

You can create a comment by starting the statement with _____.

In VBA code, green text indicates a VBA keyword.

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

Why are the parts of an If statement indented in the Visual Basic window?

The programming language used in Access modules is called Visual Basic for _____.

You write VBA code in the Visual Basic Design Pane.

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

A database in a trusted folder enables all database content, including all macros and VBA.

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

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

What types of errors occur only after you start running the code in the Visual Basic window?

You can use a function created in a standard module in any query in the database.

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

Which built-in Access function returns today's date?