Question 1

The Each...Next statement will run another Sub procedure or function from within a procedure by transferring to the called routine.

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

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 end the procedure opens the Visual Basic Editor with the incorrect line of code highlighted in yellow.

Accepted Answer

A) True 
 B)False

Question 4

Match between columns
                        Premises: Property names
Sub procedure
Argument
Dim statement
Object Browser

Accepted Answer

The Answer of Can run on its own and Begins is...

Question 5

Declarations define user-defined data types,variables,arrays,and constants.

Accepted Answer

A) True 
 B)False

Question 6

Which of the following is NOT true regarding the FileDialog object properties?

Accepted Answer

A) The Open option allows the user to select one or more files that can be opened in the Object Browser. 
B) The FolderPicker option allows the user to select a path (folder).The file path text is stored in the SelectedItems method of the FileDialog object. 
C) The FilePicker option allows the user to select one or more files.The file paths are stored in the SelectedItems method of the FileDialog object. 
D) The SaveAs option allows the user to select a single file that can then be used to save the current file. 
A) The Open option allows the user to select one or more files that can be opened in the Object Browser. 
B) The FolderPicker option allows the user to select a path (folder).The file path text is stored in the SelectedItems method of the FileDialog object. 
C) The FilePicker option allows the user to select one or more files.The file paths are stored in the SelectedItems method of the FileDialog object. 
D) The SaveAs option allows the user to select a single file that can then be used to save the current file.

Question 7

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

Accepted Answer

The answer of A ________ executes instructions and returns a...

Question 8

The ________ allows Access to import,export,or link to spreadsheet files specifically.

Accepted Answer

A) FileDialog object 
B) RunCmd object 
C) TransferSpreadsheet method 
D) DoCmd object 
A) FileDialog object 
B) RunCmd object 
C) TransferSpreadsheet method 
D) DoCmd object

Question 9

The default file format in Access 2013 is the .accdb extension.

Accepted Answer

A) True 
 B)False

Question 10

The larger window on the right of the Visual Basic Editor is the ________.

Accepted Answer

The answer of The larger window on the right of...

Question 11

Syntax errors occur within the Visual Basic Editor once the pointer leaves a line of code that the Code window cannot interpret.

Accepted Answer

A) True 
 B)False

Question 12

Which of the following is NOT true regarding object-oriented programming?

Accepted Answer

A) VBA is a form of object-oriented programming. 
B) Objects are combinations of data and code that are treated as a multi-level unit. 
C) Object-oriented programming uses objects,such as a form in Access,to design applications. 
D) The application can respond to events that occur in relation to the object. 
A) VBA is a form of object-oriented programming. 
B) Objects are combinations of data and code that are treated as a multi-level unit. 
C) Object-oriented programming uses objects,such as a form in Access,to design applications. 
D) The application can respond to events that occur in relation to the object.

Question 13

The ________ statement allows for an efficient way of using several methods or setting multiple properties on a single object.

Accepted Answer

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

Question 14

Which of the following is NOT true regarding loops in VBA?

Accepted Answer

A) Loops allow the statements contained within the loop to be executed multiple times depending on the constraints of the loop. 
B) The type of repetitive action is often one of the main reasons macros or VBA are used to automate a process in Access. 
C) Loops are similar to If statements in that they evaluate a condition and act depending on the status of the condition. 
D) Loops are used to execute a series of statements with more than one argument. 
A) Loops allow the statements contained within the loop to be executed multiple times depending on the constraints of the loop. 
B) The type of repetitive action is often one of the main reasons macros or VBA are used to automate a process in Access. 
C) Loops are similar to If statements in that they evaluate a condition and act depending on the status of the condition. 
D) Loops are used to execute a series of statements with more than one argument.

Question 15

When a module or object is opened,before any code is displayed,the Visual Basic Editor will prompt you for the VBA ________.

Accepted Answer

The answer of When a module or object is opened,before...

Question 16

Which of the following is NOT true regarding word wrapping in the code window?

Accepted Answer

