Exam 11: Using and Writing Visual Basic for Applications Code

All event procedures in a class module are a(n)____ procedures which means they may only be used for the form or report for which the class module was created.

The statement that indicates a Case control structure ends with End Select.

In the Declarations statement "Option Compare Database," Database determines how the procedure will ____ the data.

A ____ module is automatically created when the first event procedure for a form or report is created and it is associated with that specific form or report.

When a procedure is created, the ____ determines where the procedure is available.

Case-Based Critical Thinking Questions Case 11-1 Luca is the database administrator for a city parks and recreation department.  The department routinely uses community college interns to process applications and registration for the department's programs. It is important that the user interface minimize user input errors as much as possible. -Luca needs to use a VBA function in his code to return a value of True if the Paid field has no data or a value of False if the Paid field is not empty. Which VBA function should Luca use?

List the five VBA naming rules that must be followed when naming VBA elements such as Sub procedures, arguments, and functions

Case-Based Critical Thinking Questions Case 11-1 Luca is the database administrator for a city parks and recreation department.  The department routinely uses community college interns to process applications and registration for the department's programs. It is important that the user interface minimize user input errors as much as possible. -Because the event procedure that Luca is coding will only be used for the Participant Information form, the procedure is a(n)____ procedure.

VBA is considered to be what type of language?

The Visual Basic window is accessed using the ____ group from the Create tab.

If the Paid field is marked as paid in the Participant Information form, Luca wants the following message to appear on the screen "Email the participant with the start date of the program."  Which type of VBA control should Luca use in the procedure to create the message?

Visual Basic for Applications is a(n)____ provided with Microsoft Office programs.

Why is it recommended that procedures be compiled after they are first created or when changes are made to the procedure code?

A control is hidden in Access when the Visible property is False in a Case statement.

Color values for controls may be coded in several different ways.  Which type of color value represents color intensities of red, green, and blue instead of the color values ranging from 0-255?

List four advantages of using VBA rather than macros in Access.

VBA code is created and modified using the ____.

The Declarations section of a VBA module contains statements that apply to all procedures in the module.____________________

In a Case control structure, Case Else instructs the procedure to ____.