Exam 12: Using and Writing Visual Basic for Applications Code

The type of procedure that executes instructions and accepts input values, but does not return a value and cannot be used in expressions, is a(n) ____ procedure.

The accompanying figure is an example of a(n) ____.

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.

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?

Which VB data type stores values of True or False?

In the accompanying figure, arrow number four indicates which element of the Code window in the Visual Basic window?

Which of the following color options may be assigned to a control property as a VBA constant?

Case-Based Critical Thinking Questions Case 11-2 The Environmental Policy Group is collecting data on weather conditions throughout the southeast U.S. The database used for data collection is being used by field technicians throughout the region.  Louisa has been asked to update the database to reduce data entry mistakes.  Louisa will create some new procedures and update others in the database. Louisa wants to be sure that all city locations are recorded in proper case in the database.  To do this, she needs to use the ____ event procedure which will automatically change the data entered in the City field to proper case any time a value is entered or changed in the field. For instance, if the user enters san antonio in the City field, the procedure will change the data to San Antonio and store it in the database.

VBA code is created and modified using the ____.

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

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

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?

There is no default initial value set for any event property associated with Access forms, reports, or controls.

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. After creating the message control using VBA, which property of the control must be coded to display the message "Email the participant with the start date of the program"?

A comment line in the Code windows is indented and appears in the color ___.

VBA procedures are created, modified, and displayed in the ____ window.

One or more characters that might include alphabetic characters, numbers, spaces, and punctuation is called a(n) ____________________.

VBA is considered to be what type of language?