Question 1

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

Visual Basic code is stored in a database object called a(n) _____.

Accepted Answer

The answer of Visual Basic code is stored in a...

Question 4

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 5

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 
A)  End Procedure 
B)  End Function 
C)  Option Procedure 
D)  Option Function

Question 6

Debug means to ____.

Accepted Answer

A)  Write code using the Command Button Wizard 
B)  Find and resolve errors in code 
C)  Use conditional expressions in code 
D)  Use If...Then...Else statements in code 
A)  Write code using the Command Button Wizard 
B)  Find and resolve errors in code 
C)  Use conditional expressions in code 
D)  Use If...Then...Else statements in code

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A)  End 
B)  Sub End 
C)  End Sub 
D)  Sub 
A)  End 
B)  Sub End 
C)  End Sub 
D)  Sub

Question 10

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 11

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 12

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

Accepted Answer

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

Question 13

-In the figure above, item 8 refers to the _____ button.

Accepted Answer

The answer of  
-In the figure above, item 8...

Question 14

-In the figure above, how many declaration statements are shown? _____

Accepted Answer

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

Question 15

The End If statement is needed to mark the end of the If block of code.

Accepted Answer

A) True 
 B)False

Question 16

-In the figure above, the name of a function argument is ____.

Accepted Answer

A)  BMI 
B)  weight 
C)  height * 0.0254 
D)  End If 
A)  BMI 
B)  weight 
C)  height * 0.0254 
D)  End If

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

A(n) _____ is a procedure that returns a value.

Accepted Answer

The answer of A(n) _____ is a procedure that returns...

Question 19

-In the figure above, what is the function of item 1?

Accepted Answer

A)  Opens a new module 
B)  Switches from active VB window to the Access window 
C)  Locks the procedure 
D)  Displays a list of currently open projects 
A)  Opens a new module 
B)  Switches from active VB window to the Access window 
C)  Locks the procedure 
D)  Displays a list of currently open projects

Question 20

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

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

This function returns today's date.

Visual Basic code is stored in a database object called a(n) _____.

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

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

Debug means to ____.

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

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

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

Which of the following is NOT a type of module?

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

-In the figure above, item 8 refers to the _____ button.

-In the figure above, how many declaration statements are shown? _____

The End If statement is needed to mark the end of the If block of code.

-In the figure above, the name of a function argument is ____.

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

A(n) _____ is a procedure that returns a value.

-In the figure above, what is the function of item 1?

Comment lines are preceded by a(n) ____.

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

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

This function returns today's date.

Visual Basic code is stored in a database object called a(n) _____.

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

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

Debug means to ____.

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

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

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

Which of the following is NOT a type of module?

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

-In the figure above, item 8 refers to the _____ button.

-In the figure above, how many declaration statements are shown? _____

The End If statement is needed to mark the end of the If block of code.

-In the figure above, the name of a function argument is ____.

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

A(n) _____ is a procedure that returns a value.

-In the figure above, what is the function of item 1?

Comment lines are preceded by a(n) ____.

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