Question 1

In VBA, normal text is black.

Accepted Answer

A) True 
 B)False

Question 2

-In the figure above, item 7 refers to which button?

Accepted Answer

A)  Object Browser 
B)  Run Sub/UserForm 
C)  Insert Module 
D)  View Database 
A)  Object Browser 
B)  Run Sub/UserForm 
C)  Insert Module 
D)  View Database

Question 3

This VBA keyword(s) specifies the location of where the procedure should continue if an error occurs in the execution.

Accepted Answer

A)  On Error Continue 
B)  GoTo Error 
C)  Error End 
D)  On Error GoTo 
A)  On Error Continue 
B)  GoTo Error 
C)  Error End 
D)  On Error GoTo

Question 4

_____ modules are displayed as module objects in the Navigation Pane.

Accepted Answer

The answer of _____ modules are displayed as module objects...

Question 5

Syntax errors in the Visual Basic Editor window are the most difficult type of error to find. _____

Accepted Answer

A) True 
 B)False

Question 6

Match each term with the best choice.
-An object that stores VBA code

Accepted Answer

A) Argument 
B) Object 
C) Method 
D) Procedure 
E) Module 
A) Argument 
B) Object 
C) Method 
D) Procedure 
E) Module

Question 7

Which of the following is NOT a built-in Access function?

Accepted Answer

A)  Sub 
B)  Sum 
C)  Pmt 
D)  Now 
A)  Sub 
B)  Sum 
C)  Pmt 
D)  Now

Question 8

This type of procedure performs a series of VBA statements, but is not used in an expression.

Accepted Answer

A)  Argument 
B)  Method 
C)  Sub 
D)  Module 
A)  Argument 
B)  Method 
C)  Sub 
D)  Module

Question 9

Which procedure is triggered after a field is updated?

Accepted Answer

A)  On Got Focus 
B)  After Update 
C)  Current Record 
D)  Current Field 
A)  On Got Focus 
B)  After Update 
C)  Current Record 
D)  Current Field

Question 10

Match each term with the best choice.
-Any item that can be identified or manipulated

Accepted Answer

A) Argument 
B) Object 
C) Method 
D) Procedure 
E) Module 
A) Argument 
B) Object 
C) Method 
D) Procedure 
E) Module

Question 11

-In the figure above, item 9 refers to which button?

Accepted Answer

A)  UserForm 
B)  Run Sub/UserForm 
C)  Reset 
D)  Project Explorer 
A)  UserForm 
B)  Run Sub/UserForm 
C)  Reset 
D)  Project Explorer

Question 12

Aaron and Jeff are in the same advanced Access class and have teamed up to help each other understand VBA. In order to prepare for the VBA test, each has created a quiz for the other. Two of Aaron's questions are shown below.
-Which of the following contains the term that is described by the following statement? "Declares a variable, a named storage location that contains data that can be modified during program execution."

Accepted Answer

A)  Option Explicit 
B)  Option Compare Database 
C)  Dim 
D)  Private Sub 
A)  Option Explicit 
B)  Option Compare Database 
C)  Dim 
D)  Private Sub

Question 13

VBA is written in Visual Basic Design View.

Accepted Answer

A) True 
 B)False

Question 14

Click the gray bar to the right of the VBA statement to toggle breakpoints on and off. _____

Accepted Answer

A) True 
 B)False

Question 15

Which VBA keyword(s) declares the name and arguments that create a new function procedure?

Accepted Answer

A)  Function 
B)  Start Function 
C)  Dim Function 
D)  Option Function 
A)  Function 
B)  Start Function 
C)  Dim Function 
D)  Option Function

Question 16

VBA uses different colors to mean different things.

Accepted Answer

A) True 
 B)False

Question 17

-In the figure above, the name of the function is ____.

Accepted Answer

A)  BMI 
B)  StartValue 
C)  Option Compare Database 
D)  StartValue * 0.5 
A)  BMI 
B)  StartValue 
C)  Option Compare Database 
D)  StartValue * 0.5

Question 18

In VBA, comment text is black.

Accepted Answer

A) True 
 B)False

Question 19

A function created in a standard module can be used in any query in the database. _____

Accepted Answer

A) True 
 B)False

Question 20

This type of module is stored as a part of the form or report in which it was created.

Accepted Answer

A)  Standard 
B)  Class 
C)  Function 
D)  Sub 
A)  Standard 
B)  Class 
C)  Function 
D)  Sub

In VBA, normal text is black.

-In the figure above, item 7 refers to which button?

This VBA keyword(s) specifies the location of where the procedure should continue if an error occurs in the execution.

_____ modules are displayed as module objects in the Navigation Pane.

Syntax errors in the Visual Basic Editor window are the most difficult type of error to find. _____

Match each term with the best choice. -An object that stores VBA code

Which of the following is NOT a built-in Access function?

This type of procedure performs a series of VBA statements, but is not used in an expression.

Which procedure is triggered after a field is updated?

Match each term with the best choice. -Any item that can be identified or manipulated

-In the figure above, item 9 refers to which button?

VBA is written in Visual Basic Design View.

Click the gray bar to the right of the VBA statement to toggle breakpoints on and off. _____

Which VBA keyword(s) declares the name and arguments that create a new function procedure?

VBA uses different colors to mean different things.

-In the figure above, the name of the function is ____.

In VBA, comment text is black.

A function created in a standard module can be used in any query in the database. _____

This type of module is stored as a part of the form or report in which it was created.

Getting Started With Microsoft Office 2013

Getting Started With Chapter Access 2013

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Improving Queries

Enhancing Forms

Analyzing Data With Reports

Importing and Exporting Data

Analyzing Database Design Using Northwind

Creating Advanced Queries

Creating Advanced Reports

Creating Macros

Administering the Database

Chapter Access and the Web

Filters

Exam 15: Creating Modules and Vba

In VBA, normal text is black.

-In the figure above, item 7 refers to which button?

This VBA keyword(s) specifies the location of where the procedure should continue if an error occurs in the execution.

_____ modules are displayed as module objects in the Navigation Pane.

Syntax errors in the Visual Basic Editor window are the most difficult type of error to find. _____

Match each term with the best choice. -An object that stores VBA code

Which of the following is NOT a built-in Access function?

This type of procedure performs a series of VBA statements, but is not used in an expression.

Which procedure is triggered after a field is updated?

Match each term with the best choice. -Any item that can be identified or manipulated

-In the figure above, item 9 refers to which button?

VBA is written in Visual Basic Design View.

Click the gray bar to the right of the VBA statement to toggle breakpoints on and off. _____

Which VBA keyword(s) declares the name and arguments that create a new function procedure?

VBA uses different colors to mean different things.

-In the figure above, the name of the function is ____.

In VBA, comment text is black.

A function created in a standard module can be used in any query in the database. _____

This type of module is stored as a part of the form or report in which it was created.

Getting Started With Microsoft Office 2013

Getting Started With Chapter Access 2013

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Improving Queries

Enhancing Forms

Analyzing Data With Reports

Importing and Exporting Data

Analyzing Database Design Using Northwind

Creating Advanced Queries

Creating Advanced Reports

Creating Macros

Administering the Database

Chapter Access and the Web

Filters