Question 1

A secure database allows you to run macros and VBA.

Accepted Answer

A) True 
 B)False

Question 2

Arguments change depending upon the action chosen.

Accepted Answer

A) True 
 B)False

Question 3

By default, an Access database is trusted.

Accepted Answer

A) True 
 B)False

Question 4

After choosing the macro action you want, you then decide which arguments you want to apply to the action and whether each argument should be required or optional.

Accepted Answer

A) True 
 B)False

Question 5

____ 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 6

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 7

Each macro task has a specified set of ____ that provide additional information on how to carry out the task.

Accepted Answer

A)  Actions 
B)  Arguments 
C)  Events 
D)  None of the above 
A)  Actions 
B)  Arguments 
C)  Events 
D)  None of the above

Question 8

You can assign a command button to a macro using the Command Button Wizard.

Accepted Answer

A) True 
 B)False

Question 9

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 10

The On _____ event occurs when focus moves from one record to another.

Accepted Answer

The answer of The On _____ event occurs when focus...

Question 11

Name three ways that you can run a macro.

Accepted Answer

1. By clicking the Run button in Macro D

Question 12

Which of the following is NOT a benefit of using macros?

Accepted Answer

A)  Decreases the number of objects required in the database 
B)  Increases efficiency by automating routine tasks 
C)  Increases accuracy by flagging data entry errors 
D)  Improves flexibility by connecting forms and reports together through command buttons 
A)  Decreases the number of objects required in the database 
B)  Increases efficiency by automating routine tasks 
C)  Increases accuracy by flagging data entry errors 
D)  Improves flexibility by connecting forms and reports together through command buttons

Question 13

Which argument of the MessageBox macro action determines the icon in the dialog box that is created?

Accepted Answer

A)  Message 
B)  View 
C)  Type 
D)  Title 
A)  Message 
B)  View 
C)  Type 
D)  Title

Question 14

Data macros appear in the Macros group in the Navigation Pane.

Accepted Answer

A) True 
 B)False

Question 15

Which argument of the MessageBox macro action determines the text in the Title Bar of the dialog box that is created?

Accepted Answer

A)  Message 
B)  View 
C)  Type 
D)  Title 
A)  Message 
B)  View 
C)  Type 
D)  Title

Question 16

Match the Macro Design View component with its description.
-Allows you to document the macro with explanatory text

Accepted Answer

A) Action Catalog 
B) If statement 
C) Arguments 
D) Comment 
E) Run button 
A) Action Catalog 
B) If statement 
C) Arguments 
D) Comment 
E) Run button

Question 17

In Access macros, conditional expressions are used in If statements.

Accepted Answer

A) True 
 B)False

Question 18

A conditional expression determines whether a macro action will execute or not.

Accepted Answer

A) True 
 B)False

Question 19

Conditional expressions result in a numeric value. _____

Accepted Answer

A) True 
 B)False

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

A secure database allows you to run macros and VBA.

Arguments change depending upon the action chosen.

By default, an Access database is trusted.

After choosing the macro action you want, you then decide which arguments you want to apply to the action and whether each argument should be required or optional.

____ is a major benefit of using macros.

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

Each macro task has a specified set of ____ that provide additional information on how to carry out the task.

You can assign a command button to a macro using the Command Button Wizard.

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

The On _____ event occurs when focus moves from one record to another.

Name three ways that you can run a macro.

Which of the following is NOT a benefit of using macros?

Which argument of the MessageBox macro action determines the icon in the dialog box that is created?

Data macros appear in the Macros group in the Navigation Pane.

Which argument of the MessageBox macro action determines the text in the Title Bar of the dialog box that is created?

Match the Macro Design View component with its description. -Allows you to document the macro with explanatory text

In Access macros, conditional expressions are used in If statements.

A conditional expression determines whether a macro action will execute or not.

Conditional expressions result in a numeric value. _____

Getting Started With Microsoft Office 2013

Getting Started With Chapter Access 2013

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Improving Queries

Enhancing Forms

Analyzing Data With Reports

Importing and Exporting Data

Analyzing Database Design Using Northwind

Creating Advanced Queries

Creating Advanced Reports

Creating Modules and Vba

Administering the Database

Chapter Access and the Web

Filters

Exam 14: Creating Macros

A secure database allows you to run macros and VBA.

Arguments change depending upon the action chosen.

By default, an Access database is trusted.

After choosing the macro action you want, you then decide which arguments you want to apply to the action and whether each argument should be required or optional.

____ is a major benefit of using macros.

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

Each macro task has a specified set of ____ that provide additional information on how to carry out the task.

You can assign a command button to a macro using the Command Button Wizard.

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

The On _____ event occurs when focus moves from one record to another.

Name three ways that you can run a macro.

Which of the following is NOT a benefit of using macros?

Which argument of the MessageBox macro action determines the icon in the dialog box that is created?

Data macros appear in the Macros group in the Navigation Pane.

Which argument of the MessageBox macro action determines the text in the Title Bar of the dialog box that is created?

Match the Macro Design View component with its description. -Allows you to document the macro with explanatory text

In Access macros, conditional expressions are used in If statements.

A conditional expression determines whether a macro action will execute or not.

Conditional expressions result in a numeric value. _____

Getting Started With Microsoft Office 2013

Getting Started With Chapter Access 2013

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Improving Queries

Enhancing Forms

Analyzing Data With Reports

Importing and Exporting Data

Analyzing Database Design Using Northwind

Creating Advanced Queries

Creating Advanced Reports

Creating Modules and Vba

Administering the Database

Chapter Access and the Web

Filters