Question 1

Declaration statements return a value.

Accepted Answer

A) True 
 B)False  False

Question 2

Use the On Got Cursor event when you want to trigger when a procedure when a control gets the focus.

Accepted Answer

A) True 
 B)False  False

Question 3

This type of procedure is generally executed when an event occurs.

Accepted Answer

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

Question 4

Match each term with the best choice.
-A series of VBA statements that performs an operation

Accepted Answer

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

Question 5

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

In VBA, keyword text is ____.

Accepted Answer

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

Question 8

The End Function statement appears in blue.

Accepted Answer

A) True 
 B)False

Question 9

-In the figure above, which of the following is NOT a VBA keyword or keyword phrase?

Accepted Answer

A)  Function 
B)  BMI 
C)  End Function 
D)  Option Compare Database 
A)  Function 
B)  BMI 
C)  End Function 
D)  Option Compare Database

Question 10

-In the figure above, the name of the first procedure is _____.

Accepted Answer

cmdAddCPTC

Question 11

You use a(n) quotation mark to begin a comment line. _____

Accepted Answer

A) True 
 B)False

Question 12

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 13

This character separates multiple arguments in a function.

Accepted Answer

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

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

Question 15

Match each term with the best choice.
-An action that an object can perform

Accepted Answer

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

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

-In the figure above, how many different procedures are shown? _____

Accepted Answer

The answer of  
-In the figure above, how many...

Question 18

_____ 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 19

Forgetting an End If statement would be an example of which type of programming error?

Accepted Answer

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

Question 20

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

Accepted Answer

Modules consist of VBA programming code,

Declaration statements return a value.

Use the On Got Cursor event when you want to trigger when a procedure when a control gets the focus.

This type of procedure is generally executed when an event occurs.

Match each term with the best choice. -A series of VBA statements that performs an operation

GoToControl is an example of a(n) ____.

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?

In VBA, keyword text is ____.

The End Function statement appears in blue.

-In the figure above, which of the following is NOT a VBA keyword or keyword phrase?

-In the figure above, the name of the first procedure is _____.

You use a(n) quotation mark to begin a comment line. _____

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?

This character separates multiple arguments in a function.

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

Match each term with the best choice. -An action that an object can perform

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

-In the figure above, how many different procedures are shown? _____

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

Forgetting an End If statement would be an example of which type of programming error?

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

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

Declaration statements return a value.

Use the On Got Cursor event when you want to trigger when a procedure when a control gets the focus.

This type of procedure is generally executed when an event occurs.

Match each term with the best choice. -A series of VBA statements that performs an operation

GoToControl is an example of a(n) ____.

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?

In VBA, keyword text is ____.

The End Function statement appears in blue.

-In the figure above, which of the following is NOT a VBA keyword or keyword phrase?

-In the figure above, the name of the first procedure is _____.

You use a(n) quotation mark to begin a comment line. _____

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?

This character separates multiple arguments in a function.

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

Match each term with the best choice. -An action that an object can perform

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

-In the figure above, how many different procedures are shown? _____

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

Forgetting an End If statement would be an example of which type of programming error?

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

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