Question 1

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

Accepted Answer

A)  View Microsoft Access 
B)  Insert 
C)  Run Sub/UserForm 
D)  Project Explorer 
A)  View Microsoft Access 
B)  Insert 
C)  Run Sub/UserForm 
D)  Project Explorer

Question 2

Match each term with the best choice.
-A constant, variable, or expression needed by a procedure to execute

Accepted Answer

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

Question 3

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

Accepted Answer

Module
1. Name three reasons you must us

Question 4

Which of the following VBA keywords is a declaration statement that determines the way string values (text) will be sorted?

Accepted Answer

A)  Option Compare Database 
B)  Option Compare Text 
C)  On Text GoTo 
D)  Select Case 
A)  Option Compare Database 
B)  Option Compare Text 
C)  On Text GoTo 
D)  Select Case

Question 5

The Else portion of an If...Then...Else construct is executed only if the expression is evaluated false.

Accepted Answer

A) True 
 B)False

Question 6

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

As you write a VBA statement, IntelliSense technology helps you complete it.

Accepted Answer

A) True 
 B)False

Question 8

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

Question 9

VBA stands for ____.

Accepted Answer

A)  Visual Basic for Access 
B)  Virtual Basic for Access 
C)  Visual Basic for Applications 
D)  Virtual Basic for Applications 
A)  Visual Basic for Access 
B)  Virtual Basic for Access 
C)  Visual Basic for Applications 
D)  Virtual Basic for Applications

Question 10

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 11

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

Accepted Answer

A)  Object Browser 
B)  Access 
C)  Run Sub 
D)  Project Explorer 
A)  Object Browser 
B)  Access 
C)  Run Sub 
D)  Project Explorer

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

In VBA, syntax error text is green.

Accepted Answer

A) True 
 B)False

Question 14

In what situations must you use a macro instead of a module?

Accepted Answer

1. When making global shortcut key assig

Question 15

-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

Question 16

DoCmd is a VBA object that supports many methods to run common Access commands such as closing windows or opening forms.

Accepted Answer

A) True 
 B)False

Question 17

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

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

Match each term with the best choice. -A constant, variable, or expression needed by a procedure to execute

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

Which of the following VBA keywords is a declaration statement that determines the way string values (text) will be sorted?

The Else portion of an If...Then...Else construct is executed only if the expression is evaluated false.

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

As you write a VBA statement, IntelliSense technology helps you complete it.

This type of procedure manipulates controls and objects.

VBA stands for ____.

Which of the following is NOT a type of procedure?

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

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

In VBA, syntax error text is green.

In what situations must you use a macro instead of a module?

-How many declaration statements are shown in the figure above?

DoCmd is a VBA object that supports many methods to run common Access commands such as closing windows or opening forms.

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

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

Match each term with the best choice. -A constant, variable, or expression needed by a procedure to execute

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

Which of the following VBA keywords is a declaration statement that determines the way string values (text) will be sorted?

The Else portion of an If...Then...Else construct is executed only if the expression is evaluated false.

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

As you write a VBA statement, IntelliSense technology helps you complete it.

This type of procedure manipulates controls and objects.

VBA stands for ____.

Which of the following is NOT a type of procedure?

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

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

In VBA, syntax error text is green.

In what situations must you use a macro instead of a module?

-How many declaration statements are shown in the figure above?

DoCmd is a VBA object that supports many methods to run common Access commands such as closing windows or opening forms.

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