Question 1

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 2

In VBA, normal text is black.

Accepted Answer

A) True 
 B)False

Question 3

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

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 5

_____ statements precede procedure statements and help set rules for how the statements in the module are processed.

Accepted Answer

The answer of _____ statements precede procedure statements and help...

Question 6

Match between columns
                        Premises: 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
An object that stores VBA code

Accepted Answer

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

Question 7

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

Accepted Answer

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

Question 8

Declaration statements return a value.

Accepted Answer

A) True 
 B)False

Question 9

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 10

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 11

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 12

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 13

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

Accepted Answer

A) True 
 B)False

Question 14

In the figure above, item 8 refers to which button?

Accepted Answer

A)  Object Browser 
B)  Break 
C)  Project Explorer 
D)  Database 
A)  Object Browser 
B)  Break 
C)  Project Explorer 
D)  Database

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

In VBA, normal text is black.

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?

Which of the following is NOT a type of module?

_____ statements precede procedure statements and help set rules for how the statements in the module are processed.

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

Declaration statements return a value.

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

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?

Which of the following is NOT a type of procedure?

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

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

In the figure above, item 8 refers to which button?

Getting Started With 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

Access and the Web

Getting Started With Microsoft Office 2013

Filters

Exam 14: Creating Macros

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

In VBA, normal text is black.

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?

Which of the following is NOT a type of module?

_____ statements precede procedure statements and help set rules for how the statements in the module are processed.

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

Declaration statements return a value.

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

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?

Which of the following is NOT a type of procedure?

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

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

In the figure above, item 8 refers to which button?

Getting Started With 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

Access and the Web

Getting Started With Microsoft Office 2013

Filters