Question 1

List four of the major benefits of using macros.

Accepted Answer

1.  Save time by automating routine task

Question 2

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

Accepted Answer

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

Question 3

You can assign a macro to a Ribbon or shortcut menu.

Accepted Answer

A) True 
 B)False

Question 4

Some arguments, such as the Title argument can be left empty.

Accepted Answer

A) True 
 B)False

Question 5

A(n) _____ macro allows you to embed macro capabilities directly in a table to add, change, or delete data based on conditions you specify.

Accepted Answer

The answer of A(n) _____ macro allows you to embed...

Question 6

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 7

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 8

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 9

You have been asked to troubleshoot a macro that doesn't work. Explain why single stepping a macro helps you solve the problem.

Accepted Answer

Single stepping a macro breaks

Question 10

Which of the following is NOT a common macro action?

Accepted Answer

A)  DeleteRecord 
B)  SaveRecord 
C)  OpenForm 
D)  CloseDesignView 
A)  DeleteRecord 
B)  SaveRecord 
C)  OpenForm 
D)  CloseDesignView

Question 11

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

Accepted Answer

The Answer of Action Catalog and Arguments and Comment and is...

Question 12

An action block can be expanded or collapsed to view or hide details in Macro Design View.

Accepted Answer

A) True 
 B)False

Question 13

It's common to put command buttons in the Form Footer so that users have a consistent location to find them.

Accepted Answer

A) True 
 B)False

Question 14

A(n) ____ is a collection of actions within a macro object that allows you to name and create multiple, separate macros within a single macro object.

Accepted Answer

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

Question 15

[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 16

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 17

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 18

A table macro allows you to embed macro capabilities directly in a table.

Accepted Answer

A) True 
 B)False

Question 19

To permanently trust a database, store the database in a trusted _____.

Accepted Answer

The answer of To permanently trust a database, store the...

Question 20

Name three ways that you can run a macro.

Accepted Answer

1.  By clicking the Run button in Macro

List four of the major benefits of using macros.

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

You can assign a macro to a Ribbon or shortcut menu.

Some arguments, such as the Title argument can be left empty.

A(n) _____ macro allows you to embed macro capabilities directly in a table to add, change, or delete data based on conditions you specify.

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

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

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

You have been asked to troubleshoot a macro that doesn't work. Explain why single stepping a macro helps you solve the problem.

Which of the following is NOT a common macro action?

An action block can be expanded or collapsed to view or hide details in Macro Design View.

It's common to put command buttons in the Form Footer so that users have a consistent location to find them.

A(n) ____ is a collection of actions within a macro object that allows you to name and create multiple, separate macros within a single macro object.

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

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

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

A table macro allows you to embed macro capabilities directly in a table.

To permanently trust a database, store the database in a trusted _____.

Name three ways that you can run a 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

List four of the major benefits of using macros.

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

You can assign a macro to a Ribbon or shortcut menu.

Some arguments, such as the Title argument can be left empty.

A(n) _____ macro allows you to embed macro capabilities directly in a table to add, change, or delete data based on conditions you specify.

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

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

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

You have been asked to troubleshoot a macro that doesn't work. Explain why single stepping a macro helps you solve the problem.

Which of the following is NOT a common macro action?

An action block can be expanded or collapsed to view or hide details in Macro Design View.

It's common to put command buttons in the Form Footer so that users have a consistent location to find them.

A(n) ____ is a collection of actions within a macro object that allows you to name and create multiple, separate macros within a single macro object.

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

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

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

A table macro allows you to embed macro capabilities directly in a table.

To permanently trust a database, store the database in a trusted _____.

Name three ways that you can run a 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