Question 1

The Immediate window allows the developer to test or ____ individual lines of VBA code.

Accepted Answer

A)  restore 
B)  compile 
C)  debug 
D)  append 
A)  restore 
B)  compile 
C)  debug 
D)  append

Question 2

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?

Accepted Answer

A)  under the Queries bar 
B)  under the Modules bar 
C)  under the Forms bar 
D)  under the Reports bar 
A)  under the Queries bar 
B)  under the Modules bar 
C)  under the Forms bar 
D)  under the Reports bar

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

Accepted Answer

A)  StrChange 
B)  ChangeString 
C)  ConvertSTR 
D)  StrConv 
A)  StrChange 
B)  ChangeString 
C)  ConvertSTR 
D)  StrConv

Question 4

Procedures in a module are separated by a(n) ____________________ in the Code window.

Accepted Answer

The answer of Procedures in a module are separated by...

Question 5

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 6

A named location in computer memory that can contain a value is called a(n) ____________________.

Accepted Answer

The answer of A named location in computer memory that...

Question 7

In the accompanying figure, the Case structure is testing values for which field in the form?

Accepted Answer

A)  Influenza 
B)  Reason 
C)  Annual wellness visit 
D)  Visible 
A)  Influenza 
B)  Reason 
C)  Annual wellness visit 
D)  Visible

Question 8

In the accompanying figure, arrow number three indicates which element of the Code window in the Visual Basic window?

Accepted Answer

A)  form name 
B)  Object box 
C)  Procedure box 
D)  Sub procedure for the Current event 
A)  form name 
B)  Object box 
C)  Procedure box 
D)  Sub procedure for the Current event

Question 9

The hexadecimal and ____________________ are color values that are used in web design and VB.NET as well as Access VBA coding.

Accepted Answer

The answer of The hexadecimal and ____________________ are color values...

Question 10

Match between columns
                        Premises: The Access event that occurs when a form is opened and the records are displayed.

Accepted Answer

The Answer of coding and logic error and Sub statement is...

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

A) True 
 B)False

Question 12

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 13

The event which occurs when the focus shifts to the next record loaded in a form making it the current record is the ____________________ event.

Accepted Answer

The answer of The event which occurs when the focus...

Question 14

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?

Accepted Answer

A)  combo box 
B)  radio button 
C)  message 
D)  label 
A)  combo box 
B)  radio button 
C)  message 
D)  label

Question 15

In the accompanying figure, ____ serves as a placeholder for the input value in the function definition.

Accepted Answer

A)  LCase 
B)  (FValue) 
C)  LowAll 
D)  Option Compare 
A)  LCase 
B)  (FValue) 
C)  LowAll 
D)  Option Compare

Question 16

A predefined memory location initialized to a value that does not change in VBA is called a(n) ____.

Accepted Answer

A)  Procedure default 
B)  VBA constant 
C)  Function constant 
D)  Property default 
A)  Procedure default 
B)  VBA constant 
C)  Function constant 
D)  Property default

Question 17

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 18

In a Case control structure, Case Else instructs the procedure to ____.

Accepted Answer

A)  stop running 
B)  sort data in a new manner 
C)  filter data based on new requirements 
D)  start an alternative set of actions 
A)  stop running 
B)  sort data in a new manner 
C)  filter data based on new requirements 
D)  start an alternative set of actions

Question 19

In the accompanying figure, a RGB value has been assigned to the ____ property of the control.

Accepted Answer

A)  Caption 
B)  lblMessage 
C)  ForeColor 
D)  Case 
A)  Caption 
B)  lblMessage 
C)  ForeColor 
D)  Case

Question 20

In the accompanying figure, the comment for the module begins with ____.

Accepted Answer

A)  Option 
B)  Function 
C)  single quotation mark (') 
D)  LowAll 
A)  Option 
B)  Function 
C)  single quotation mark (') 
D)  LowAll

The Immediate window allows the developer to test or ____ individual lines of VBA code.

Procedures in a module are separated by a(n) ____________________ in the Code window.

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

A named location in computer memory that can contain a value is called a(n) ____________________.

In the accompanying figure, the Case structure is testing values for which field in the form?

In the accompanying figure, arrow number three indicates which element of the Code window in the Visual Basic window?

The hexadecimal and ____________________ are color values that are used in web design and VB.NET as well as Access VBA coding.

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

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"

The event which occurs when the focus shifts to the next record loaded in a form making it the current record is the ____________________ event.

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?

In the accompanying figure, ____ serves as a placeholder for the input value in the function definition.

A predefined memory location initialized to a value that does not change in VBA is called a(n) ____.

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

In a Case control structure, Case Else instructs the procedure to ____.

In the accompanying figure, a RGB value has been assigned to the ____ property of the control.

In the accompanying figure, the comment for the module begins with ____.

Managing Your Files

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 Sharing a Database

Filters

Exam 12: Using and Writing Visual Basic for Applications Code

The Immediate window allows the developer to test or ____ individual lines of VBA code.

Procedures in a module are separated by a(n) ____________________ in the Code window.

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

A named location in computer memory that can contain a value is called a(n) ____________________.

In the accompanying figure, the Case structure is testing values for which field in the form?

In the accompanying figure, arrow number three indicates which element of the Code window in the Visual Basic window?

The hexadecimal and ____________________ are color values that are used in web design and VB.NET as well as Access VBA coding.

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

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"

The event which occurs when the focus shifts to the next record loaded in a form making it the current record is the ____________________ event.

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?

In the accompanying figure, ____ serves as a placeholder for the input value in the function definition.

A predefined memory location initialized to a value that does not change in VBA is called a(n) ____.

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

In a Case control structure, Case Else instructs the procedure to ____.

In the accompanying figure, a RGB value has been assigned to the ____ property of the control.

In the accompanying figure, the comment for the module begins with ____.

Managing Your Files

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 Sharing a Database

Filters