Question 1

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

Question 3

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 4

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

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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 7

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 8

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

Accepted Answer

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

Question 9

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 10

This type of procedure performs a series of VBA statements, but is not used in an expression.

Accepted Answer

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

Question 11

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 12

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

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

1.  Class modules are stored as part of

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

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

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 18

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 19

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

Accepted Answer

1.  When making global shortcut key assi

Question 20

Click the gray bar to the right of the VBA statement to toggle breakpoints on and off. _____

Accepted Answer

A) True 
 B)False

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

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

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

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

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

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

Debug means to ____.

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

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

This type of procedure performs a series of VBA statements, but is not used in an expression.

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

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

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

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

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

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

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

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

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

Click the gray bar to the right of the VBA statement to toggle breakpoints on and off. _____

Getting Started With Access

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Improving Queries

Enhancing Forms

Analyizng Data With Reports

Importing and Exporting Data

Creating Advanced Queries

Creating Advanced Reports

Creating Macros

Administering the Database

Using Acess and the Web

Completing a Database Application

Filters

Exam 13: Creating Modules and Vba

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

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

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

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

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

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

Debug means to ____.

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

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

This type of procedure performs a series of VBA statements, but is not used in an expression.

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

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

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

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

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

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

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

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

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

Click the gray bar to the right of the VBA statement to toggle breakpoints on and off. _____

Getting Started With Access

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Improving Queries

Enhancing Forms

Analyizng Data With Reports

Importing and Exporting Data

Creating Advanced Queries

Creating Advanced Reports

Creating Macros

Administering the Database

Using Acess and the Web

Completing a Database Application

Filters