Question 1

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

Accepted Answer

BeforeUpdate

Question 2

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

Accepted Answer

Procedure

Question 3

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

An input mask is used to control the format of data entry, but it cannot perform complex verification like checking for the presence of specific characters such as the "@" symbol in an email address. VBA can perform such logical checks.

Question 4

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 5

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 can be used with the argument vbProperCase to convert a string to proper case.

Question 6

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

Accepted Answer

VBA (Visual Basic for Applications) is integrated with each Microsoft Office program and has unique features specifically designed for each application. However, there are also common features and syntax across applications, such as basic programming structures and object-oriented programming concepts.

Question 7

VBA procedures are created,modified,and displayed in the ____ window.
A)Immediate
B)Code
C)VBA
D)Query

Accepted Answer

VBA procedures are created, modified, and displayed in the Code window. The Immediate window is used for executing single line VBA commands, the VBA window displays the project explorer and properties window, and the Query window is used for manipulating and querying data in a database.

Question 8

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

Accepted Answer

The Case control structure is a conditional control structure that allows for multiple branches based on different conditions. It is commonly used in programming languages such as Java and Visual Basic.

Question 9

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

Using appropriate capitalization in VBA code helps make it easier to read and maintain as it follows a consistent standard. Using incorrect capitalization can make the code harder to comprehend and find errors. Therefore, it is important to follow proper capitalization in VBA coding.

Question 10

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

Accepted Answer

A Case control structure is part of a Select Case statement and ends with End Select.

Question 11

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 statement is correct, the LCase function converts any uppercase letters in the input string to lowercase letters.

Question 12

Event procedures are always Sub procedures.

Accepted Answer

Event procedures are always Sub procedures that are automatically called by the system when a specific event, such as a button click or form load, occurs.

Question 13

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 included in a standard module can be used by any form or report that has access to the module.

Question 14

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

Accepted Answer

Declarations section contains statements that apply to all procedures in the module.

Question 15

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 within a Case statement, the control is hidden in Access.

Question 16

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 must be between 0 and 255, not 0 and 150.

Question 17

Access events all have associated event properties.____________________

Accepted Answer

This statement is true; Access events do have associated event properties.

Question 18

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

Accepted Answer

It is possible to convert an Access macro to VBA code using the Macro to VBA Converter tool that is built into Access.

Question 19

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

Accepted Answer

event

Question 20

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

Accepted Answer

Declarations

Quiz 11: Using and Writing Visual Basic for Applications Code