Question 1

____ is a major benefit of using macros.

Accepted Answer

A)  Saving paper 
B)  Improving accuracy 
C)  Eliminating forms and reports 
D)  Redesigning the database 
A)  Saving paper 
B)  Improving accuracy 
C)  Eliminating forms and reports 
D)  Redesigning the database

Question 2

By default, an Access database is trusted.

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

The answer of A macro may contain one or more...

Question 4

A(n) _____ is a specific activity that occurs within the database, such as clicking a command button, moving from record to record, editing data, or opening and closing a form.

Accepted Answer

The answer of A(n) _____ is a specific activity that...

Question 5

The event property that is most commonly used with a command button is the _____ property.

Accepted Answer

A)  Push 
B)  Hover 
C)  Select 
D)  On Click 
A)  Push 
B)  Hover 
C)  Select 
D)  On Click

Question 6

You are a busy information technology (IT) specialist at a well-known accounting firm. You work with departments throughout the company to help them solve problems and simplify computer tasks. 
One of your coworkers asks you to explain the difference between Excel and Access with regard to creating macros and VBA.  What do you tell him?

Accepted Answer

When you create a macro in Exc

Question 7

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

Accepted Answer

The answer of You can assign a key combination to...

Question 8

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

Accepted Answer

A)  Printing several reports 
B)  Modifying the design of a form 
C)  Building ad hoc reports 
D)  Creating graphs 
A)  Printing several reports 
B)  Modifying the design of a form 
C)  Building ad hoc reports 
D)  Creating graphs

Question 9

You have inherited a database with several macros.  Explain why attaching macros to command buttons is a superior way to run a macro as compared to running it from the Database Tools tab on the Ribbon.

Accepted Answer

Running a macro by clicking a command bu

Question 10

You most often run a data macro based on a table event .

Accepted Answer

A) True 
 B)False

Question 11

The _____ Catalog lists all available macro actions organized by category.

Accepted Answer

The answer of The _____ Catalog lists all available macro...

Question 12

Defragging means determining why a macro doesn't run correctly.

Accepted Answer

A) True 
 B)False

Question 13

All Access events are triggered by the user.

Accepted Answer

A) True 
 B)False

Question 14

The click of a command button or making an entry in a field would be considered a(n) ____.

Accepted Answer

A)  Macro 
B)  Action 
C)  Condition 
D)  Event 
A)  Macro 
B)  Action 
C)  Condition 
D)  Event

Question 15

A common three-character prefix for command buttons is _____.

Accepted Answer

A)  com 
B)  mmm 
C)  cmd 
D)  btt 
A)  com 
B)  mmm 
C)  cmd 
D)  btt

Question 16

The _____ button executes the selected Access macro.

Accepted Answer

The answer of The _____ button executes the selected Access...

Question 17

In a macro, to refer to a value of a control on a form in a conditional expression, use the following syntax: ____.

Accepted Answer

A)  {Forms}!{formname}!{controlname} 
B)  [Forms]![formname]![controlname] 
C)  Forms.(formname).(controlname) 
D)  Forms.formname(controlname) 
A)  {Forms}!{formname}!{controlname} 
B)  [Forms]![formname]![controlname] 
C)  Forms.(formname).(controlname) 
D)  Forms.formname(controlname)

Question 18

You cannot override existing Access key combinations such as [Ctrl][C] for copy with an Access AutoKey assignment.

Accepted Answer

A) True 
 B)False

Question 19

Which of the following is NOT a valid table event for a data macro?

Accepted Answer

A)  After Got Focus 
B)  After Insert 
C)  After Update 
D)  Before Delete 
A)  After Got Focus 
B)  After Insert 
C)  After Update 
D)  Before Delete

Question 20

You are a busy information technology (IT) specialist at a well-known accounting firm. You work with departments throughout the company to help them solve problems and simplify computer tasks. 
You are asked to automate some routine tasks for the Accounts Payable department.  These are: 
a. Finding the first record that meets certain criteria 
b. Maximizing an active window to fill the Access window 
c. Closing a window 
What are the names of the 3 macro actions you would use in a macro to complete these tasks?

Accepted Answer

a. FindRec

____ is a major benefit of using macros.

By default, an Access database is trusted.

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

A(n) _____ is a specific activity that occurs within the database, such as clicking a command button, moving from record to record, editing data, or opening and closing a form.

The event property that is most commonly used with a command button is the _____ property.

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

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

You have inherited a database with several macros. Explain why attaching macros to command buttons is a superior way to run a macro as compared to running it from the Database Tools tab on the Ribbon.

You most often run a data macro based on a table event .

The _____ Catalog lists all available macro actions organized by category.

Defragging means determining why a macro doesn't run correctly.

All Access events are triggered by the user.

The click of a command button or making an entry in a field would be considered a(n) ____.

A common three-character prefix for command buttons is _____.

The _____ button executes the selected Access macro.

In a macro, to refer to a value of a control on a form in a conditional expression, use the following syntax: ____.

You cannot override existing Access key combinations such as [Ctrl][C] for copy with an Access AutoKey assignment.

Which of the following is NOT a valid table event for a data macro?

Getting Started With Access

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Improving Queries

Enhancing Forms

Analyizng Data With Reports

Importing and Exporting Data

Creating Advanced Queries

Creating Advanced Reports

Creating Modules and Vba

Administering the Database

Using Acess and the Web

Completing a Database Application

Filters

Exam 12: Creating Macros

____ is a major benefit of using macros.

By default, an Access database is trusted.

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

A(n) _____ is a specific activity that occurs within the database, such as clicking a command button, moving from record to record, editing data, or opening and closing a form.

The event property that is most commonly used with a command button is the _____ property.

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

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

You have inherited a database with several macros. Explain why attaching macros to command buttons is a superior way to run a macro as compared to running it from the Database Tools tab on the Ribbon.

You most often run a data macro based on a table event .

The _____ Catalog lists all available macro actions organized by category.

Defragging means determining why a macro doesn't run correctly.

All Access events are triggered by the user.

The click of a command button or making an entry in a field would be considered a(n) ____.

A common three-character prefix for command buttons is _____.

The _____ button executes the selected Access macro.

In a macro, to refer to a value of a control on a form in a conditional expression, use the following syntax: ____.

You cannot override existing Access key combinations such as [Ctrl][C] for copy with an Access AutoKey assignment.

Which of the following is NOT a valid table event for a data macro?

Getting Started With Access

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Improving Queries

Enhancing Forms

Analyizng Data With Reports

Importing and Exporting Data

Creating Advanced Queries

Creating Advanced Reports

Creating Modules and Vba

Administering the Database

Using Acess and the Web

Completing a Database Application

Filters