Deck 12: Using and Writing Visual Basic for Applications Code

Question 1

It is important to enter VBA code using appropriate capitalization in all statements so that the code can be read and maintained properly.

Answer 1

True

Question 2

A control is hidden in Access when the Visible property is False in a Case statement.

Answer 2

True

Question 3

A control is displayed when the IsNull property is True in a procedure statement.____________________

Answer 3

False

Question 4

When a module is created it must begin with a Procedures section that applies to all procedures in the module.____________________

Question 5

An example of a conditional control structure is the Case control structure.____________________

Question 6

The way an object responds when an event occurs is determined by an associated object property.____________________

Question 7

The function that accepts a single string argument as input, converts the value of the argument to lowercase letters, then returns the converted value is the LCase function. ____________________

Question 8

The Declarations section of a VBA module contains statements that apply to all procedures in the module.____________________

Question 9

When using the RGB function in VBA, the color range for each value must be between the numbers of 0 through 150.

Question 10

The AfterUpdate event occurs before data is changed in a control or record and the data is updated in the database.____________________

Question 11

Event procedures are always Sub procedures.

Question 12

Access events all have associated event properties.____________________

Question 13

To convert a string to proper case where the first letter of every word in the string is uppercase, the StrConv function is used in VBA code.____________________

Question 14

It is not possible to convert an Access macro to VBA code.

Question 15

Procedures included in a standard module may only be used by the form or report for which the event procedure was coded.

Question 16

The event name for a procedure being viewed in the VBE is indicated in the Object box. ____________________

Question 17

VBA has features that are unique for each Microsoft Office program in addition to features that are common across applications.

Question 18

There is no default initial value set for any event property associated with Access forms, reports, or controls.

Question 19

The statement that indicates a Case control structure ends with End Select.

Question 20

An input mask can accomplish the same verification procedures on data that VBA can accomplish such as verifying the @ symbol in an email address.

Question 21

In the Declarations statement "Option Compare Database," Database determines how the procedure will ____ the data.

A) organize
B) filter
C) run
D) sort

Question 22

Visual Basic for Applications is a(n) ____ provided with Microsoft Office programs.

A) application
B) event builder
C) programming language
D) system program

Question 23

Which of the following is a type of VBA procedure?

A) Format
B) Control
C) Reference
D) Function

Question 24

VBA code is created and modified using the ____.

A) Visual Basic Window
B) Visual Basic Editor
C) Visual Basic Design view
D) Procedure Window

Question 25

Which of the following color options may be assigned to a control property as a VBA constant?

A) vbRed
B) RGB(255,0,0)
C) CMYK(0, 21, 151)
D) vbRGB(151, 12, 276)

Question 26

To assign a purple ForeColor property to a control, the ____ function of VBA must be used.

A) vbColor
B) vbPurple
C) RGB
D) RGCYK

Question 27

A predefined memory location initialized to a value that does not change in VBA is called a(n) ____.

A) Procedure default
B) VBA constant
C) Function constant
D) Property default

Question 28

The purpose of a VBA ____ is to respond to an event that occurs with an object or form control in an Access database.

A) statement
B) Case control
C) event
D) procedure

Question 29

VBA is considered to be what type of language?

A) rule-based programming language
B) a markup language
C) an assembly language
D) an event-driven language

Question 30

When a procedure is created, the ____ determines where the procedure is available.

A) Declarations statement
B) scope
C) Procedure
D) object properties

Question 31

The type of procedure that may be used by more than one object in a database is a(n) ____.

A) standard module
B) function statement
C) public procedure
D) declarations module

Question 32

VBA is considered to be a(n) ____ programming language because instructions are executed on objects in the database.

A) markup
B) object-oriented
C) compiler
D) assembly

Question 33

VBA procedures are created, modified, and displayed in the ____ window.

A) Immediate
B) Code
C) VBA
D) Query

Question 34

In the accompanying figure, arrow number one indicates which element of the Code window in the Visual Basic window?

A) Object box
B) statement in the Declarations section
C) Sub procedure for the form's current event
D) Procedure box

Question 35

In the accompanying figure, arrow number four indicates which element of the Code window in the Visual Basic window?

A) Declarations section
B) Object box
C) Procedure box
D) Sub routine for the Current event

Question 36

The type of procedure that executes instructions and accepts input values, but does not return a value and cannot be used in expressions, is a(n) ____ procedure.

A) Function
B) Sub
C) Reference
D) Comment

Question 37

In the accompanying figure, arrow number three indicates which element of the Code window in the Visual Basic window?

A) form name
B) Object box
C) Procedure box
D) Sub procedure for the Current event

Question 38

A ____ module is automatically created when the first event procedure for a form or report is created and it is associated with that specific form or report.

A) class
B) local
C) standard
D) public

Question 39

