Question 1

You can slow step a macro, which means to run it one action at a time to observe the effect of each specific action.

Accepted Answer

A) True 
 B)False

Question 2

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 3

[Forms]![CustomerEntry]![CustPhone] is an example of _____ notation.

Accepted Answer

A)  exclamation 
B)  conditional 
C)  macro 
D)  bang 
A)  exclamation 
B)  conditional 
C)  macro 
D)  bang

Question 4

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 5

In the Macro Single Step dialog box in the figure, which button would you click to run the next macro action?

Accepted Answer

A)  Step 
B)  Halt 
C)  Next 
D)  Run 
A)  Step 
B)  Halt 
C)  Next 
D)  Run

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. 
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

Question 7

A(n) ____ is something that happens to a form, window, toolbar, or control that can be used to initiate the execution of a macro.

Accepted Answer

A)  Action 
B)  Event 
C)  Argument 
D)  Submacro 
A)  Action 
B)  Event 
C)  Argument 
D)  Submacro

Question 8

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 9

A(n) _____ is a database object that stores and executes a series of Access actions.

Accepted Answer

The answer of A(n) _____ is a database object that...

Question 10

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 11

A(n) ____ expression results in a true or false answer.

Accepted Answer

A)  Action 
B)  Conditional 
C)  Group 
D)  Mathematical 
A)  Action 
B)  Conditional 
C)  Group 
D)  Mathematical

Question 12

OpenReport is an Access macro ____.

Accepted Answer

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

Question 13

If statements in Access 2013 may contain Else If and Else clauses.

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

Arguments provide ____.

Accepted Answer

A)  Conditional expressions that evaluate to true or false 
B)  Additional information on how to carry out an action 
C)  A way to store many macros together in a group 
D)  A list of events that are associated with each control on a form 
A)  Conditional expressions that evaluate to true or false 
B)  Additional information on how to carry out an action 
C)  A way to store many macros together in a group 
D)  A list of events that are associated with each control on a form

Question 16

A(n) _____ database allows you to run macros and VBA.

Accepted Answer

The answer of A(n) _____ database allows you to run...

Question 17

Explain the difference between a data macro and a traditional macro object in terms of how the macro is created, stored, and triggered.

Accepted Answer

A data macro is managed directly from wi

Question 18

The best way to make a macro obviously available for many different forms would be to ____.

Accepted Answer

A)  Click the Run button from the DATABASE TOOLS tab 
B)  Run the macro from Macro Design View 
C)  Assign the macro to a command button on the first form the user opens 
D)  Assign the macro to the Ribbon 
A)  Click the Run button from the DATABASE TOOLS tab 
B)  Run the macro from Macro Design View 
C)  Assign the macro to a command button on the first form the user opens 
D)  Assign the macro to the Ribbon

Question 19

Match between columns
                        Premises: Lists required and optional arguments for the selected action
Lists all of the macro actions organized by category
Contains conditional expressions that are evaluated either true or false
Allows you to document the macro with explanatory text
Executes the selected macro

Accepted Answer

The Answer of Comment and Action Catalog and Run button is...

Question 20

In the figure above, which argument does NOT require a value?

Accepted Answer

A)  Report Name 
B)  View 
C)  Filter Name 
D)  Window Mode 
A)  Report Name 
B)  View 
C)  Filter Name 
D)  Window Mode

You can slow step a macro, which means to run it one action at a time to observe the effect of each specific action.

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

[Forms]![CustomerEntry]![CustPhone] is an example of _____ notation.

In the Macro Single Step dialog box in the figure, which button would you click to run the next macro action?

A(n) ____ is something that happens to a form, window, toolbar, or control that can be used to initiate the execution of 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.

A(n) _____ is a database object that stores and executes a series of Access actions.

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

A(n) ____ expression results in a true or false answer.

OpenReport is an Access macro ____.

If statements in Access 2013 may contain Else If and Else clauses.

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

Arguments provide ____.

A(n) _____ database allows you to run macros and VBA.

Explain the difference between a data macro and a traditional macro object in terms of how the macro is created, stored, and triggered.

The best way to make a macro obviously available for many different forms would be to ____.

In the figure above, which argument does NOT require a value?

Getting Started With 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 Macros

Administering the Database

Access and the Web

Getting Started With Microsoft Office 2013

Filters

Exam 13: Creating Macros

You can slow step a macro, which means to run it one action at a time to observe the effect of each specific action.

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

[Forms]![CustomerEntry]![CustPhone] is an example of _____ notation.

In the Macro Single Step dialog box in the figure, which button would you click to run the next macro action?

A(n) ____ is something that happens to a form, window, toolbar, or control that can be used to initiate the execution of 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.

A(n) _____ is a database object that stores and executes a series of Access actions.

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

A(n) ____ expression results in a true or false answer.

OpenReport is an Access macro ____.

If statements in Access 2013 may contain Else If and Else clauses.

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

Arguments provide ____.

A(n) _____ database allows you to run macros and VBA.

Explain the difference between a data macro and a traditional macro object in terms of how the macro is created, stored, and triggered.

The best way to make a macro obviously available for many different forms would be to ____.

In the figure above, which argument does NOT require a value?

Getting Started With 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 Macros

Administering the Database

Access and the Web

Getting Started With Microsoft Office 2013

Filters