Question 1

It is important to enter VBA code using appropriate capitalization in all statements so that the code can be read and maintained properly.

Accepted Answer

It is important to use proper capitalization in VBA code to make it easier to read and maintain. Using incorrect capitalization can result in syntax errors or make the code difficult to understand for other programmers.

Question 2

A control is hidden in Access when the Visible property is False in a Case statement.

Accepted Answer

When the Visible property of a control is set to False, it is hidden and not displayed on the form or report. This can be achieved using a Case statement in VBA or by directly setting the property in the control's Property Sheet.

Question 3

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

Accepted Answer

The IsNull property applies to a variable or variant, not a procedure statement.

Question 4

When a module is created it must begin with a Procedures section that applies to all procedures in the module.____________________

Accepted Answer

Declarations

Question 5

An example of a conditional control structure is the Case control structure.____________________

Accepted Answer

The Case control structure is a form of conditional control structure. It allows a program to evaluate an expression and choose from multiple possible outcomes based on its value.

Question 6

The way an object responds when an event occurs is determined by an associated object property.____________________

Accepted Answer

event

Question 7

The function that accepts a single string argument as input, converts the value of the argument to lowercase letters, then returns the converted value is the LCase function. ____________________

Accepted Answer

The LCase function in most programming languages accepts a single string argument as input, converts the value of the argument to lowercase letters, and then returns the converted value.

Question 8

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

Accepted Answer

The Declarations section is where you declare variables, constants, and other program-wide statements that are used by all procedures in the module. Therefore, the statement in the question is true.

Question 9

When using the RGB function in VBA, the color range for each value must be between the numbers of 0 through 150.

Accepted Answer

The color range for each value in the RGB function must be between 0 and 255, not 0 and 150.

Question 10

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

Accepted Answer

The AfterUpdate event occurs after data is changed in a control or record and the data is updated in the database.

Question 11

Event procedures are always Sub procedures.

Accepted Answer

Event procedures, also known as event handlers, are always Sub procedures.

Question 12

Access events all have associated event properties.____________________

Accepted Answer

Access events have associated event properties that describe various aspects of the event, such as the source of the event and any parameters that were passed with it.

Question 13

To convert a string to proper case where the first letter of every word in the string is uppercase, the StrConv function is used in VBA code.____________________

Accepted Answer

The StrConv function in VBA can be used with the vbProperCase argument to convert a string to proper case. This means that the first letter of every word in the string will be capitalized.

Question 14

It is not possible to convert an Access macro to VBA code.

Accepted Answer

Access macros can be converted to VBA code using the Macro Builder, which allows you to view and edit the underlying VBA code of a macro.

Question 15

Procedures included in a standard module may only be used by the form or report for which the event procedure was coded.

Accepted Answer

Procedures in a standard module can be used by any form or report that references the module. Event procedures, however, are specific to the form or report for which they were coded.

Question 16

The event name for a procedure being viewed in the VBE is indicated in the Object box. ____________________

Accepted Answer

Procedure

Question 17

VBA has features that are unique for each Microsoft Office program in addition to features that are common across applications.

Accepted Answer

VBA has specific features that are unique to each Microsoft Office program such as Excel, Access, and Word. However, there are also common features across all applications such as the ability to automate tasks, work with data, and interact with the user through forms and dialogs.

Question 18

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

Accepted Answer

There is no default initial value set for any event property associated with Access forms, reports, or controls. The developer must explicitly set the initial value for each event property in the VBA code.

Question 19

The statement that indicates a Case control structure ends with End Select.

Accepted Answer

This statement is true. The syntax for a Case control structure in most programming languages includes the keyword "End Select" to indicate the end of the case block.

Question 20

An input mask can accomplish the same verification procedures on data that VBA can accomplish such as verifying the @ symbol in an email address.

Accepted Answer

The answer of An input mask can accomplish the same...

Quiz 12: Using and Writing Visual Basic for Applications Code