Question 1

________ perform a set of instructions and can pass multiple values to other procedures.

Accepted Answer

The answer of ________ perform a set of instructions and...

Question 2

Converting a macro to VBA opens the ________ automatically.

Accepted Answer

The answer of Converting a macro to VBA opens the...

Question 3

Match between columns
                        Premises: Modules
Methods
Objects
Object-oriented programming
Visual Basic Editor

Accepted Answer

The Answer of Built into Microsoft Office and Used to is...

Question 4

Debugging is the process of anticipating and controlling errors.

Accepted Answer

A) True 
 B)False

Question 5

Which of the following is NOT true regarding VBA?

Accepted Answer

A) Microsoft Office contains a powerful programming language called Visual Basic for Access or more commonly known as VBA. 
B) The tools for using VBA are installed by default in most instances. 
C) Many people incorrectly perceive that you need to be a "programmer" in order to use VBA. 
D) VBA can allow for a wide variety of enhancements to any Microsoft Office application. 
A) Microsoft Office contains a powerful programming language called Visual Basic for Access or more commonly known as VBA. 
B) The tools for using VBA are installed by default in most instances. 
C) Many people incorrectly perceive that you need to be a "programmer" in order to use VBA. 
D) VBA can allow for a wide variety of enhancements to any Microsoft Office application.

Question 6

The ________ object allows Access actions to be performed from within VBA.

Accepted Answer

A) GoCmd 
B) RunCmd 
C) VbaCmd 
D) DoCmd 
A) GoCmd 
B) RunCmd 
C) VbaCmd 
D) DoCmd

Question 7

A(n)________ consists of a single space followed by a single underscore character as the last character in a line of code.

Accepted Answer

line conti

Question 8

A line continuation character consists of a single space followed by a single underscore character as the last character in a line of code.This tells the Visual Basic Editor that the two lines of code should be treated as separate lines of code.

Accepted Answer

A) True 
 B)False

Question 9

Which of the following is NOT true when securing VBA code?

Accepted Answer

A) Before implementing a database that contains VBA,all modules should be checked for potential errors. 
B) Error checking will prevent users from encountering unnecessary and confusing errors while using the database. 
C) Unsecured VBA can be altered either intentionally or unintentionally,but it can be easily secured to prevent this. 
D) You do not need to secure your VBA so that it is not copied. 
A) Before implementing a database that contains VBA,all modules should be checked for potential errors. 
B) Error checking will prevent users from encountering unnecessary and confusing errors while using the database. 
C) Unsecured VBA can be altered either intentionally or unintentionally,but it can be easily secured to prevent this. 
D) You do not need to secure your VBA so that it is not copied.

Question 10

The ________ setting examines the ASCII values for the characters contained in a string and is therefore case sensitive.

Accepted Answer

Option Com

Question 11

The ________ contains a list of the currently open Access Database objects that contain VBA procedures and a list of modules within the current database.

Accepted Answer

A) Project Explorer 
B) Procedure window 
C) module 
D) Code window 
A) Project Explorer 
B) Procedure window 
C) module 
D) Code window

Question 12

The ________ contains a list of the currently open Access Database objects that contain VBA procedures and a list of modules within the current database.

Accepted Answer

The answer of The ________ contains a list of the...

Question 13

________ uses an event to trigger the execution of code.

Accepted Answer

Event-driv

Question 14

The ________ defines user-defined data types,variables,arrays,and constants.

Accepted Answer

A) Declarations section 
B) Code window 
C) Option Compare statements 
D) Project Explorer 
A) Declarations section 
B) Code window 
C) Option Compare statements 
D) Project Explorer

Question 15

Saving a database in .accdb format creates a new copy of the database that can then be given to the user.

Accepted Answer

A) True 
 B)False

Question 16

The ________ object can be used to allow the user to select the file(s)needed for the import process.

Accepted Answer

A) FileDialog 
B) Dim 
C) With 
D) If 
A) FileDialog 
B) Dim 
C) With 
D) If

Question 17

Which of the following is NOT true in regard to password protecting the VBA code?

Accepted Answer

A) The Visual Basic Editor provides a method of securing the VBA in a database while implementing more general security measures. 
B) Access security measures can affect many aspects of the database and are extremely useful tools for deploying databases to users. 
C) Any VBA code in a database can be secured by providing a separate password via the Visual Basic Editor. 
D) Password protection can allow for full editing of the database by the user without compromising the integrity of the VBA code. 
A) The Visual Basic Editor provides a method of securing the VBA in a database while implementing more general security measures. 
B) Access security measures can affect many aspects of the database and are extremely useful tools for deploying databases to users. 
C) Any VBA code in a database can be secured by providing a separate password via the Visual Basic Editor. 
D) Password protection can allow for full editing of the database by the user without compromising the integrity of the VBA code.

