Question 1

The ________ statement sets the string comparison method for the module.

Accepted Answer

Option Compare

Question 2

VBA can interpret variable names without the use of the Dim statement.

Accepted Answer

A) True 
 B)False  True

Question 3

________ is the process of identifying and reducing the number of errors that can occur within your code.

Accepted Answer

A) Debugging 
B) Error handling 
C) Event-driven programming 
D) Compiling 
A) Debugging 
B) Error handling 
C) Event-driven programming 
D) Compiling A

Question 4

In a(n)________ file,VBA procedures will not be viewable to the user,and any errors that might occur during the execution of a VBA procedure will not result in the Visual Basic Editor being displayed.

Accepted Answer

The answer of In a(n)________ file,VBA procedures will not be...

Question 5

A(n)________ is a constant,variable,or expression that is passed to a procedure.

Accepted Answer

A) transfer method 
B) argument 
C) class 
D) procedure 
A) transfer method 
B) argument 
C) class 
D) procedure

Question 6

________ are placeholders that can be set to a hard-coded value or to an object within VBA and then later modified during the execution of the procedure.

Accepted Answer

A) Arguments 
B) Procedures 
C) Variables 
D) Codes 
A) Arguments 
B) Procedures 
C) Variables 
D) Codes

Question 7

Microsoft Office contains a powerful programming language called Visual Basic for Applications,more commonly known as VBA.

Accepted Answer

A) True 
 B)False

Question 8

________ are used to execute a series of statements multiple times.

Accepted Answer

The answer of ________ are used to execute a series...

Question 9

Objects are combinations of procedures and code that are treated as a single unit.

Accepted Answer

A) True 
 B)False

Question 10

When a database ________,Access examines the procedures in all modules and objects of the database.

Accepted Answer

The answer of When a database ________,Access examines the procedures...

Question 11

The ________ setting results in case-insensitive comparisons.

Accepted Answer

A) Declarations 
B) Option Compare Binary 
C) Project Explorer 
D) Option Compare Text 
A) Declarations 
B) Option Compare Binary 
C) Project Explorer 
D) Option Compare Text

Question 12

________ only works on a line-by-line basis.

Accepted Answer

The answer of ________ only works on a line-by-line basis....

Question 13

A ________ is a type of Sub procedure that is only accessible by other procedures in the module in which it is located.

Accepted Answer

A) Private Sub 
B) Subcommand 
C) Subcode 
D) Submodule 
A) Private Sub 
B) Subcommand 
C) Subcode 
D) Submodule

Question 14

Error handling is the process of identifying and reducing the number of errors that can occur within your code.

Accepted Answer

A) True 
 B)False

Question 15

Line labels can be used like bookmarks in a procedure.

Accepted Answer

A) True 
 B)False

Question 16

Which of the following is NOT true regarding the layout of the Visual Basic Editor?

Accepted Answer

A) Directly under the application title are the Menu bar and Standard toolbar that are visible by default. 
B) The larger window on the right of the Visual Basic Editor is the Module window. 
C) On the left side of the Visual Basic Editor is the Project Explorer. 
D) At the top of the screen is the title of the database that is currently open and being edited. 
A) Directly under the application title are the Menu bar and Standard toolbar that are visible by default. 
B) The larger window on the right of the Visual Basic Editor is the Module window. 
C) On the left side of the Visual Basic Editor is the Project Explorer. 
D) At the top of the screen is the title of the database that is currently open and being edited.

Question 17

________ are placeholders that can be set to a hard-coded value or to an object within VBA and then later modified during the execution of the procedure.

Accepted Answer

The answer of ________ are placeholders that can be set...

Question 18

________ are combinations of data and code that are treated as a single unit.

Accepted Answer

The answer of ________ are combinations of data and code...

Question 19

If a VBA error occurs while Access is running a procedure,you are offered the choice of ending the procedure or entering debugging mode.Choosing to enter debugging mode opens the Visual Basic Editor with the incorrect line of code highlighted in ________.

Accepted Answer

A) green 
B) yellow 
C) blue 
D) gray 
A) green 
B) yellow 
C) blue 
D) gray

Question 20

The ________ statement sets the string comparison method for the module.

Accepted Answer

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

The ________ statement sets the string comparison method for the module.

VBA can interpret variable names without the use of the Dim statement.

________ is the process of identifying and reducing the number of errors that can occur within your code.

In a(n)________ file,VBA procedures will not be viewable to the user,and any errors that might occur during the execution of a VBA procedure will not result in the Visual Basic Editor being displayed.

A(n)________ is a constant,variable,or expression that is passed to a procedure.

________ are placeholders that can be set to a hard-coded value or to an object within VBA and then later modified during the execution of the procedure.

Microsoft Office contains a powerful programming language called Visual Basic for Applications,more commonly known as VBA.

________ are used to execute a series of statements multiple times.

Objects are combinations of procedures and code that are treated as a single unit.

When a database ________,Access examines the procedures in all modules and objects of the database.

The ________ setting results in case-insensitive comparisons.

________ only works on a line-by-line basis.

A ________ is a type of Sub procedure that is only accessible by other procedures in the module in which it is located.

Error handling is the process of identifying and reducing the number of errors that can occur within your code.

Line labels can be used like bookmarks in a procedure.

Which of the following is NOT true regarding the layout of the Visual Basic Editor?

________ are placeholders that can be set to a hard-coded value or to an object within VBA and then later modified during the execution of the procedure.

________ are combinations of data and code that are treated as a single unit.

If a VBA error occurs while Access is running a procedure,you are offered the choice of ending the procedure or entering debugging mode.Choosing to enter debugging mode opens the Visual Basic Editor with the incorrect line of code highlighted in ________.

The ________ statement sets the string comparison method for the module.

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

The ________ statement sets the string comparison method for the module.

VBA can interpret variable names without the use of the Dim statement.

________ is the process of identifying and reducing the number of errors that can occur within your code.

In a(n)________ file,VBA procedures will not be viewable to the user,and any errors that might occur during the execution of a VBA procedure will not result in the Visual Basic Editor being displayed.

A(n)________ is a constant,variable,or expression that is passed to a procedure.

________ are placeholders that can be set to a hard-coded value or to an object within VBA and then later modified during the execution of the procedure.

Microsoft Office contains a powerful programming language called Visual Basic for Applications,more commonly known as VBA.

________ are used to execute a series of statements multiple times.

Objects are combinations of procedures and code that are treated as a single unit.

When a database ________,Access examines the procedures in all modules and objects of the database.

The ________ setting results in case-insensitive comparisons.

________ only works on a line-by-line basis.

A ________ is a type of Sub procedure that is only accessible by other procedures in the module in which it is located.

Error handling is the process of identifying and reducing the number of errors that can occur within your code.

Line labels can be used like bookmarks in a procedure.

Which of the following is NOT true regarding the layout of the Visual Basic Editor?

________ are placeholders that can be set to a hard-coded value or to an object within VBA and then later modified during the execution of the procedure.

________ are combinations of data and code that are treated as a single unit.

If a VBA error occurs while Access is running a procedure,you are offered the choice of ending the procedure or entering debugging mode.Choosing to enter debugging mode opens the Visual Basic Editor with the incorrect line of code highlighted in ________.

The ________ statement sets the string comparison method for the module.

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