Deck 14: Creating Macros

Question 1

The End Function statement appears in blue.

Answer 1

True

Question 2

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

Answer 2

True

Question 3

In VBA, normal text is black.

Answer 3

True

Question 4

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

Question 5

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

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

Question 6

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

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

Question 7

GoToControl is an example of a(n) ____.

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

Question 8

In VBA, comment text is black.

Question 9

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

Question 10

In VBA, syntax error text is green.

Question 11

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 12

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

Question 13

How many declaration statements are shown in the figure above?

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

Question 14

VBA uses different colors to mean different things.

Question 15

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

Question 16

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 17

Declaration statements return a value.

Question 18

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

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

Question 19

Which of the following is NOT a type of procedure?

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

Question 20

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

Question 21

This type of procedure manipulates controls and objects.

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

Question 22

This character separates multiple arguments in a function.

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

Question 23

In VBA, keyword text is ____.

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

Question 24

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

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

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

Question 27

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

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

Question 28

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

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

Question 29

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 30

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 31

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

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

Question 32

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 33

VBA stands for ____.

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

Question 34

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

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

Question 35

Comment lines are preceded by a(n) ____.

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

Question 36

This function returns today's date.

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

Question 37

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 38

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 39

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

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

Question 40

Which of the following is NOT a type of module?

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

Question 41

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

Question 42

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 43

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

Question 44

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

Question 45

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

Question 46

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

Question 47

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

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

Question 48

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

Question 49

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

Question 50

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

Question 51

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

Question 52

VBA is written in Visual Basic Design View .

Question 53

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

Question 54

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

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

Question 55

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

Question 56

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

Question 57

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 58

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 59

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

Question 60

Which procedure is triggered after a field is updated?

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

Question 61

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

Question 62

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

Question 64

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

Question 65

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 66

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 67

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

Question 68

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 69

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 70

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

Question 71

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

Question 72

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

Question 73

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

Question 74

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