Deck 11: Using and Writing Visual Basic for Applications Code

Question 1

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

Answer 1

False
BeforeUpdate

Question 2

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

Answer 2

False
Procedure

Question 3

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

Answer 3

False

Question 4

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

Question 5

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 6

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

Question 7

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

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

Question 8

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

Question 9

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

Question 10

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

Question 11

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 12

Event procedures are always Sub procedures.

Question 13

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

Question 14

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

Question 15

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

Question 16

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

Question 17

Access events all have associated event properties.____________________

Question 18

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

Question 19

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

Question 20

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

Question 21

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 22

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

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

Question 23

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 24

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 25

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 26

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 27

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 28

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 29

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 30

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 31

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

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

Question 32

Which of the following is a type of VBA procedure?

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

Question 33

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 34

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

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

Question 35

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 <#1//1/2017#

Question 36

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 37

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

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

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

Question 40

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 41

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 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 VB data type stores values of True or False?

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

Question 44

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 45

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 46

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

List the five VBA naming rules that must be followed when naming VBA elements such as Sub procedures,arguments,and functions

Question 48

List four advantages of using VBA rather than macros in Access.

Question 49

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 50

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

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

Question 51

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 52

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 53

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

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

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

Question 55

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 56

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

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

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 60

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 61

a.coding
b.Sub statement
c.logic error
d.RGB
e.function call
f.Current
g.Assignment statement
h.Visual Basic window
i.Load
j.bas
k.Object box
l.Case statement
m.Immediate window
n.Procedure box
The program window that opens when VB is chosen from the Macros & Code group on the Create tab.

Question 62

a.coding
b.Sub statement
c.logic error
d.RGB
e.function call
f.Current
g.Assignment statement
h.Visual Basic window
i.Load
j.bas
k.Object box
l.Case statement
m.Immediate window
n.Procedure box
A statement that assigns the value of an expression to a field,control,or property.

Question 63

a.coding
b.Sub statement
c.logic error
d.RGB
e.function call
f.Current
g.Assignment statement
h.Visual Basic window
i.Load
j.bas
k.Object box
l.Case statement
m.Immediate window
n.Procedure box
The process of writing instructions in a programming language.

Question 64

a.coding
b.Sub statement
c.logic error
d.RGB
e.function call
f.Current
g.Assignment statement
h.Visual Basic window
i.Load
j.bas
k.Object box
l.Case statement
m.Immediate window
n.Procedure box
An error that occurs when a procedure produces incorrect results.

Question 65

Why is it recommended that procedures be compiled after they are first created or when changes are made to the procedure code?

Question 66

a.coding
b.Sub statement
c.logic error
d.RGB
e.function call
f.Current
g.Assignment statement
h.Visual Basic window
i.Load
j.bas
k.Object box
l.Case statement
m.Immediate window
n.Procedure box
​Tests VBA procedures without changing any data in the database

Question 67

a.coding
b.Sub statement
c.logic error
d.RGB
e.function call
f.Current
g.Assignment statement
h.Visual Basic window
i.Load
j.bas
k.Object box
l.Case statement
m.Immediate window
n.Procedure box
Occurs when the focus moves to a record,making it the current record,or when a form is refreshed.

Question 68

a.coding
b.Sub statement
c.logic error
d.RGB
e.function call
f.Current
g.Assignment statement
h.Visual Basic window
i.Load
j.bas
k.Object box
l.Case statement
m.Immediate window
n.Procedure box
A set of values for the colors red,green,and blue ranging from 0 to 255 which are used in a specific VB function.

Question 69

a.coding
b.Sub statement
c.logic error
d.RGB
e.function call
f.Current
g.Assignment statement
h.Visual Basic window
i.Load
j.bas
k.Object box
l.Case statement
m.Immediate window
n.Procedure box
A statement that contains the name of the function and any parameters required by the function.

Question 70

a.coding
b.Sub statement
c.logic error
d.RGB
e.function call
f.Current
g.Assignment statement
h.Visual Basic window
i.Load
j.bas
k.Object box
l.Case statement
m.Immediate window
n.Procedure box
​Displays the event name for the current event procedure

Question 71

a.coding
b.Sub statement
c.logic error
d.RGB
e.function call
f.Current
g.Assignment statement
h.Visual Basic window
i.Load
j.bas
k.Object box
l.Case statement
m.Immediate window
n.Procedure box
​Designates the start of an alternative set of actions

Question 72

a.coding
b.Sub statement
c.logic error
d.RGB
e.function call
f.Current
g.Assignment statement
h.Visual Basic window
i.Load
j.bas
k.Object box
l.Case statement
m.Immediate window
n.Procedure box
The statement that marks the start of a new Sub procedure.

Question 73

a.coding
b.Sub statement
c.logic error
d.RGB
e.function call
f.Current
g.Assignment statement
h.Visual Basic window
i.Load
j.bas
k.Object box
l.Case statement
m.Immediate window
n.Procedure box
The standard prefix for modules in Access.

Question 74

a.coding
b.Sub statement
c.logic error
d.RGB
e.function call
f.Current
g.Assignment statement
h.Visual Basic window
i.Load
j.bas
k.Object box
l.Case statement
m.Immediate window
n.Procedure box
The Access event that occurs when a form is opened and the records are displayed.

Question 75

a.coding
b.Sub statement
c.logic error
d.RGB
e.function call
f.Current
g.Assignment statement
h.Visual Basic window
i.Load
j.bas
k.Object box
l.Case statement
m.Immediate window
n.Procedure box
​Displays the current object type the procedure acts on.