Question 1

________ statements in VBA work similarly to those found in Access and Excel though the syntax is slightly different.

Accepted Answer

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

Question 2

________ are used to store VBA procedures that can be referenced or called by other procedures in the database.

Accepted Answer

The answer of ________ are used to store VBA procedures...

Question 3

A ________ can run on its own.

Accepted Answer

A) function 
B) line continuation character 
C) Sub procedure 
D) declaration 
A) function 
B) line continuation character 
C) Sub procedure 
D) declaration

Question 4

A(n)________ executes instructions and returns a value to another procedure.

Accepted Answer

A) function 
B) line continuation character 
C) Sub procedure 
D) Option Compare Text 
A) function 
B) line continuation character 
C) Sub procedure 
D) Option Compare Text

Question 5

Which of the following is NOT true in regard to working with ACCDB and ACCDE files?

Accepted Answer

A) Once a database is saved as an .accde file it cannot be converted back to the .accdb file format. 
B) Converting a database into the .accde is only one aspect of securing a database for use. 
C) Minimal changes can be made to macros or VBA modules within the .accde database. 
D) Any changes would have to be made in the original .accdb file that would then need to be converted to .accde again. 
A) Once a database is saved as an .accde file it cannot be converted back to the .accdb file format. 
B) Converting a database into the .accde is only one aspect of securing a database for use. 
C) Minimal changes can be made to macros or VBA modules within the .accde database. 
D) Any changes would have to be made in the original .accdb file that would then need to be converted to .accde again.

Question 6

An argument is a constant,variable,or class that is passed to an argument.

Accepted Answer

A) True 
 B)False

Question 7

User-defined types can also be created in VBA modules and assigned to a variable with the ________ statement.

Accepted Answer

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

Question 8

The ________ lists all VBA objects along with the associated methods and properties for each object.

Accepted Answer

The answer of The ________ lists all VBA objects along...

Question 9

Which of the following is NOT a type of loop in VBA?

Accepted Answer

A) Do Loop 
B) For...Next 
C) For First...Last 
D) Do While 
A) Do Loop 
B) For...Next 
C) For First...Last 
D) Do While

Question 10

Which of the following is NOT true when renaming command buttons?

Accepted Answer

A) When a new button is created on a form,Access assigns the button a name such as Command65. 
B) When creating a button in order to assign Visual Basic code,renaming the button can present problems when you assign a name that is too specific. 
C) When using the wizard to assign functions to a button,the wizard's naming convention may not be an obstacle because you will be able to change the caption on the button as part of the wizard. 
D) It is helpful to rename the button to describe the event that will take place. 
A) When a new button is created on a form,Access assigns the button a name such as Command65. 
B) When creating a button in order to assign Visual Basic code,renaming the button can present problems when you assign a name that is too specific. 
C) When using the wizard to assign functions to a button,the wizard's naming convention may not be an obstacle because you will be able to change the caption on the button as part of the wizard. 
D) It is helpful to rename the button to describe the event that will take place.

Question 11

Any VBA code in a database can be secured by providing a separate password via the ________.

Accepted Answer

The answer of Any VBA code in a database can...

Question 12

The ________ begins the process of declaring a variable.This is followed by the name the user wants to define as a variable.

Accepted Answer

The answer of The ________ begins the process of declaring...

Question 13

Entering the Trust Center and setting the ________ to Disable all macros with notification will display the Security Warning anytime you open a database that contains macros or Visual Basic.

Accepted Answer

The answer of Entering the Trust Center and setting the...

Question 14

The Project Explorer contains a list of the currently open Access databases that contain VBA procedures and a list of modules within the current database.

Accepted Answer

A) True 
 B)False

Question 15

Microsoft Office contains a powerful programming language called ________ or more commonly known as VBA.

Accepted Answer

Visual Bas

Question 16

Match between columns
                        Premises: Declarations
Option Compare
Object box
Option Compare Binary
Option Compare Text

Accepted Answer

The Answer of Examines the ASCII values and Located at is...

Question 17