Question 18

Objects have ________ that are actions,such as SaveAs,that control the object's behavior.

Accepted Answer

A) actions 
B) objects 
C) methods 
D) procedures 
A) actions 
B) objects 
C) methods 
D) procedures

________ perform a set of instructions and can pass multiple values to other procedures.

Converting a macro to VBA opens the ________ automatically.

Debugging is the process of anticipating and controlling errors.

Which of the following is NOT true regarding VBA?

The ________ object allows Access actions to be performed from within VBA.

A(n)________ consists of a single space followed by a single underscore character as the last character in a line of code.

A line continuation character consists of a single space followed by a single underscore character as the last character in a line of code.This tells the Visual Basic Editor that the two lines of code should be treated as separate lines of code.

Which of the following is NOT true when securing VBA code?

The ________ setting examines the ASCII values for the characters contained in a string and is therefore case sensitive.

The ________ contains a list of the currently open Access Database objects that contain VBA procedures and a list of modules within the current database.

The ________ contains a list of the currently open Access Database objects that contain VBA procedures and a list of modules within the current database.

________ uses an event to trigger the execution of code.

The ________ defines user-defined data types,variables,arrays,and constants.

Saving a database in .accdb format creates a new copy of the database that can then be given to the user.

The ________ object can be used to allow the user to select the file(s)needed for the import process.

Which of the following is NOT true in regard to password protecting the VBA code?

Objects have ________ that are actions,such as SaveAs,that control the object's behavior.

Workshop 1: The Four Main Database Objects

Workshop 2: Tables, Keys, and Relationships

Workshop 3: Queries and Data Access

Workshop 4: Access Information From an Access Database

Workshop 5: Advanced Tables

Workshop 6: Pattern Matching and Functions in Queries

Workshop 7: Aggregated Calculations, Subquerying, and Sql

Workshop 8: Action Queries and Advanced Relationships

Workshop 9: Advanced Reports and Mailing Labels

Workshop 10: Advanced Form Settings and Form Types

Workshop 11: Develop Navigation Forms and the User Interface

Workshop 12: Create a Refined User Experience With Macros

Workshop 14: Implement Your Database

Normalize a Database for Effective Design

The Common Features of Microsoft Office

Efficient Interaction With a Touch Screen

Filters

Exam 13: Workshop 13: Use VBA in Access

________ perform a set of instructions and can pass multiple values to other procedures.

Converting a macro to VBA opens the ________ automatically.

Debugging is the process of anticipating and controlling errors.

Which of the following is NOT true regarding VBA?

The ________ object allows Access actions to be performed from within VBA.

A(n)________ consists of a single space followed by a single underscore character as the last character in a line of code.

A line continuation character consists of a single space followed by a single underscore character as the last character in a line of code.This tells the Visual Basic Editor that the two lines of code should be treated as separate lines of code.

Which of the following is NOT true when securing VBA code?

The ________ setting examines the ASCII values for the characters contained in a string and is therefore case sensitive.

The ________ contains a list of the currently open Access Database objects that contain VBA procedures and a list of modules within the current database.

The ________ contains a list of the currently open Access Database objects that contain VBA procedures and a list of modules within the current database.

________ uses an event to trigger the execution of code.

The ________ defines user-defined data types,variables,arrays,and constants.

Saving a database in .accdb format creates a new copy of the database that can then be given to the user.

The ________ object can be used to allow the user to select the file(s)needed for the import process.

Which of the following is NOT true in regard to password protecting the VBA code?

Objects have ________ that are actions,such as SaveAs,that control the object's behavior.

Workshop 1: The Four Main Database Objects

Workshop 2: Tables, Keys, and Relationships

Workshop 3: Queries and Data Access

Workshop 4: Access Information From an Access Database

Workshop 5: Advanced Tables

Workshop 6: Pattern Matching and Functions in Queries

Workshop 7: Aggregated Calculations, Subquerying, and Sql

Workshop 8: Action Queries and Advanced Relationships

Workshop 9: Advanced Reports and Mailing Labels

Workshop 10: Advanced Form Settings and Form Types

Workshop 11: Develop Navigation Forms and the User Interface

Workshop 12: Create a Refined User Experience With Macros

Workshop 14: Implement Your Database

Normalize a Database for Effective Design

The Common Features of Microsoft Office

Efficient Interaction With a Touch Screen

Filters