Question 1

In the accompanying figure, LowAll is the ____ name.

Accepted Answer

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

Question 2

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

Accepted Answer

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

Question 3

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

Accepted Answer

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

Question 4

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

Accepted Answer

The answer of A group of statements coded using VBA...

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

Match between columns
                        Premises: The program window that opens when VB is chosen from the Macros & Code group on the CREATE tab.

Accepted Answer

The Answer of function call and Visual Basic window and is...

Question 7

Match between columns
                        Premises: A statement that contains the name of the function and any parameters required by the function.

Accepted Answer

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

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

Student answers may vary but should be s

Question 10

____ is the process of translating VBA modules to a form that is understood by a computer processor.

Accepted Answer

The answer of ____ is the process of translating VBA...

Question 11

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

Accepted Answer

The answer of A set of VBA statements that work...

Question 12

Match between columns
                        Premises: The standard prefix for modules in Access.

Accepted Answer

The Answer of bas and coding and Sub statement and is...

Question 13

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

Accepted Answer

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

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.

Accepted Answer

A) True 
 B)False

Question 15

The value that is passed to a function and used in place of the placeholder (parameter) when the function is executed is called a(n) ____________________.

Accepted Answer

The answer of The value that is passed to a...

Question 16

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 17

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

Accepted Answer

The answer of The number of Code windows that may...

Question 18

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

Accepted Answer

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

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

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 Visual Basic window and RGB and Assignment is...

In the accompanying figure, LowAll is the ____ name.

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

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

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

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

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

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

____ is the process of translating VBA modules to a form that is understood by a computer processor.

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

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

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

The value that is passed to a function and used in place of the placeholder (parameter) when the function is executed is called a(n) ____________________.

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

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

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

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

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

In the accompanying figure, LowAll is the ____ name.

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

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

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

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

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

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

____ is the process of translating VBA modules to a form that is understood by a computer processor.

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

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

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

The value that is passed to a function and used in place of the placeholder (parameter) when the function is executed is called a(n) ____________________.

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

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

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

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

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