Question 1

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 2

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

Accepted Answer

A) True 
 B)False

Question 3

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 4

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

Accepted Answer

Student answers will vary but should inc

Question 5

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

Accepted Answer

The Answer of Visual Basic window and Current and bas is...

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

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

Question 8

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

Accepted Answer

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

Question 9

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 10

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

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

Match between columns
                        Premises: A set of values for the colors red, green, and blue ranging from 0 to 255 which are used in a specific VB function.

Accepted Answer

The Answer of RGB and Sub statement and Current and is...

Question 13

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

Accepted Answer

assignment

Question 14

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

Accepted Answer

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

Question 15

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 16

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

Accepted Answer

A) True 
 B)False

Question 17

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.

Accepted Answer

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

Question 18

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"

Accepted Answer

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

Question 19

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

Accepted Answer

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

Question 20

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

Accepted Answer

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

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

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

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

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

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

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

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

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

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

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

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

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 statement that indicates a Case control structure ends with End Select.

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.

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"

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

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

Managing Your Files

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 Sharing a Database

Filters

Exam 12: Using and Writing Visual Basic for Applications Code

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

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

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

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

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

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

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

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

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

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

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

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 statement that indicates a Case control structure ends with End Select.

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.

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"

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

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

Managing Your Files

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 Sharing a Database

Filters