Exam 12: Workshop 12: Create a Refined User Experience With Macros

arrow
  • Select Tags
search iconSearch Question
flashcardsStudy Flashcards
  • Select Tags

Macros are composed of actions that often contain ________ to determine when and how to perform the action.

(Multiple Choice)
4.8/5
(39)
Match the following macro actions to their description.
Beep
Restrict or sort records
ApplyFilter
Uses the computer's speakers
GoToControl
Moves the focus
Correct Answer:
Verified
Premises:
Responses:
Beep
Restrict or sort records
ApplyFilter
Uses the computer's speakers
GoToControl
Moves the focus
AutoExec
Provides a visual indication
DisplayHourglassPointer
Runs when the database is opened
(Matching)
4.9/5
(30)

When the ________ is turned on,the macro executes one action at a time and pauses between actions.

(Multiple Choice)
4.9/5
(37)

________ macros are stored as part of a database object such as a form or report or any control like a button.

(Short Answer)
4.8/5
(34)

If you disable all macros with notification,then ________.

(Multiple Choice)
4.8/5
(46)

A(n)________ occurs when an action is completed on any given object.The action could be,for example,a simple click of the mouse or entering information into a specific field.

(Short Answer)
4.8/5
(36)

The ________ action can only be used inside of an EditRecord or CreateRecord data block.

(Short Answer)
4.9/5
(37)

Any file that you put in a trusted location can be opened without being checked by the Trust Center security feature.

(True/False)
4.8/5
(31)

Certain data actions are available for all table events.

(True/False)
4.8/5
(33)

Trusted macros have been known to add,edit,or remove data from a database and often spread to other databases or even to the user's computer.

(True/False)
4.8/5
(39)

Access allows a macro to be copied from the Macro Designer and pasted into a text editor as ________ to save as a backup or to share with others.

(Short Answer)
4.8/5
(36)

As you point to each action group and action,Access displays a(n)________ that explains the general purpose of the object.

(Short Answer)
4.9/5
(26)

Certain ________ are available for certain table events.

(Multiple Choice)
4.7/5
(39)
Match the macro syntax with the following key assignments.
Press Ctrl and type r
{DEL}
Press Shift + F3
{INS}
Press Insert
^{F2}
Correct Answer:
Verified
Premises:
Responses:
Press Ctrl and type r
{DEL}
Press Shift + F3
{INS}
Press Insert
^{F2}
Press Ctrl + F2
+{F3}
Press Delete
^r
(Matching)
4.8/5
(30)

________ can easily be added to other macros by using the RunMacro or OnError actions,or they can be easily assigned to events.

(Multiple Choice)
4.8/5
(34)

When the ________ is turned on,the macro executes one action at a time and pauses between actions.

(Short Answer)
4.7/5
(37)

________ can be incorporated into other macros by using the RunMacro or OnError actions but cannot be executed directly from the Navigation Pane.

(Short Answer)
4.7/5
(39)

Actions can be added to the macro by simply selecting one from the Add New Macro list or by searching the Action Catalog.

(True/False)
4.8/5
(35)
Match the following table-level events to their description.
Before Change
Occurs prior to removing a record
After Update
Occurs when a new record has been added
After Delete
Occurs once a record is deleted
Correct Answer:
Verified
Premises:
Responses:
Before Change
Occurs prior to removing a record
After Update
Occurs when a new record has been added
After Delete
Occurs once a record is deleted
Before Delete
Occurs when any field in a record changes
After Insert
Occurs when a record is about to change
(Matching)
4.8/5
(33)

There are five different table events that macros can be associated with: Before Change,Before Delete,After Insert,After Update,and After Delete.

(True/False)
4.9/5
(28)
Showing 41 - 60 of 100
close modal

Filters

  • Essay(0)
  • Multiple Choice(0)
  • Short Answer(0)
  • True False(0)
  • Matching(0)