Exam 13: Creating Macros
Exam 1: Getting Started With Access 201368 Questions
Exam 2: Building and Using Queries66 Questions
Exam 3: Using Forms68 Questions
Exam 4: Using Reports68 Questions
Exam 5: Modifying the Database Structure79 Questions
Exam 6: Improving Queries80 Questions
Exam 7: Enhancing Forms81 Questions
Exam 8: Analyzing Data With Reports81 Questions
Exam 9: Importing and Exporting Data81 Questions
Exam 10: Analyzing Database Design Using Northwind77 Questions
Exam 11: Creating Advanced Queries81 Questions
Exam 12: Creating Advanced Reports81 Questions
Exam 13: Creating Macros88 Questions
Exam 14: Creating Macros74 Questions
Exam 15: Administering the Database89 Questions
Exam 16: Access and the Web78 Questions
Exam 17: Getting Started With Microsoft Office 201366 Questions
Select questions type
In the figure above, what is the name of the macro that is being single stepped?

Free
(Multiple Choice)
4.8/5
(33)
Correct Answer:
A
As shown in the figure, Message, Beep, Type, and Title are arguments for the MessageBox macro action.

Free
(True/False)
4.8/5
(38)
Correct Answer:
True
In the figure above, how many macro actions are shown?

Free
(Multiple Choice)
4.8/5
(34)
Correct Answer:
B
To permanently trust a database, store the database in a trusted _____.
(Short Answer)
4.9/5
(32)
You can assign a key combination to a macro by creating a macro with the name _____.
(Short Answer)
4.8/5
(34)
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.
The Payroll department needs you to improve its database's ease of use by adding some kind of audible warning sound and an automatic message to tell the user when a data entry mistake has been made. What are the names of the two macro actions you would use in a macro to achieve this?
(Essay)
4.7/5
(41)
ApplyFilter, RunCommand, Close, and OpenReport are examples of macro ____.
(Multiple Choice)
4.7/5
(45)
It's common to put command buttons in the Form Footer so that users have a consistent location to find them.
(True/False)
4.9/5
(31)
Macro actions are evaluated based on their order in the Macro Design View window, starting at the bottom.
(True/False)
4.9/5
(37)
You cannot override existing Access key combinations such as [Ctrl][C] for copy with an Access AutoKey assignment.
(True/False)
4.9/5
(39)
The _____ Catalog lists all available macro actions organized by category.
(Short Answer)
4.7/5
(36)
Which argument of the OpenReport macro action determines the report that is opened?
(Multiple Choice)
4.8/5
(41)
You have been asked to troubleshoot a macro that doesn't work. Explain why single stepping a macro as shown in the figure helps you solve the problem.

(Essay)
4.7/5
(35)
A macro may contain one or more _____, the tasks that you want Access to perform.
(Short Answer)
4.8/5
(33)
Showing 1 - 20 of 88
Filters
- Essay(0)
- Multiple Choice(0)
- Short Answer(0)
- True False(0)
- Matching(0)