Question 1

Which VB constant used in conjunction with the StrConv function will convert all characters of a string to upper case letters?
A)vbProperCase
B)vbLowerCase
C)vbUpperCase
D)vbAllCaps

Accepted Answer

The vbUpperCase constant should be used in conjunction with the StrConv function to convert all characters of a string to upper case letters.

Question 2

In addition to the single quotation mark ('),a comment line in VBA code may begin with ____.
A)Rem
B)Comment
C)slash (/)
D)semi-colon (;)

Accepted Answer

In VBA code, a comment line may begin with the keyword "Rem" followed by a space, or simply with an apostrophe (single quotation mark) without a space. Option B, C, and D are not valid ways to begin a comment line in VBA code.

Question 3

Which VB data type stores values of True or False?
A)Decimal
B)Object
C)Variant
D)Boolean

Accepted Answer

The Boolean data type can store only two values - True or False.

Question 4

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.
A)OnChange
B)OnEnter
C)AfterUpdate
D)BeforeUpdate

Accepted Answer

The AfterUpdate event procedure is used to update data in a field after the user has entered it. Louisa can write a code in this procedure to ensure that all data entered in the City field is recorded in proper case. This will automatically change the data every time a value is entered or updated in the City field. The other options, OnChange, OnEnter, and BeforeUpdate, are not suitable for this task. OnChange only triggers when a value in a field changes, but not necessarily when it is entered. OnEnter triggers when the user enters the field, but not when a value is changed. BeforeUpdate triggers before a change is made, so it cannot be used to change the value.

Question 5

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"
A)CIS 101
B)Course
C)CIS 100
D)Case CIS 101

Accepted Answer

The Case structure uses the value of the Course field in the associated form to determine which case to execute.

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.
-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?
A)combo box
B)radio button
C)message
D)label

Accepted Answer

The answer of Luca is the database administrator for a...

Question 7

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 8

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

Accepted Answer

The answer of List four advantages of using VBA rather...

Question 9

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?
A)RGB
B)VB constant
C)ColorIndex
D)hexadecimal

Accepted Answer

Hexadecimal color values represent color intensities of red, green, and blue in a combination of six-digit codes, with two digits for each color component. The range of the value for each color is 00 to FF (equivalent to 0 to 255 in decimal).

Question 10

A control is not displayed when the Visible property is to ____.
A)Yes
B)No
C)True
D)False

Accepted Answer

The Visible property set to False means the control will not be displayed.

Question 11

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)Caption
B)Text
C)Special Effect
D)Statement

Accepted Answer

The "Caption" property is used to display a message or label on a control in VBA.

Question 12

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?
A)If structure
B)Case control structure
C)Compare control structure
D)If,then structure

Accepted Answer

The answer of Luca is the database administrator for a...

Question 13

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.
-Which code best represents the procedure Louisa has written to convert the City field values to proper case in the database?
A)
Private Sub EventProcedure_VB Constant
    ‘Convert City to proper case
    [Field] = VBA Function([Field],   Event Procedure
End Sub

B)
Private Sub Field_EventProcedure
    ‘Convert City to proper case
    [Field] = VBA Function([Field], VB Constant
End Sub

C)
Private Sub Field_EventProcedure
    ‘Convert City to proper case
    [VB Constant] = VBA Function([Field], Field
End Sub

D)
Private Sub VB Function_EventProcedure
    ‘Convert City to proper case
    [VBAFunction] = ([Field], VB Constant
End Sub

Accepted Answer

The code in option B correctly uses the Field_EventProcedure to apply a VBA Function that converts the City field to proper case. The [Field] placeholder represents the field being acted on, and the VB Constant represents the VBA Function being applied to the field.

Question 14

A comment line in the Code windows is indented and appears in the color ___.
A)red
B)green
C)blue
D)black

Accepted Answer

In many code editors, including Code windows, comments are often displayed in green to distinguish them from executable code.

Question 15

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.
A)public
B)local
C)Case
D)Sub

Accepted Answer

Local procedures are only accessible within the module in which they were declared. This means that event procedures declared in a class module can only be used for the form or report for which the class module was created. Public procedures, on the other hand, can be accessed from other modules and can therefore be used by multiple forms or reports. "Case" is not a valid keyword in VBA, and "Sub" is a type of procedure but does not differentiate between local and global scope.

Question 16

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?
A)vbUpperCase
B)vbLowerCase
C)vbChangeCase
D)vbProperCase

Accepted Answer

Louisa should use the VBA constant vbProperCase, as it will change the City field's value to proper case, which capitalizes the first letter of each word and makes the rest lowercase. vbUpperCase will capitalize all letters, vbLowerCase will make all letters lowercase, and vbChangeCase does not exist as a constant in VBA.

Question 17

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?
A)IsPaid
B)IsNum
C)IsNull
D)IsBound

Accepted Answer

The IsNull function in VBA returns True if the provided expression is Null, which includes fields with no data. Therefore, using IsNull would be the best choice for Luca's scenario as it would accurately determine if the Paid field has no data.

Question 18

The Visual Basic window is accessed using the ____ group from the Create tab.
A)Forms
B)Macros & Code
C)Templates
D)VBA

Accepted Answer

The Visual Basic window is accessed using the "Macros & Code" group from the Create tab in Microsoft Access.

Question 19

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.
A)private
B)public
C)remote
D)shared

Accepted Answer

Since the event procedure is only being used for the Participant Information form, there is no need for it to be accessible to other procedures or forms outside of its own module. Therefore, making it a private procedure increases the security and reduces confusion in the code.

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"
A)Course
B)CIS 100
C)CIS 101
D)Prerequisite CIS 100 required

Accepted Answer

The Case structure is looking for the string "CIS 101" in the [Course] field of the associated form. If the value of [Course] is "CIS 101", then it will display the message "Prerequisite CIS 100 required" in the lblMessage caption. The other options are not relevant to the specific logic of this code.

Quiz 11: Using and Writing Visual Basic for Applications Code

Which VB constant used in conjunction with the StrConv function will convert all characters of a string to upper case letters?

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

Which VB data type stores values of True or False?

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"

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

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

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?

A control is not displayed when the Visible property is to ____.

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

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 Visual Basic window is accessed using the ____ group from the Create tab.

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"