Question 1

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  False

Question 2

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 D

Question 3

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 C

Question 4

In the Declarations statement "Option Compare Database," Database determines how the procedure will ____ the data.

Accepted Answer

A) organize 
B) filter 
C) run 
D) sort 
A) organize 
B) filter 
C) run 
D) sort

Question 5

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 6

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.
-Which code best represents the procedure Louisa has written to convert the City field values to proper case in the database?

Accepted Answer

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

Question 7

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 8

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 9

Occurs when the focus moves to a record,making it the current record,or when a form is refreshed.

Accepted Answer

A) coding 
B) Sub statement 
C) logic error 
D) RGB 
E) function call
F)Current
G)Assignment statement
H)Visual Basic window
I)Load
J)bas
K)Object box
L)Case statement
M)Immediate window
N)Procedure box 
A) coding 
B) Sub statement 
C) logic error 
D) RGB 
E) function call
F)Current
G)Assignment statement
H)Visual Basic window
I)Load
J)bas
K)Object box
L)Case statement
M)Immediate window
N)Procedure box

Question 10

A statement that assigns the value of an expression to a field,control,or property.

Accepted Answer

A) coding 
B) Sub statement 
C) logic error 
D) RGB 
E) function call
F)Current
G)Assignment statement
H)Visual Basic window
I)Load
J)bas
K)Object box
L)Case statement
M)Immediate window
N)Procedure box 
A) coding 
B) Sub statement 
C) logic error 
D) RGB 
E) function call
F)Current
G)Assignment statement
H)Visual Basic window
I)Load
J)bas
K)Object box
L)Case statement
M)Immediate window
N)Procedure box

Question 11

The Access event that occurs when a form is opened and the records are displayed.

Accepted Answer

A) coding 
B) Sub statement 
C) logic error 
D) RGB 
E) function call
F)Current
G)Assignment statement
H)Visual Basic window
I)Load
J)bas
K)Object box
L)Case statement
M)Immediate window
N)Procedure box 
A) coding 
B) Sub statement 
C) logic error 
D) RGB 
E) function call
F)Current
G)Assignment statement
H)Visual Basic window
I)Load
J)bas
K)Object box
L)Case statement
M)Immediate window
N)Procedure box

Question 12

Color values for controls may be coded in several different ways.Which type of color value represents color intensities of red,green,and blue instead of the color values ranging from 0-255?

Accepted Answer

A) RGB 
B) VB constant 
C) ColorIndex 
D) hexadecimal 
A) RGB 
B) VB constant 
C) ColorIndex 
D) hexadecimal

Question 13

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 14

The program window that opens when VB is chosen from the Macros & Code group on the Create tab.

Accepted Answer

A) coding 
B) Sub statement 
C) logic error 
D) RGB 
E) function call
F)Current
G)Assignment statement
H)Visual Basic window
I)Load
J)bas
K)Object box
L)Case statement
M)Immediate window
N)Procedure box 
A) coding 
B) Sub statement 
C) logic error 
D) RGB 
E) function call
F)Current
G)Assignment statement
H)Visual Basic window
I)Load
J)bas
K)Object box
L)Case statement
M)Immediate window
N)Procedure box

Question 15

Which code statement will test a control to see if the data meets specific requirements?

Accepted Answer

A) VisitDate.ForeColor=vbRed 
B) ZipCode=27531 
C) Select Case [State] 
D) If VisitDate <#1//1/2017# 
A) VisitDate.ForeColor=vbRed 
B) ZipCode=27531 
C) Select Case [State] 
D) If VisitDate <#1//1/2017#

Question 16

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 17

When a procedure is created,the ____ determines where the procedure is available.

Accepted Answer

A) Declarations statement 
B) scope 
C) Procedure 
D) object properties 
A) Declarations statement 
B) scope 
C) Procedure 
D) object properties

Question 18

A set of values for the colors red,green,and blue ranging from 0 to 255 which are used in a specific VB function.

Accepted Answer

A) coding 
B) Sub statement 
C) logic error 
D) RGB 
E) function call
F)Current
G)Assignment statement
H)Visual Basic window
I)Load
J)bas
K)Object box
L)Case statement
M)Immediate window
N)Procedure box 
A) coding 
B) Sub statement 
C) logic error 
D) RGB 
E) function call
F)Current
G)Assignment statement
H)Visual Basic window
I)Load
J)bas
K)Object box
L)Case statement
M)Immediate window
N)Procedure box

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

​Tests VBA procedures without changing any data in the database

Accepted Answer

A) coding 
B) Sub statement 
C) logic error 
D) RGB 
E) function call
F)Current
G)Assignment statement
H)Visual Basic window
I)Load
J)bas
K)Object box
L)Case statement
M)Immediate window
N)Procedure box 
A) coding 
B) Sub statement 
C) logic error 
D) RGB 
E) function call
F)Current
G)Assignment statement
H)Visual Basic window
I)Load
J)bas
K)Object box
L)Case statement
M)Immediate window
N)Procedure box

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

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

In the Declarations statement "Option Compare Database," Database determines how the procedure will ____ the data.

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

Which of the following is a type of VBA procedure?

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

Occurs when the focus moves to a record,making it the current record,or when a form is refreshed.

A statement that assigns the value of an expression to a field,control,or property.

The Access event that occurs when a form is opened and the records are displayed.

Color values for controls may be coded in several different ways.Which type of color value represents color intensities of red,green,and blue instead of the color values ranging from 0-255?

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

The program window that opens when VB is chosen from the Macros & Code group on the Create tab.

Which code statement will test a control to see if the data meets specific requirements?

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

When a procedure is created,the ____ determines where the procedure is available.

A set of values for the colors red,green,and blue ranging from 0 to 255 which are used in a specific VB function.

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

Tests VBA procedures without changing any data in the database

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 Formsmodule

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

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

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

In the Declarations statement "Option Compare Database," Database determines how the procedure will ____ the data.

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

Which of the following is a type of VBA procedure?

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

Occurs when the focus moves to a record,making it the current record,or when a form is refreshed.

A statement that assigns the value of an expression to a field,control,or property.

The Access event that occurs when a form is opened and the records are displayed.

Color values for controls may be coded in several different ways.Which type of color value represents color intensities of red,green,and blue instead of the color values ranging from 0-255?

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

The program window that opens when VB is chosen from the Macros & Code group on the Create tab.

Which code statement will test a control to see if the data meets specific requirements?

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

When a procedure is created,the ____ determines where the procedure is available.

A set of values for the colors red,green,and blue ranging from 0 to 255 which are used in a specific VB function.

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

​Tests VBA procedures without changing any data in the database

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 Formsmodule

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

Tests VBA procedures without changing any data in the database