Question 1

The End Function statement appears in blue.

Accepted Answer

A) True 
 B)False  True

Question 2

This type of module is stored within a particular form or report.

Accepted Answer

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

Question 3

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

Accepted Answer

A) True 
 B)False  True

Question 4

In VBA, comment text is black.

Accepted Answer

A) True 
 B)False

Question 5

Match between columns
                        Premises: An object that stores VBA code
An action that an object can perform
A constant, variable, or expression needed by a procedure to execute
A series of VBA statements that performs an operation
Any item that can be identified or manipulated

Accepted Answer

The Answer of Procedure and Object and Module and Method is...

Question 6

In VBA, keyword text is ____.

Accepted Answer

A)   Blue
B)   Black
C)   Red
D)   Green

Question 7

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

Question 8

Declaration statements return a value.

Accepted Answer

A) True 
 B)False

Question 9

VBA is written in Visual Basic Design View .

Accepted Answer

A) True 
 B)False

Question 10

Which VBA keyword(s) is required as the last statement of a function procedure?

Accepted Answer

A)   End Procedure
B)   End Function
C)   Option Procedure
D)   Option Function

Question 11

When you type a colon after the DoCmd object, IntelliSense technology helps you complete the statement.

Accepted Answer

A) True 
 B)False

Question 12

In VBA, normal text is black.

Accepted Answer

A) True 
 B)False

Question 13

The On Advance event of a form is triggered when you navigate through records.

Accepted Answer

A) True 
 B)False

Question 14

This character separates multiple arguments in a function.

Accepted Answer

A)   Period
B)   Comma
C)   Semicolon
D)   Colon

Question 15

Which is easier to create, a macro or a module, and why?

Accepted Answer

The answer of Which is easier to create, a macro...

Question 16

Visual Basic for Applications (VBA) is only available for Microsoft Access.

Accepted Answer

A) True 
 B)False

Question 17

This type of procedure manipulates controls and objects.

Accepted Answer

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

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

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. Why do forms generally contain more VBA than reports?

Accepted Answer

A)   They generally show one record of data at a time.
B)   The user interacts with forms more than reports.
C)   They store Structured Query Language.
D)   They may contain expressions that calculate new pieces of information.

Question 20

You would most likely create a function in a class module.

Accepted Answer

A) True 
 B)False

Exam 13: Creating Modules and Vba

The End Function statement appears in blue.

This type of module is stored within a particular form or report.

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

In VBA, comment text is black.

Match each term with the best choice.

In VBA, keyword text is ____.

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

Declaration statements return a value.

VBA is written in Visual Basic Design View .

Which VBA keyword(s) is required as the last statement of a function procedure?

When you type a colon after the DoCmd object, IntelliSense technology helps you complete the statement.

In VBA, normal text is black.

The On Advance event of a form is triggered when you navigate through records.

This character separates multiple arguments in a function.

Which is easier to create, a macro or a module, and why?

Visual Basic for Applications (VBA) is only available for Microsoft Access.

This type of procedure manipulates controls and objects.

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

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. Why do forms generally contain more VBA than reports?

You would most likely create a function in a class module.