The Visual Basic Editor provides commenting functionality and more on the Developer toolbar.

Accepted Answer

A) True 
 B)False

Question 18

Which of the following is NOT true in regard to working with ACCDE files?

Accepted Answer

A) Forms and reports can be opened but not edited in .accde versions of a database. 
B) In an .accde file,VBA procedures will not be viewable to the user. 
C) Any errors that might occur during the execution of a VBA procedure will not result in the Visual Basic Editor being displayed. 
D) The ACCDE format,with additional security measures,allows for full editing of the database by the user. 
A) Forms and reports can be opened but not edited in .accde versions of a database. 
B) In an .accde file,VBA procedures will not be viewable to the user. 
C) Any errors that might occur during the execution of a VBA procedure will not result in the Visual Basic Editor being displayed. 
D) The ACCDE format,with additional security measures,allows for full editing of the database by the user.

Question 19

Match between columns
                        Premises: Error handling
Exit statement
On Error statement
Debugging
Line labels

Accepted Answer

The Answer of Enable or disable an error-handling routine and is...

Question 20

When a database compiles,Access examines the procedures in all modules and objects of the database.An error in any module or object other than the one currently being edited is identified and brought to your attention.

Accepted Answer

A) True 
 B)False

________ statements in VBA work similarly to those found in Access and Excel though the syntax is slightly different.

________ are used to store VBA procedures that can be referenced or called by other procedures in the database.

A ________ can run on its own.

A(n)________ executes instructions and returns a value to another procedure.

Which of the following is NOT true in regard to working with ACCDB and ACCDE files?

An argument is a constant,variable,or class that is passed to an argument.

User-defined types can also be created in VBA modules and assigned to a variable with the ________ statement.

The ________ lists all VBA objects along with the associated methods and properties for each object.

Which of the following is NOT a type of loop in VBA?

Which of the following is NOT true when renaming command buttons?

Any VBA code in a database can be secured by providing a separate password via the ________.

The ________ begins the process of declaring a variable.This is followed by the name the user wants to define as a variable.

Entering the Trust Center and setting the ________ to Disable all macros with notification will display the Security Warning anytime you open a database that contains macros or Visual Basic.

The Project Explorer contains a list of the currently open Access databases that contain VBA procedures and a list of modules within the current database.

Microsoft Office contains a powerful programming language called ________ or more commonly known as VBA.

The Visual Basic Editor provides commenting functionality and more on the Developer toolbar.

Which of the following is NOT true in regard to working with ACCDE files?

When a database compiles,Access examines the procedures in all modules and objects of the database.An error in any module or object other than the one currently being edited is identified and brought to your attention.

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

________ statements in VBA work similarly to those found in Access and Excel though the syntax is slightly different.

________ are used to store VBA procedures that can be referenced or called by other procedures in the database.

A ________ can run on its own.

A(n)________ executes instructions and returns a value to another procedure.

Which of the following is NOT true in regard to working with ACCDB and ACCDE files?

An argument is a constant,variable,or class that is passed to an argument.

User-defined types can also be created in VBA modules and assigned to a variable with the ________ statement.

The ________ lists all VBA objects along with the associated methods and properties for each object.

Which of the following is NOT a type of loop in VBA?

Which of the following is NOT true when renaming command buttons?

Any VBA code in a database can be secured by providing a separate password via the ________.

The ________ begins the process of declaring a variable.This is followed by the name the user wants to define as a variable.

Entering the Trust Center and setting the ________ to Disable all macros with notification will display the Security Warning anytime you open a database that contains macros or Visual Basic.

The Project Explorer contains a list of the currently open Access databases that contain VBA procedures and a list of modules within the current database.

Microsoft Office contains a powerful programming language called ________ or more commonly known as VBA.

The Visual Basic Editor provides commenting functionality and more on the Developer toolbar.

Which of the following is NOT true in regard to working with ACCDE files?

When a database compiles,Access examines the procedures in all modules and objects of the database.An error in any module or object other than the one currently being edited is identified and brought to your attention.

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