In the accompanying figure, arrow number two indicates which element of the Code window in the Visual Basic window?

A) Object box
B) Procedure box
C) Sub procedure for the form's Current event
D) Declarations statement

Question 40

In a Case control structure, Case Else instructs the procedure to ____.

A) stop running
B) sort data in a new manner
C) filter data based on new requirements
D) start an alternative set of actions

Question 41

The Immediate window allows the developer to test or ____ individual lines of VBA code.

A) restore
B) compile
C) debug
D) append

Question 42

In addition to the single quotation mark ('), a comment line in VBA code may begin with ____.

A) REM
B) COMMENT
C) slash (/)
D) semi-colon (;)

Question 43

Which of the following is a method used in a procedure to move the focus to a specific object or control.

A) Dim
B) SetFocus
C) Me.Undo
D) IsNull

Question 44

In the accompanying figure, Access will execute a group of statements only when the condition of the If statement is true; therefore, the false-statement group which is preceded by ____ in an If statement is omitted.

A) Else
B) Then
C) If Else
D) If Not

Question 45

Color values for controls may be coded in several different ways.  Which type of color value represents color intensities of red, green, and blue instead of the color values ranging from 0-255?

A) RGB
B) VB constant
C) ColorIndex
D) hexadecimal

Question 46

In the accompanying figure, ____ serves as a placeholder for the input value in the function definition.

A) LCase
B) (FValue)
C) LowAll
D) Option Compare

Question 47

In the accompanying figure, the comment for the module begins with ____.

A) Option
B) Function
C) single quotation mark (')
D) LowAll

Question 48

The following code is testing a field in the associated form for specific input.  Which string is the Case structure looking for in the form?    Select Case [Course]
   Case "CIS 101"
   lblMessage, Caption = "Prerequisite CIS 100 required"

A) Course
B) CIS 100
C) CIS 101
D) Prerequisite CIS 100 required

Question 49

The accompanying figure is an example of a(n) ____.

A) macro
B) function
C) event procedure
D) standard module

Question 50

A comment line in the Code windows is indented and appears in the color ___.

A) red
B) green
C) blue
D) black

Question 51

In the accompanying figure, the Case structure is testing values for which field in the form?

A) Influenza
B) Reason
C) Annual wellness visit
D) Visible

Question 52

In the accompanying figure, LowAll is the ____ name.

A) event
B) procedure
C) module
D) function

Question 53

All event procedures in a class module are a(n) ____ procedures which means they may only be used for the form or report for which the class module was created.

A) public
B) local
C) Case
D) Sub

Question 54

In the following code, which field in the associated form is being used for the Case structure?    Select Case [Course]
   Case "CIS 101"
   lblMessage, Caption = "Prerequisite CIS 100 required"

A) CIS 101
B) Course
C) CIS 100
D) Case CIS 101

Question 55

Which code statement will test a control to see if the data meets specific requirements?

A) VisitDate.ForeColor=vbRed
B) ZipCode=27531
C) Select Case [State]
D) If VisitDate

Question 56

To declare variables and the VBA data types associated with those variables in a procedure a(n) ____ must be used.

A) Sub statement
B) Declaration statement
C) Dim statement
D) Case statement

Question 57

A control is not displayed when the Visible property is to ____.

A) Yes
B) No
C) True
D) False

Question 58

The Visual Basic window is accessed using the ____ group from the CREATE tab.

A) Forms
B) Macros & Code
C) Templates
D) VBA

Question 59

Which of the following Access events accepts new or changed data from a user entry by default.

A) OnClick
B) AfterUpdate
C) OnChange
D) OnKeyPress

Question 60

In the accompanying figure, a RGB value has been assigned to the ____ property of the control.

A) Caption
B) lblMessage
C) ForeColor
D) Case

Question 61

A set of VBA statements that work together as a unit is a(n) ____________________.

Question 62

Case-Based Critical Thinking Questions Case 11-1
Luca is the database administrator for a city parks and recreation department.  The department routinely uses community college interns to process applications and registration for the department's programs. It is important that the user interface minimize user input errors as much as possible.
Luca wants to be sure that a message appears to the user prompting that an email be sent to all program participants reminding them of the date the program begins when the Paid field in the form is marked paid.  What type of structure will Luca use to code an expression that tests the Paid field for an entry?

A) If structure
B) Case control structure
C) Compare control structure
D) If, then structure

Question 63

Case-Based Critical Thinking Questions Case 11-2 The Environmental Policy Group is collecting data on weather conditions throughout the southeast U.S. The database used for data collection is being used by field technicians throughout the region.  Louisa has been asked to update the database to reduce data entry mistakes.  Louisa will create some new procedures and update others in the database.
Before beginning her task, Louisa will review the procedures that have already been coded using VBA in the database. Where will she find the procedures on the Navigation Pane of the database?

