Question 1

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

Accepted Answer

A) Rem 
B) Comment 
C) slash (/) 
D) semi-colon (;) 
A) Rem 
B) Comment 
C) slash (/) 
D) semi-colon (;)

Question 2

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

Accepted Answer

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

Question 3

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?

Accepted Answer

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

Question 4

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

Accepted Answer

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

Question 5

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

Accepted Answer

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

Question 6

Match between columns
                        Premises: Occurs when the focus moves to a record, making it the current record, or when a form is refreshed.

Accepted Answer

The Answer of logic error and  Object box and is...

Question 7

Match between columns
                        Premises: The statement that marks the start of a new Sub procedure.

Accepted Answer

The Answer of function call and Load and Current and is...

Question 8

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

Accepted Answer

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

Question 9

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

Accepted Answer

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

Question 10

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

Accepted Answer

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

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

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

Question 13

Which VB data type stores values of True or False?

Accepted Answer

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

Question 14

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

Accepted Answer

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

Question 15

Access events all have associated event properties.____________________

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

Match between columns
                        Premises: The Access event that occurs when a form is opened and the records are displayed.

Accepted Answer

The Answer of RGB and Assignment statement and bas and is...

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

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

Question 20

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

Accepted Answer

A) True 
 B)False

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

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

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?

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

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

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

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

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

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

Which VB data type stores values of True or False?

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

Access events all have associated event properties.____________________

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

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

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

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

Access-Module 1: Creating a Database

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

Creating Forms and Reports

Creating Advanced Queries and Enhancing Table Design

Using Form Tools and Creating Custom Forms

Creating Custom Reports

Sharing, Integrating, and Analyzing Data

Using Action Queries and Advanced Table Relationships

Automating Tasks With Macros

Managing and Securing a Database

Relational Databases and Database Design

Filters

Exam 11: Using and Writing Visual Basic for Applications Code

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

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

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?

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

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

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

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

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

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

Which VB data type stores values of True or False?

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

Access events all have associated event properties.____________________

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

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

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

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

Access-Module 1: Creating a Database

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

Creating Forms and Reports

Creating Advanced Queries and Enhancing Table Design

Using Form Tools and Creating Custom Forms

Creating Custom Reports

Sharing, Integrating, and Analyzing Data

Using Action Queries and Advanced Table Relationships

Automating Tasks With Macros

Managing and Securing a Database

Relational Databases and Database Design

Filters