Question 1

A set of VBA statements that work together as a unit is a(n) ____________________.

Accepted Answer

The answer of A set of VBA statements that work...

Question 2

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 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 Case-Based Critical Thinking Questions Case 11-1
Luca is...

Question 3

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.
Before beginning her task, Louisa will review the procedures that have already been coded using VBA in the database. Where will she find the procedures on the Navigation Pane of the database?
A) under the Queries bar
B) under the Modules bar
C) under the Forms bar
D) under the Reports bar

Accepted Answer

Procedures coded using VBA are typically stored in modules in Microsoft Access, which can be found under the Modules bar in the Navigation Pane of the database.

Question 4

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 given code includes a Private Sub with the Field EventProcedure, indicating that it will be triggered when the data in the specific field is modified. The code then utilizes a VBA function to convert the field value to proper case and assigns the modified value back to the same field. The correct syntax for the code calls for the Field specified before the EventProcedure, followed by the use of a VBA function and a VB Constant to modify the field value.

Question 5

The default scope of event procedures in an Access database is ____________________ which means the procedure is only available to the object in which it was created.

Accepted Answer

The answer of The default scope of event procedures in...

Question 6

The number of Code windows that may open at one time is determined by the number of ____________________ in the database.

Accepted Answer

The answer of The number of Code windows that may...

Question 7

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 constant vbUpperCase is used to convert all characters of a string to upper case letters. The other constants (vbProperCase, vbLowerCase, and vbAllCaps) do not achieve this result.

Question 8

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

Accepted Answer

The answer of Case-Based Critical Thinking Questions Case 11-1
Luca is...

Question 9

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

Accepted Answer

Luca should use the IsNull VBA function to check if the Paid field has no data. This function returns True if the value is Null, and False if it is not Null. The IsPaid function does not exist as a built-in VBA function. IsNum checks if a value is a number and IsBound is not a valid VBA function.

Question 10

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 11

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 If the Paid field is marked as...

Question 12

A(n) ____________________ assigns the value of an expression to a field, control or property.

Accepted Answer

The answer of A(n) ____________________ assigns the value of an...

Question 13

A(n) ____________________ is an object that stores a group of related procedures.

Accepted Answer

The answer of A(n) ____________________ is an object that stores...

Question 14

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 only store values of True or False, making it the best choice for this question. Decimal, Object, and Variant data types have a wider range of possible values and do not specifically store True or False.

Question 15

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

Accepted Answer

The answer of Case-Based Critical Thinking Questions Case 11-2 The...

Question 16

A(n) ____________________ performs operations, returns a value, accepts input values, and may be used in expressions.

Accepted Answer

The answer of A(n) ____________________ performs operations, returns a value,...

Question 17

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

The VBA constant that changes a string value to proper case is vbProperCase. This would be the best choice for Louisa to use in her Access VBA code to make sure that the City field's value is properly capitalized.

Question 18

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

Accepted Answer

Since the event procedure will only be used for the Participant Information form, it should be a private procedure to prevent it from being accessed or modified by other parts of the program.

Question 19

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.
Once Louisa codes the correct event procedure in her code, she will use the ____ function to begin the conversion of the data to proper case.
A) StrChange
B) ChangeString
C) ConvertSTR
D) StrConv

Accepted Answer

The answer of Case-Based Critical Thinking Questions Case 11-2 The...

Question 20

A group of statements coded using VBA to perform a set of operations or to calcualte a value is called a(n) ____________________.

Accepted Answer

The answer of A group of statements coded using VBA...

Quiz 12: Using and Writing Visual Basic for Applications Code

A set of VBA statements that work together as a unit is a(n) ____________________.

Which code best represents the procedure Louisa has written to convert the City field values to proper case in the database?

The default scope of event procedures in an Access database is ____________________ which means the procedure is only available to the object in which it was created.

The number of Code windows that may open at one time is determined by the number of ____________________ in the database.

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

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

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(n) ____________________ assigns the value of an expression to a field, control or property.

A(n) ____________________ is an object that stores a group of related procedures.

Which VB data type stores values of True or False?

A(n) ____________________ performs operations, returns a value, accepts input values, and may be used in expressions.

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 group of statements coded using VBA to perform a set of operations or to calcualte a value is called a(n) ____________________.