A) Because the Code window does not word wrap like Microsoft Word or other word-processing programs,lengthy strings of code will be truncated on the right. 
B) VBA procedures lack word wrapping in the Code window. 
C) To break a line of code across two lines,a line continuation character can be used. 
D) The lack of word wrapping creates code that is extremely difficult to read. 
A) Because the Code window does not word wrap like Microsoft Word or other word-processing programs,lengthy strings of code will be truncated on the right. 
B) VBA procedures lack word wrapping in the Code window. 
C) To break a line of code across two lines,a line continuation character can be used. 
D) The lack of word wrapping creates code that is extremely difficult to read.

Question 17

The default file format in Access 2013 is the ________ extension.

Accepted Answer

The answer of The default file format in Access 2013...

Question 18

In VBA,a(n)________ can display customized text and buttons in addition to the standard OK,Cancel,and Yes/No buttons familiar in Microsoft applications.

Accepted Answer

A) message box 
B) warning box 
C) alert window 
D) notification window 
A) message box 
B) warning box 
C) alert window 
D) notification window

Question 19

________ is the process of anticipating and controlling for errors.

Accepted Answer

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

Question 20

The Edit toolbar has many useful features built into it such as buttons for increasing and decreasing indentations and listing the properties and methods of a statement in the Code window.

Accepted Answer

A) True 
 B)False

The Each...Next statement will run another Sub procedure or function from within a procedure by transferring to the called routine.

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

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 end the procedure opens the Visual Basic Editor with the incorrect line of code highlighted in yellow.

Declarations define user-defined data types,variables,arrays,and constants.

Which of the following is NOT true regarding the FileDialog object properties?

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

The ________ allows Access to import,export,or link to spreadsheet files specifically.

The default file format in Access 2013 is the .accdb extension.

The larger window on the right of the Visual Basic Editor is the ________.

Syntax errors occur within the Visual Basic Editor once the pointer leaves a line of code that the Code window cannot interpret.

Which of the following is NOT true regarding object-oriented programming?

The ________ statement allows for an efficient way of using several methods or setting multiple properties on a single object.

Which of the following is NOT true regarding loops in VBA?

When a module or object is opened,before any code is displayed,the Visual Basic Editor will prompt you for the VBA ________.

Which of the following is NOT true regarding word wrapping in the code window?

The default file format in Access 2013 is the ________ extension.

In VBA,a(n)________ can display customized text and buttons in addition to the standard OK,Cancel,and Yes/No buttons familiar in Microsoft applications.

________ is the process of anticipating and controlling for errors.

The Edit toolbar has many useful features built into it such as buttons for increasing and decreasing indentations and listing the properties and methods of a statement in the Code window.

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 Each...Next statement will run another Sub procedure or function from within a procedure by transferring to the called routine.

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

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 end the procedure opens the Visual Basic Editor with the incorrect line of code highlighted in yellow.

Declarations define user-defined data types,variables,arrays,and constants.

Which of the following is NOT true regarding the FileDialog object properties?

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

The ________ allows Access to import,export,or link to spreadsheet files specifically.

The default file format in Access 2013 is the .accdb extension.

The larger window on the right of the Visual Basic Editor is the ________.

Syntax errors occur within the Visual Basic Editor once the pointer leaves a line of code that the Code window cannot interpret.

Which of the following is NOT true regarding object-oriented programming?

The ________ statement allows for an efficient way of using several methods or setting multiple properties on a single object.

Which of the following is NOT true regarding loops in VBA?

When a module or object is opened,before any code is displayed,the Visual Basic Editor will prompt you for the VBA ________.

Which of the following is NOT true regarding word wrapping in the code window?

The default file format in Access 2013 is the ________ extension.

In VBA,a(n)________ can display customized text and buttons in addition to the standard OK,Cancel,and Yes/No buttons familiar in Microsoft applications.

________ is the process of anticipating and controlling for errors.

The Edit toolbar has many useful features built into it such as buttons for increasing and decreasing indentations and listing the properties and methods of a statement in the Code window.

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