Question 1

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 2

This function returns today's date.

Accepted Answer

A)  TodayDate 
B)  TodaysDate 
C)  Day 
D)  Now 
A)  TodayDate 
B)  TodaysDate 
C)  Day 
D)  Now

Question 3

Which of the following is NOT a type of procedure?

Accepted Answer

A)  Declaration 
B)  Sub 
C)  Function 
D)  None of the above are procedures. 
A)  Declaration 
B)  Sub 
C)  Function 
D)  None of the above are procedures.

Question 4

Class modules automatically travel with the object that stores it.

Accepted Answer

A) True 
 B)False

Question 5

Which of the following is NOT a type of module?

Accepted Answer

A)  Class 
B)  Procedure 
C)  Standard 
D)  None of the above are modules. 
A)  Class 
B)  Procedure 
C)  Standard 
D)  None of the above are modules.

Question 6

These types of errors occur after the code starts to run and include attempting an illegal operation, such as dividing by zero.

Accepted Answer

A)  Compile-time 
B)  Syntax 
C)  Run-time 
D)  Logic 
A)  Compile-time 
B)  Syntax 
C)  Run-time 
D)  Logic

Question 7

Kelsey and Matt 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 multiple choice quiz for the other. Some of Kelsey's questions are shown below. Which of the following objects may not store class modules?

Accepted Answer

A)  Queries 
B)  Forms 
C)  Reports 
D)  Each may store VBA 
A)  Queries 
B)  Forms 
C)  Reports 
D)  Each may store VBA

Question 8

In VBA, an object is any item that can be used or manipulated. ____________________

Accepted Answer

A) True 
 B)False

Question 9

In VBA, syntax error text is green.

Accepted Answer

A) True 
 B)False

Question 10

You must enable content before you run VBA.

Accepted Answer

A) True 
 B)False

Question 11

It is common for VBA programmers to use _____-character prefixes to name objects and controls.

Accepted Answer

A)  two 
B)  three 
C)  four 
D)  five 
A)  two 
B)  three 
C)  four 
D)  five

Question 12

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 13

Kelsey and Matt 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 multiple choice quiz for the other. Some of Kelsey's questions are shown below. Which of the following types of procedures is generally stored in standard modules vs. class modules?

Accepted Answer

A)  Functions 
B)  Subs 
C)  Subroutines 
D)  Declaration statements 
A)  Functions 
B)  Subs 
C)  Subroutines 
D)  Declaration statements

Question 14

Standard modules are also called universal modules. ___________________

Accepted Answer

A) True 
 B)False

Question 15

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 16

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 17

Which statement declares a variable, a named storage location that contains data that can be modified during program execution.

Accepted Answer

A)  Const 
B)  Var 
C)  Sub 
D)  Dim 
A)  Const 
B)  Var 
C)  Sub 
D)  Dim

Question 18

VBA uses different colors to mean different things.

Accepted Answer

A) True 
 B)False

Question 19

GoToControl is an example of a(n) ____.

Accepted Answer

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

Question 20

You can create a comment by starting the statement with a(n) _____ statement.

Accepted Answer

A)  rem 
B)  aloc 
C)  dim 
D)  var 
A)  rem 
B)  aloc 
C)  dim 
D)  var

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

This function returns today's date.

Which of the following is NOT a type of procedure?

Class modules automatically travel with the object that stores it.

Which of the following is NOT a type of module?

These types of errors occur after the code starts to run and include attempting an illegal operation, such as dividing by zero.

In VBA, an object is any item that can be used or manipulated. ____________________

In VBA, syntax error text is green.

You must enable content before you run VBA.

It is common for VBA programmers to use _____-character prefixes to name objects and controls.

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

Standard modules are also called universal modules. ___________________

Which procedure is triggered after a field is updated?

Which statement declares a variable, a named storage location that contains data that can be modified during program execution.

VBA uses different colors to mean different things.

GoToControl is an example of a(n) ____.

You can create a comment by starting the statement with a(n) _____ statement.

Getting Started With Access

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Improving Queries

Enhancing Forms

Analyizng Data With Reports

Importing and Exporting Data

Creating Advanced Queries

Creating Advanced Reports

Creating Macros

Administering the Database

Using Acess and the Web

Completing a Database Application

Filters

Exam 13: Creating Modules and Vba

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

This function returns today's date.

Which of the following is NOT a type of procedure?

Class modules automatically travel with the object that stores it.

Which of the following is NOT a type of module?

These types of errors occur after the code starts to run and include attempting an illegal operation, such as dividing by zero.

In VBA, an object is any item that can be used or manipulated. ____________________

In VBA, syntax error text is green.

You must enable content before you run VBA.

It is common for VBA programmers to use _____-character prefixes to name objects and controls.

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

Standard modules are also called universal modules. ___________________

Which procedure is triggered after a field is updated?

Which statement declares a variable, a named storage location that contains data that can be modified during program execution.

VBA uses different colors to mean different things.

GoToControl is an example of a(n) ____.

You can create a comment by starting the statement with a(n) _____ statement.

Getting Started With Access

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Improving Queries

Enhancing Forms

Analyizng Data With Reports

Importing and Exporting Data

Creating Advanced Queries

Creating Advanced Reports

Creating Macros

Administering the Database

Using Acess and the Web

Completing a Database Application

Filters