Question 1

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

Accepted Answer

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

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

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 4

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

Accepted Answer

cmdAddCPTC

Question 5

Name three reasons you must use a module rather than a macro.

Accepted Answer

1.  Class modules are stored as part of

Question 6

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 7

Which procedure is triggered after a field is updated?

Accepted Answer

A)  On Got Focus 
B)  After Update 
C)  Current Record 
D)  Current Field 
A)  On Got Focus 
B)  After Update 
C)  Current Record 
D)  Current Field

Question 8

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

Accepted Answer

A)  Run 
B)  Break 
C)  Reset 
D)  View Microsoft Office Access 
A)  Run 
B)  Break 
C)  Reset 
D)  View Microsoft Office Access

Question 9

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

Accepted Answer

Modules consist of VBA programming code,

Question 10

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

Accepted Answer

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

Question 11

Which VBA keyword(s) declares the name and arguments that create a new function procedure?

Accepted Answer

A)  Function 
B)  Start Function 
C)  Dim Function 
D)  Option Function 
A)  Function 
B)  Start Function 
C)  Dim Function 
D)  Option Function

Question 12

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 13

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

Accepted Answer

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

Question 14

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 objects may not store class modules?

Accepted Answer

A)  Queries 
B)  Forms 
C)  Reports 
D)  Each may store VBA 
A)  Queries 
B)  Forms 
C)  Reports 
D)  Each may store VBA

Question 15

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 16

This VBA keyword(s) specifies the location of where the procedure should continue if an error occurs in the execution.

Accepted Answer

A)  On Error Continue 
B)  GoTo Error 
C)  Error End 
D)  On Error GoTo 
A)  On Error Continue 
B)  GoTo Error 
C)  Error End 
D)  On Error GoTo

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

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 19

Syntax errors in the Visual Basic Editor window are the most difficult type of error to find. _____

Accepted Answer

A) True 
 B)False

Question 20

This type of procedure manipulates controls and objects.

Accepted Answer

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

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

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

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

Name three reasons you must use a module rather than a macro.

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

Which procedure is triggered after a field is updated?

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

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

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

Which VBA keyword(s) declares the name and arguments that create a new function procedure?

Debug means to ____.

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

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

This VBA keyword(s) specifies the location of where the procedure should continue if an error occurs in the execution.

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

This character separates multiple arguments in a function.

Syntax errors in the Visual Basic Editor window are the most difficult type of error to find. _____

This type of procedure manipulates controls and objects.

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

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

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

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

Name three reasons you must use a module rather than a macro.

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

Which procedure is triggered after a field is updated?

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

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

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

Which VBA keyword(s) declares the name and arguments that create a new function procedure?

Debug means to ____.

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

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

This VBA keyword(s) specifies the location of where the procedure should continue if an error occurs in the execution.

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

This character separates multiple arguments in a function.

Syntax errors in the Visual Basic Editor window are the most difficult type of error to find. _____

This type of procedure manipulates controls and objects.

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