Question 1

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.

Accepted Answer

A)  Function 
B)  Sub 
C)  Reference 
D)  Comment

Question 2

Match between columns
                        Premises: The process of writing instructions in a programming language.

Accepted Answer

The Answer of function call and Assignment statement and RGB is...

Question 3

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

Accepted Answer

A)  macro 
B)  function 
C)  event procedure 
D)  standard module

Question 4

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.

Accepted Answer

A)  private 
B)  public 
C)  remote 
D)  shared

Question 5

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?

Accepted Answer

A)  IsPaid 
B)  IsNum 
C)  IsNull 
D)  IsBound

Question 6

Which VB data type stores values of True or False?

Accepted Answer

A)  Decimal 
B)  Object 
C)  Variant 
D)  Boolean

Question 7

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

Accepted Answer

A)  Declarations section 
B)  Object box 
C)  Procedure box 
D)  Sub routine for the Current event

Question 8

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

Accepted Answer

A)  vbRed 
B)  RGB(255,0,0) 
C)  CMYK(0, 21, 151) 
D)  vbRGB(151, 12, 276)

Question 9

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.

Accepted Answer

A)  OnChange 
B)  OnEnter 
C)  AfterUpdate 
D)  BeforeUpdate

Question 10

VBA code is created and modified using the ____.

Accepted Answer

A)  Visual Basic Window 
B)  Visual Basic Editor 
C)  Visual Basic Design view 
D)  Procedure Window

Question 11

Match between columns
                        Premises: An error that occurs when a procedure produces incorrect results.

Accepted Answer

The Answer of Visual Basic window and function call and is...

Question 12

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

Accepted Answer

A)  organize 
B)  filter 
C)  run 
D)  sort

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

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?

Accepted Answer

A)  RGB 
B)  VB constant 
C)  ColorIndex 
D)  hexadecimal

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

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"?

Accepted Answer

A)  Caption 
B)  Text 
C)  Special Effect 
D)  Statement

Question 17

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

Accepted Answer

A)  red 
B)  green 
C)  blue 
D)  black

Question 18

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

Accepted Answer

A)  Immediate 
B)  Code 
C)  VBA 
D)  Query

Question 19

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

Accepted Answer

The answer of One or more characters that might include...

Question 20

VBA is considered to be what type of language?

Accepted Answer

A)  rule-based programming language 
B)  a markup language 
C)  an assembly language 
D)  an event-driven language

Exam 12: Using and Writing Visual Basic for Applications Code