Exam 14: Creating Macros

GoToControl is an example of a(n) ____.

In the figure above, item 11 refers to which button?

In the figure above, item 13 refers to which button?

In the figure above, item 9 refers to which button?

A(n) _____ is a procedure that returns a value.

The Else portion of an If...Then...Else construct is executed only if the expression is evaluated false.

DoCmd is a VBA object that supports many methods to run common Access commands such as closing windows or opening forms.

In VBA, keyword text is ____.

In the figure above, what is the function of item 1?

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

Which of the following VBA keywords is a declaration statement that determines the way string values (text) will be sorted?

When you encounter a run-time error, VBA will stop execution of your procedure at the line in which the error occurred. _____

As you write a VBA statement, IntelliSense technology helps you complete it.

In what situations must you use a macro instead of a module?

This function returns today's date.

VBA stands for ____.

In VBA, syntax error text is green.

The End If statement is needed to mark the end of the If block of code.

VBA uses different colors to mean different things.

You use a(n) quotation mark to begin a comment line. _____