Access

QUESTION 1

Which VBA keyword(s) do you use to declare the name and arguments that create a new function procedure?

	a.	Start Function
	b.	Option Function
	c.	Function
	d.	Declare Function

QUESTION 2

When does the Visual Basic Editor display text in red?

	a.	When a syntax error is preventing the code from running
	b.	When the text begins with an apostrophe, indicating a comment
	c.	When the text is a VBA keyword
	d.	When a new IfThenElse block of code begins

QUESTION 3

Which of the following is a comment you could add to a VBA procedure?

	a.	"The Discount function has two arguments.
	b.	//The Discount function has two arguments.
	c.	'The Discount function has two arguments.
	d.	COM The Discount function has two arguments.

QUESTION 4

The programming language used in Access modules is called Visual Basic for _____.

	a.	Applications
	b.	Modules
	c.	Macros
	d.	Access

QUESTION 5

If you create a function in a standard module, it applies only to the current object.

True

False

QUESTION 6

Why would you create a function in a standard module?

	a.	To embed the function in the open form
	b.	To avoid having to use VBA syntax
	c.	To use the function in any query, form, or report in the database
	d.	To prepare for converting the function to a macro

QUESTION 7

Which of the following VBA keywords is a declaration statement that determines the way string values (text) will be sorted?

	a.	Option Compare Database
	b.	Select Case
	c.	On Text GoTo
	d.	Option Sort Text

QUESTION 8

You can create a comment by starting the statement with _____.

	a.	rem
	b.	dim
	c.	ignore
	d.	com

QUESTION 9

Caitlin wants to assign the Before Update property of a form to a procedure. She clicks the Build button in the Before Update property and then clicks Expression Builder.

True

False

QUESTION 10

What must you use to create a custom function in Access?

	a.	An Access module
	b.	The Custom Function Wizard
	c.	A data macro
	d.	An Access macro

QUESTION 11

You must use the correct _____, or rules, when creating a VBA statement.

	a.	syntax
	b.	rubrics
	c.	executors
	d.	procedures