Deck 11: Using and Writing Visual Basic for Applications Code

Question 1

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

Answer 1

False

Question 2

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

Answer 2

True

Question 3

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

Answer 3

False

Question 4

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 5

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

Question 6

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

Question 7

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

Question 8

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

Question 9

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

Question 10

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

Question 11

Access events all have associated event properties.____________________

Question 12

Event procedures are always Sub procedures.

Question 13

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

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

Question 14

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 15

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

Question 16

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

Question 17

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 18

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

Question 19

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

Question 20

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

Question 21

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 22

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 23

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 24

Which of the following is a type of VBA procedure?

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

Question 25

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 26

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

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

Question 27

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 28

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

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 31

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

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

Question 32

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 33

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 34

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 35

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

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

Question 36

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

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

Question 37

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 38

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 39

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 40

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 41

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 42

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 43

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 44

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

Question 45

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 46

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

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

Question 47

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 48

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 49

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 50

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 51

Which VB data type stores values of True or False?

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

Question 52

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 53

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

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

Question 54

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

Question 55

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 56

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 57

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

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

Question 58

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 59

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 60

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 66

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