Deck 13: Creating Modules and Vba

Question 1

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

Answer 1

False

Question 2

A sub procedure triggered by an event is often called an event handler.

Answer 2

True

Question 3

The End Function statement appears in blue.

Answer 3

True

Question 4

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

Question 5

VBA uses different colors to mean different things.

Question 6

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

Question 7

Visual Basic for Applications (VBA) is only available for Microsoft Access.

Question 8

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

Question 9

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

Question 10

In VBA, normal text is black.

Question 11

Declaration statements return a value.

Question 12

In VBA, syntax error text is green.

Question 13

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

Question 14

VBA is written in Visual Basic Design View .

Question 15

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

Question 16

You must enable content before you run VBA.

Question 17

Class modules automatically travel with the object that stores it.

Question 18

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

Question 19

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

Question 20

In VBA, comment text is black.

Question 21

In VBA, keyword text is ____.

A) Blue
B) Black
C) Red
D) Green

Question 22

AutoStart is a special macro name that automatically executes when a database first opens. ____________________

Question 23

In VBA, an object is any item that can be used or manipulated. ____________________

Question 24

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

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

Question 25

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

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

Question 26

Which of the following is NOT a type of module?

A) Class
B) Procedure
C) Standard
D) None of the above are modules.

Question 27

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

Question 28

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

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

Question 29

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

Question 30

VBA stands for ____.

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

Question 31

The On Advance event of a form is triggered when you navigate through records.

Question 32

Which of the following is NOT a type of procedure?

A) Declaration
B) Sub
C) Function
D) None of the above are procedures.

Question 33

GoToControl is an example of a(n) ____.

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

Question 34

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

Question 35

Standard modules are also called universal modules. ___________________

Question 36

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

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

Question 37

This type of procedure manipulates controls and objects.

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

Question 38

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

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

Question 39

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

Question 40

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

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

Question 41

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

A) Compile-time
B) Syntax
C) Run-time
D) Logic

Question 42

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

Question 43

Why would you use the Zoom dialog box when creating 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 44

Debug means to ____.

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 45

Which statement declares a variable, a named storage location that contains data that can be modified during program execution.

A) Const
B) Var
C) Sub
D) Dim

Question 46

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

Question 47

Standard modules are also called  _____  modules.

A) universal
B) global
C) typical
D) ordinary

Question 48

This character separates multiple arguments in a function.

A) Period
B) Comma
C) Semicolon
D) Colon

Question 49

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

Question 50

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

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

Question 51

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

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

Question 52

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

A) Syntax
B) Run-time
C) Compile-time
D) Debug

Question 53

This function returns today's date.

A) TodayDate
B) TodaysDate
C) Day
D) Now

Question 54

Which procedure is triggered after a field is updated?

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

Question 55

You can create a comment by starting the statement with a(n) _____ statement.

A) rem
B) aloc
C) dim
D) var

Question 56

It is common for VBA programmers to use _____-character prefixes to name objects and controls.

A) two
B) three
C) four
D) five

Question 57

_____ are used to store data that can be used, modified, or displayed during the execution of a procedure.

A) Variables
B) Constructs
C) Arguments
D) Dimensions

Question 58

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

A) End Procedure
B) End Function
C) Option Procedure
D) Option Function

Question 59

Comment lines are preceded by a(n) ____.

A) Period
B) Exclamation point
C) Right parentheses
D) Apostrophe

Question 60

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

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

Question 62

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?
A. Functions
B. Subs
C. Subroutines
D. Declaration statements

Question 63

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

Question 64

_____ modules are displayed as module objects in the Navigation Pane.

Question 65

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

Question 66

The prefix ____________________ is short for Basic and applies to standard modules.

Question 67

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

Question 68

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. Why do forms generally contain more VBA than reports?
A. They generally show one record of data at a time.
B. The user interacts with forms more than reports.
C. They store Structured Query Language.
D. They may contain expressions that calculate new pieces of information.

Question 69

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."
A. Option Explicit
B. Option Compare Database
C. Dim
D. Private Sub

Question 70

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 defines a breakpoint?
A. Run-time error that stops execution in the immediate window
B. Bookmark that stops execution at that statement
C. Syntax error that must be debugged
D. Immediate window that provides more information about the procedure

Question 71

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?
A. Queries
B. Forms
C. Reports
D. Each may store VBA