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

A) True 
 B)False

Question 2

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

A) True 
 B)False

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.
-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.

Accepted Answer

A) OnChange 
B) OnEnter 
C) AfterUpdate 
D) BeforeUpdate 
A) OnChange 
B) OnEnter 
C) AfterUpdate 
D) BeforeUpdate

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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 
A) vbColor 
B) vbPurple 
C) RGB 
D) RGCYK

Question 6

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

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

Match between columns
                        Premises: The program window that opens when VB is chosen from the Macros & Code group on the Create tab.

Accepted Answer

The Answer of Sub statement and  Object box and is...

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

Match between columns
                        Premises: The process of writing instructions in a programming language.

Accepted Answer

The Answer of Assignment statement and logic error and  is...

Question 11

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?

Accepted Answer

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

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

Which of the following is a type of VBA procedure?

Accepted Answer

A) Format 
B) Control 
C) Reference 
D) Function 
A) Format 
B) Control 
C) Reference 
D) Function

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

Match between columns
                        Premises:  D isplays the current object type the procedure acts on.

Accepted Answer

The Answer of Sub statement and coding and Assignment statement is...

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

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

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

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

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"

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

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

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

Which of the following is a type of VBA procedure?

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

Access-Module 1: Creating a Database

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

Creating Forms and Reports

Creating Advanced Queries and Enhancing Table Design

Using Form Tools and Creating Custom Forms

Creating Custom Reports

Sharing, Integrating, and Analyzing Data

Using Action Queries and Advanced Table Relationships

Automating Tasks With Macros

Managing and Securing a Database

Relational Databases and Database Design

Filters

Exam 11: Using and Writing Visual Basic for Applications Code

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

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

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

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

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"

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

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

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

Which of the following is a type of VBA procedure?

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

Access-Module 1: Creating a Database

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

Creating Forms and Reports

Creating Advanced Queries and Enhancing Table Design

Using Form Tools and Creating Custom Forms

Creating Custom Reports

Sharing, Integrating, and Analyzing Data

Using Action Queries and Advanced Table Relationships

Automating Tasks With Macros

Managing and Securing a Database

Relational Databases and Database Design

Filters