A) under the Queries bar
B) under the Modules bar
C) under the Forms bar
D) under the Reports bar

Question 64

Which code best represents the procedure Louisa has written to convert the City field values to proper case in the database?

A) Private Sub EventProcedure _ VB Constant     'Convert City to proper case     [ Field ] = VBA Function ([ Field ],   Event Procedure
End Sub
B) Private Sub Field _ EventProcedure     'Convert City to proper case     [ Field ] = VBA Function ([ Field ], VB Constant
End Sub
C) Private Sub Field _ EventProcedure     'Convert City to proper case     [ VB Constant ] = VBA Function ([ Field ], Field
End Sub
D) Private Sub VB Function _ EventProcedure     'Convert City to proper case     [ VBAFunction ] = ([ Field ], VB Constant
End Sub

Question 65

The default scope of event procedures in an Access database is ____________________ which means the procedure is only available to the object in which it was created.

Question 66

The number of Code windows that may open at one time is determined by the number of ____________________ in the database.

Question 67

Which VB constant used in conjunction with the StrConv function will convert all characters of a string to upper case letters?

A) vbProperCase
B) vbLowerCase
C) vbUpperCase
D) vbAllCaps

Question 68

Case-Based Critical Thinking Questions Case 11-1
Luca is the database administrator for a city parks and recreation department.  The department routinely uses community college interns to process applications and registration for the department's programs. It is important that the user interface minimize user input errors as much as possible.
After creating the message control using VBA, which property of the control must be coded to display the message "Email the participant with the start date of the program"?

A) Caption
B) Text
C) Special Effect
D) Statement

Question 69

Case-Based Critical Thinking Questions Case 11-1
Luca is the database administrator for a city parks and recreation department.  The department routinely uses community college interns to process applications and registration for the department's programs. It is important that the user interface minimize user input errors as much as possible.
Luca needs to use a VBA function in his code to return a value of True if the Paid field has no data or a value of False if the Paid field is not empty. Which VBA function should Luca use?

A) IsPaid
B) IsNum
C) IsNull
D) IsBound

Question 70

One or more characters that might include alphabetic characters, numbers, spaces, and punctuation is called a(n) ____________________.

Question 71

If the Paid field is marked as paid in the Participant Information form, Luca wants the following message to appear on the screen "Email the participant with the start date of the program."  Which type of VBA control should Luca use in the procedure to create the message?

A) combo box
B) radio button
C) message
D) label

Question 72

A(n) ____________________ assigns the value of an expression to a field, control or property.

Question 73

A(n) ____________________ is an object that stores a group of related procedures.

Question 74

Which VB data type stores values of True or False?

A) Decimal
B) Object
C) Variant
D) Boolean

Question 75

Case-Based Critical Thinking Questions Case 11-2 The Environmental Policy Group is collecting data on weather conditions throughout the southeast U.S. The database used for data collection is being used by field technicians throughout the region.  Louisa has been asked to update the database to reduce data entry mistakes.  Louisa will create some new procedures and update others in the database.
Louisa wants to be sure that all city locations are recorded in proper case in the database.  To do this, she needs to use the ____ event procedure which will automatically change the data entered in the City field to proper case any time a value is entered or changed in the field. For instance, if the user enters san antonio in the City field, the procedure will change the data to San Antonio and store it in the database.

A) OnChange
B) OnEnter
C) AfterUpdate
D) BeforeUpdate

Question 76

A(n) ____________________ performs operations, returns a value, accepts input values, and may be used in expressions.

Question 77

Because Louisa's code will only be used in Access, she can use a VBA constant in the code argument to change the City field's value to proper case.  Which VBA constant should Louisa use?

A) vbUpperCase
B) vbLowerCase
C) vbChangeCase
D) vbProperCase

Question 78

Case-Based Critical Thinking Questions Case 11-1
Luca is the database administrator for a city parks and recreation department.  The department routinely uses community college interns to process applications and registration for the department's programs. It is important that the user interface minimize user input errors as much as possible.
Because the event procedure that Luca is coding will only be used for the Participant Information form, the procedure is a(n) ____ procedure.

A) private
B) public
C) remote
D) shared

Question 79

Case-Based Critical Thinking Questions Case 11-2 The Environmental Policy Group is collecting data on weather conditions throughout the southeast U.S. The database used for data collection is being used by field technicians throughout the region.  Louisa has been asked to update the database to reduce data entry mistakes.  Louisa will create some new procedures and update others in the database.
Once Louisa codes the correct event procedure in her code, she will use the ____ function to begin the conversion of the data to proper case.

A) StrChange
B) ChangeString
C) ConvertSTR
D) StrConv

Question 80

A group of statements coded using VBA to perform a set of operations or to calcualte a value is called a(n) ____________________.