Deck 13: Workshop 13: Use VBA in Access

Question 1

A ________ can run on its own.

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

Answer 1

C

Question 2

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

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

Answer 2

B

Question 3

VBA uses a(n)________ feature similar to that found in other Microsoft Office applications such as writing field names in query criteria.

A)Arguments
B)Debugging
C)Code
D)AutoComplete

Answer 3

D

Question 4

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

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

Question 5

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

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

Question 6

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

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

Question 7

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

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

Question 8

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

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

Question 9

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

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

Question 10

Which of the following is NOT true regarding VBA?

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 11

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

A)Object Command
B)Object Window
C)Object Browser
D)Object Editor

Question 12

________ can contain multiple procedures.

A)Declarations
B)Modules
C)Functions
D)Methods

Question 13

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

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 14

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

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

Question 15

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

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 16

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

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 17

The ________ setting results in case-insensitive comparisons.

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

Question 18

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

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

Question 19

The code that is written in VBA is called a(n)________ in VBA.

A)object-oriented program
B)javascript
C)procedure
D)event

Question 20

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

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 21

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

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

Question 22

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

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

Question 23

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

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

Question 24

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.

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

Question 25

Adding ________ to code in VBA is an excellent way of communicating the intentions of a procedure to other database administrators,and it is a good way of keeping track of your own code.

A)procedures
B)Modules
C)Declarations
D)comments

Question 26

Which of the following is NOT true in regard to compiling?

A)When you compile the VBA in your database,Access examines all of the VBA contained in modules or objects for errors.
B)Compiling your code before running it is one way of finding errors before the execution of a VBA procedure.
C)Access compiles an individual procedure after the procedure is executed.
D)When you compile the VBA in your database,you can find the errors in a procedure before users stumble across them.

Question 27

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

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 28

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

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

Question 29

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 ________.

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

Question 30

________ 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.

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

Question 31

Which of the following is NOT true regarding comments in the Code window?

A)Comments can take an entire line of the Code window or begin after another statement in the Code window.
B)The Visual Basic Editor changes the font color of any commented text to blue.
C)Commenting only works on a line-by-line basis.
D)The apostrophe character tells the Visual Basic Editor to ignore any text following the apostrophe on a line of the Code window.

Question 32

________ is the process of anticipating and controlling for errors.

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

Question 33

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

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 34

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

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 35

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

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 36

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

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

Question 37

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

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 38

A(n)________ error occurs when a completed line of code is entered that the Visual Basic Editor does not recognize.

A)syntax
B)compiling
C)unidentified
D)execution

Question 39

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

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

Question 40

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

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

Question 41

DoCmd allows for Access to import,export,or link to spreadsheet files specifically and has six arguments.

Question 42

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

Question 43

Anything that can be done with a macro can be accomplished in VBA.

Question 44

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

Question 45

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

Question 46

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

Question 47

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

Question 48

VBA in an Access database can be contained either in a specific Access object,such as a form or a button,or within a macro.

Question 49

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

Question 50

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.

Question 51

VBA uses an AutoComplete feature similar to that found in other Microsoft Office applications such as writing field names in query criteria.

Question 52

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

Question 53

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

Question 54

Which of the following is NOT true in regard to password protecting 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 55

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.

Question 56

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.

Question 57

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

Question 58

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

Question 59

Debugging is the process of anticipating and controlling errors.

Question 60

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

Question 61

________ uses an event to trigger the execution of code.

Question 62

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

Question 63

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.

Question 64

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

Question 65

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

Question 66

Using the Visual Basic Editor to compile your database forces Access to compile all existing modules.

Question 67

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

Question 68

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.

Question 69

The Visual Basic Editor provides a method of securing the VBA in a database without implementing more general security measures.

Question 70

Line labels can be used like bookmarks in a procedure.

Question 71

Converting a macro to VBA opens the ________ automatically.

Question 72

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

Question 73

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

Question 74

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

Question 75

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

Question 76

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

Question 77

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.

Question 78

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

Question 79

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

Question 80

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