Question 1

In addition to the single quotation mark ('),a comment line in VBA code may begin with ____.

Accepted Answer

A) Rem 
B) Comment 
C) slash (/) 
D) semi-colon (;)

Question 2

Access events all have associated event properties.____________________

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

A) Forms 
B) Macros & Code 
C) Templates 
D) VBA

Question 4

The process of writing instructions in a programming language.

Accepted Answer

A) coding 
B) Sub statement 
C) logic error 
D) RGB 
E) function call
F)Current
G)Assignment statement
H)Visual Basic window
I)Load
J)bas
K)Object box
L)Case statement
M)Immediate window
N)Procedure box

Question 5

​Displays the current object type the procedure acts on.

Accepted Answer

A) coding 
B) Sub statement 
C) logic error 
D) RGB 
E) function call
F)Current
G)Assignment statement
H)Visual Basic window
I)Load
J)bas
K)Object box
L)Case statement
M)Immediate window
N)Procedure box

Question 6

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 7

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 8

To assign a purple ForeColor property to a control,the ____ function of VBA must be used.

Accepted Answer

A) vbColor 
B) vbPurple 
C) RGB 
D) RGCYK

Question 9

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 wants to be sure that a message appears to the user prompting that an email be sent to all program participants reminding them of the date the program begins when the Paid field in the form is marked paid.What type of structure will Luca use to code an expression that tests the Paid field for an entry?

Accepted Answer

A) If structure 
B) Case control structure 
C) Compare control structure 
D) If,then structure

Question 10

The AfterUpdateevent occurs before data is changed in a control or record and the data is updated in the database.____________________

Accepted Answer

A) True 
 B)False

Question 11

A predefined memory location initialized to a value that does not change in VBA is called a(n)____.

Accepted Answer

A) Procedure default 
B) VBA constant 
C) Function constant 
D) Property default

Question 12

In the following code,which field in the associated form is being used for the Case structure??   Select Case [Course]?   Case "CIS 101"?   lblMessage,Caption = "Prerequisite CIS 100 required"

Accepted Answer

A) CIS 101 
B) Course 
C) CIS 100 
D) Case CIS 101

Question 13

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

Accepted Answer

The answer of Why is it recommended that procedures be...

Question 14

Event procedures are always Sub procedures.

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

The answer of List the five VBA naming rules that...

Question 16

A control is displayed when the IsNull property is True in a procedure statement.____________________

Accepted Answer

The answer of A control is displayed when the IsNull...

Question 17

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.
-Because Louisa's code will only be used in Access,she can use a VBA constant in the code argument to change the City field's value to proper case.Which VBA constant should Louisa use?

Accepted Answer

A) vbUpperCase 
B) vbLowerCase 
C) vbChangeCase 
D) vbProperCase

Question 18

The statement that marks the start of a new Sub procedure.

Accepted Answer

A) coding 
B) Sub statement 
C) logic error 
D) RGB 
E) function call
F)Current
G)Assignment statement
H)Visual Basic window
I)Load
J)bas
K)Object box
L)Case statement
M)Immediate window
N)Procedure box

Question 19

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

Accepted Answer

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

Question 20

The following code is testing a field in the associated form for specific input.Which string is the Case structure looking for in the form??   Select Case [Course]?   Case "CIS 101"?   lblMessage,Caption = "Prerequisite CIS 100 required"

Accepted Answer

A) Course 
B) CIS 100 
C) CIS 101 
D) Prerequisite CIS 100 required

Exam 11: Using and Writing Visual Basic for Applications Code

In addition to the single quotation mark (') ,a comment line in VBA code may begin with ____.

Access events all have associated event properties.____________________

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

The process of writing instructions in a programming language.

Displays the current object type the procedure acts on.

VBA code is created and modified using the ____.

To assign a purple ForeColor property to a control,the ____ function of VBA must be used.

The AfterUpdateevent occurs before data is changed in a control or record and the data is updated in the database.____________________

A predefined memory location initialized to a value that does not change in VBA is called a(n) ____.

In the following code,which field in the associated form is being used for the Case structure?? Select Case [Course]? Case "CIS 101"? lblMessage,Caption = "Prerequisite CIS 100 required"

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

Event procedures are always Sub procedures.

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

A control is displayed when the IsNull property is True in a procedure statement.____________________

The statement that marks the start of a new Sub procedure.

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

The following code is testing a field in the associated form for specific input.Which string is the Case structure looking for in the form?? Select Case [Course]? Case "CIS 101"? lblMessage,Caption = "Prerequisite CIS 100 required"

Exam 11: Using and Writing Visual Basic for Applications Code

In addition to the single quotation mark (') ,a comment line in VBA code may begin with ____.

Access events all have associated event properties.____________________

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

The process of writing instructions in a programming language.

​Displays the current object type the procedure acts on.

VBA code is created and modified using the ____.

To assign a purple ForeColor property to a control,the ____ function of VBA must be used.

The AfterUpdateevent occurs before data is changed in a control or record and the data is updated in the database.____________________

A predefined memory location initialized to a value that does not change in VBA is called a(n) ____.

In the following code,which field in the associated form is being used for the Case structure?? Select Case [Course]? Case "CIS 101"? lblMessage,Caption = "Prerequisite CIS 100 required"

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

Event procedures are always Sub procedures.

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

A control is displayed when the IsNull property is True in a procedure statement.____________________

The statement that marks the start of a new Sub procedure.

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

The following code is testing a field in the associated form for specific input.Which string is the Case structure looking for in the form?? Select Case [Course]? Case "CIS 101"? lblMessage,Caption = "Prerequisite CIS 100 required"

Displays the current object type the procedure acts on.