Question 1

Standard modules are also called  _____  modules.

Accepted Answer

A)  universal 
B)  global 
C)  typical 
D)  ordinary 
A)  universal 
B)  global 
C)  typical 
D)  ordinary

Question 2

_____ are used to store data that can be used, modified, or displayed during the execution of a procedure.

Accepted Answer

A)  Variables 
B)  Constructs 
C)  Arguments 
D)  Dimensions 
A)  Variables 
B)  Constructs 
C)  Arguments 
D)  Dimensions

Question 3

Why would you use the Zoom dialog box when creating an expression?

Accepted Answer

A)  You must use the Zoom dialog box when entering VBA in an expression. 
B)  You must use the Zoom dialog box when entering SQL in an expression. 
C)  The Zoom dialog box gives you more room to enter an expression. 
D)  The Zoom dialog box precalculates the answer to an expression. 
A)  You must use the Zoom dialog box when entering VBA in an expression. 
B)  You must use the Zoom dialog box when entering SQL in an expression. 
C)  The Zoom dialog box gives you more room to enter an expression. 
D)  The Zoom dialog box precalculates the answer to an expression.

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

VBA stands for ____.

Accepted Answer

A)  Visual Basic for Access 
B)  Virtual Basic for Access 
C)  Visual Basic for Applications 
D)  Virtual Basic for Applications 
A)  Visual Basic for Access 
B)  Virtual Basic for Access 
C)  Visual Basic for Applications 
D)  Virtual Basic for Applications

Question 6

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 defines a breakpoint?

Accepted Answer

A)  Run-time error that stops execution in the immediate window 
B)  Bookmark that stops execution at that statement 
C)  Syntax error that must be debugged 
D)  Immediate window that provides more information about the procedure 
A)  Run-time error that stops execution in the immediate window 
B)  Bookmark that stops execution at that statement 
C)  Syntax error that must be debugged 
D)  Immediate window that provides more information about the procedure

Question 7

AutoStart is a special macro name that automatically executes when a database first opens. ____________________

Accepted Answer

A) True 
 B)False

Question 8

Comment lines are preceded by a(n) ____.

Accepted Answer

A)  Period 
B)  Exclamation point 
C)  Right parentheses 
D)  Apostrophe 
A)  Period 
B)  Exclamation point 
C)  Right parentheses 
D)  Apostrophe

Question 9

The prefix ____________________ is short for Basic and applies to standard modules.

Accepted Answer

The answer of The prefix ____________________ is short for Basic...

Question 10

When you encounter a run-time error, VBA will stop execution of your procedure at the line in which the error occurred. _____

Accepted Answer

A) True 
 B)False

Question 11

A sub procedure triggered by an event is often called an event handler.

Accepted Answer

A) True 
 B)False

Standard modules are also called _____ modules.

_____ are used to store data that can be used, modified, or displayed during the execution of a procedure.

Why would you use the Zoom dialog box when creating an expression?

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

VBA stands for ____.

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 defines a breakpoint?

AutoStart is a special macro name that automatically executes when a database first opens. ____________________

Comment lines are preceded by a(n) ____.

The prefix ____________________ is short for Basic and applies to standard modules.

When you encounter a run-time error, VBA will stop execution of your procedure at the line in which the error occurred. _____

A sub procedure triggered by an event is often called an event handler.

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

Standard modules are also called _____ modules.

_____ are used to store data that can be used, modified, or displayed during the execution of a procedure.

Why would you use the Zoom dialog box when creating an expression?

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

VBA stands for ____.

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 defines a breakpoint?

AutoStart is a special macro name that automatically executes when a database first opens. ____________________

Comment lines are preceded by a(n) ____.

The prefix ____________________ is short for Basic and applies to standard modules.

When you encounter a run-time error, VBA will stop execution of your procedure at the line in which the error occurred. _____

A sub procedure triggered by an event is often called an event handler.

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