Access Module 10: Creating Macros

QUESTION 1

How can you create a backup of a macro?

	a.	Use the Backup command in Action Catalog.
	b.	Use the Backup command in Backstage View.
	c.	Convert it to a report in the Navigation Pane.
	d.	Copy and paste a macro in the Navigation Pane.

QUESTION 2

The _____ organizes all the arguments for an action in a rectangle with a gray background.

	a.	Macro Single Step dialog box
	b.	update block
	c.	action block
	d.	event procedure

QUESTION 3

When does the After Update table event run?

	a.	After you change an existing record
	b.	After you insert a new record in the table
	c.	After you run an Update query
	d.	After you change the table design

QUESTION 4

The part of an If statement that is evaluated as either true or false is called a(n) _____.

	a.	procedure
	b.	conditional expression
	c.	Else clause
	d.	event

QUESTION 5

Which of the following events would trigger a data macro?

	a.	SetProperty
	b.	OpenReport
	c.	After Insert
	d.	On Got Focus

QUESTION 6

A(n) _____ allows you to run macro actions based on the result of a conditional expression.

	a.	If statement
	b.	Group program flow
	c.	Run statement
	d.	query

QUESTION 7

Which of the following tasks is a good candidate for a macro?

	a.	Modifying the design of a form
	b.	Adding a chart to a tab control
	c.	Creating a report
	d.	Printing several reports

QUESTION 8

You can assign a key combination to a macro by creating a macro with the name _____.

	a.	AutoKeys
	b.	CTRL+K
	c.	KeyCombo
	d.	Macro1

QUESTION 9

When you single step a macro, you _____.

	a.	add an action with only one argument
	b.	create the macro with one action
	c.	record the macro as you perform steps
	d.	run the macro one action at a time

QUESTION 10

You click the _____ button to execute the selected Access macro.

	a.	Trigger
	b.	Single Step
	c.	Run
	d.	Expand All

QUESTION 11

A macro may contain one or more _____, the tasks that you want Access to perform.

	a.	actions
	b.	events
	c.	queries
	d.	conditions

QUESTION 12

In a macro, arguments provide _____.

	a.	a way to store many macros together in a group
	b.	additional information on how to carry out an action
	c.	additional information on how to carry out an action
	d.	conditional expressions that evaluate to true or false

QUESTION 13

_____ are properties of an action that provide additional information on how the action should execute.

	a.	Events
	b.	Conditions
	c.	Comments
	d.	Arguments

QUESTION 14

Which Action Catalog category contains the Comment, Group, If, and Submacro components?

	a.	Actions
	b.	Program Flow
	c.	Conditional Statements
	d.	Messages

QUESTION 15

One way to _____ a macro is to single step through the macro.

	a.	program
	b.	rename
	c.	debug
	d.	modify