Question 1

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 
A)  Standard 
B)  Class 
C)  Function 
D)  Sub

Question 2

In VBA, comment text is black.

Accepted Answer

A) True 
 B)False

Question 3

The End Function statement appears in blue.

Accepted Answer

A) True 
 B)False

Question 4

In the figure above item 2 refers to the Insert _____ button.

Accepted Answer

The answer of   In the figure above item...

Question 5

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 6

VBA is written in Visual Basic Design View .

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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 9

Which of the following is NOT a built-in Access function?

Accepted Answer

A)  Sub 
B)  Sum 
C)  Pmt 
D)  Now 
A)  Sub 
B)  Sum 
C)  Pmt 
D)  Now

Question 10

In the figure above, the name of the function is ____.

Accepted Answer

A)  BMI 
B)  StartValue 
C)  Option Compare Database 
D)  StartValue * 0.5 
A)  BMI 
B)  StartValue 
C)  Option Compare Database 
D)  StartValue * 0.5

Question 11

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

Question 12

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 contains the term that is described by the following statement?
"Declares a variable, a named storage location that contains data that can be modified during program execution."

Accepted Answer

A)  Option Explicit 
B)  Option Compare Database 
C)  Dim 
D)  Private Sub 
A)  Option Explicit 
B)  Option Compare Database 
C)  Dim 
D)  Private Sub

Question 13

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 14

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 15

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 16

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 17

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 18

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

Accepted Answer

A) True 
 B)False

Question 19

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

Question 20

How many declaration statements are shown in the figure above?

Accepted Answer

A)  1 
B)  2 
C)  3 
D)  4 
A)  1 
B)  2 
C)  3 
D)  4

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

In VBA, comment text is black.

The End Function statement appears in blue.

In the figure above item 2 refers to the Insert _____ button.

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

VBA is written in Visual Basic Design View .

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

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

Which of the following is NOT a built-in Access function?

In the figure above, the name of the function is ____.

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

Comment lines are preceded by a(n) ____.

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

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

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

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

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

How many declaration statements are shown in the figure above?

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 module is stored as a part of the form or report in which it was created.

In VBA, comment text is black.

The End Function statement appears in blue.

In the figure above item 2 refers to the Insert _____ button.

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

VBA is written in Visual Basic Design View .

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

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

Which of the following is NOT a built-in Access function?

In the figure above, the name of the function is ____.

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

Comment lines are preceded by a(n) ____.

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

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

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

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

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

How many declaration statements are shown in the figure above?

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