Exam 13: Workshop 13: Use VBA in Access

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

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

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.

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

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

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

________ can contain multiple procedures.

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

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

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

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

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

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

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

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.

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

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

________ can be used like bookmarks in a procedure.

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

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