Deck 15: Creating Modules and Vba

Question 1

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

Answer 1

True

Question 2

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

Answer 2

B

Question 3

In the figure above, which of the following is NOT a VBA keyword or keyword phrase?

A) Function
B) BMI
C) End Function
D) Option Compare Database

Answer 3

B

Question 4

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

Question 5

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 6

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

Question 7

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

Question 8

Declaration statements return a value.

Question 9

How many declaration statements are shown in the figure above?

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

Question 10

VBA uses different colors to mean different things.

Question 11

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

A) BMI
B) weight
C) height * 0.0254
D) End If

Question 12

In VBA, normal text is black.

Question 13

The End Function statement appears in blue.

Question 14

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

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

Question 15

GoToControl is an example of a(n) ____.

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

Question 16

In VBA, comment text is black.

Question 17

Which of the following is NOT a type of procedure?

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

Question 18

In VBA, syntax error text is green.

Question 19

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

Question 20

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

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

Question 21

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 22

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

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

Question 23

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

A) Object Browser
B) Break
C) Project Explorer
D) Database

Question 24

Which of the following is NOT a type of module?

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

Question 25

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 26

This function returns today's date.

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

Question 27

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

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

Question 28

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 29

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 30

Comment lines are preceded by a(n) ____.

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

Question 31

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

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

Question 32

In the figure above, what is the function of item 1?

A) Opens a new module
B) Switches from active VB window to the Access window
C) Locks the procedure
D) Displays a list of currently open projects

Question 33

In VBA, keyword text is ____.

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

Question 34

This character separates multiple arguments in a function.

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

Question 35

This type of procedure manipulates controls and objects.

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

Question 36

VBA stands for ____.

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

Question 37

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

A) UserForm
B) Run Sub/UserForm
C) Reset
D) Project Explorer

Question 38

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

A) Object Browser
B) Run Sub/UserForm
C) Insert Module
D) View Database

Question 39

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 40

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 41

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

Question 42

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

Question 43

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

Question 44

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

Question 45

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

Question 46

VBA is written in Visual Basic Design View.

Question 47

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 48

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

Question 49

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

Question 50

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

Question 51

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 52

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

Question 53

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

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

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

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

Question 56

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

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

Question 57

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 58

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

Question 59

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

Question 60

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

Question 61

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

Question 62

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

Question 63

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

Match each term with the best choice.
a.Argument
d.Procedure
b.Object
e.Module
c.Method
A constant, variable, or expression needed by a procedure to execute

Question 65

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

Question 66

Match each term with the best choice.
a.Argument
d.Procedure
b.Object
e.Module
c.Method
Any item that can be identified or manipulated

Question 67

Match each term with the best choice.
a.Argument
d.Procedure
b.Object
e.Module
c.Method
An action that an object can perform

Question 68

Match each term with the best choice.
a.Argument
d.Procedure
b.Object
e.Module
c.Method
An object that stores VBA code

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

CASE
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

Question 71

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

Question 72

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

Question 73

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 74

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

Question 75

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

Question 76

Match each term with the best choice.
a.Argument
d.Procedure
b.Object
e.Module
c.Method
A series of VBA statements that performs an operation

Question 77

CASE
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