Services
Discover
Homeschooling
Ask a Question
Log in
Sign up
Filters
Done
Question type:
Essay
Multiple Choice
Short Answer
True False
Matching
Topic
Computing
Study Set
Microsoft Access
Quiz 12: Workshop 12: Create a Refined User Experience With Macros
Path 4
Access For Free
Share
All types
Filters
Study Flashcards
Practice Exam
Learn
Question 81
Short Answer
The ________ action allows the user to bypass all prompts that accompany various actions in a database.
Question 82
Short Answer
________ macros do not include the entire action list that is available in other macros.
Question 83
Short Answer
By embedding the macro it becomes ________,and if you export the form into another database any macros embedded will remain with the object.
Question 84
Short Answer
A(n)________ macro is a macro group that assigns keys on the keyboard to execute each submacro.
Question 85
Matching
Match the following terms to their description.
Premises:
Responses:
Stand-alone macro
Stored as part of a database object
Data macro
Stored in Access tables
Embedded macro
Automate routine database tasks
Premises:
Stand-alone macro
Data macro
Embedded macro
Responses:
Stored as part of a database object
Stored in Access tables
Automate routine database tasks
Question 86
Short Answer
________ in data macros occur after the changes have been successfully made to the table.
Question 87
Matching
Match the following terms to their description.
Premises:
Responses:
Action
Internal documentation
Submacro
A self-contained instruction
Comment
Can be collapsed,expanded,and moved together
Premises:
Action
Submacro
Comment
Responses:
Internal documentation
A self-contained instruction
Can be collapsed,expanded,and moved together
Question 88
Short Answer
The ________ action pauses a macro so the message can be displayed.
Question 89
Matching
Match the following macro actions to their description.
Premises:
Responses:
Beep
Restrict or sort records
ApplyFilter
Uses the computer's speakers
GoToControl
Moves the focus
Premises:
Beep
ApplyFilter
GoToControl
Responses:
Restrict or sort records
Uses the computer's speakers
Moves the focus
Question 90
Short Answer
A(n)________ is two or more submacros that are similar in function and are stored under the same macro name.
Question 91
Short Answer
The ________ action can only be used inside of an EditRecord or CreateRecord data block.
Question 92
Short Answer
When the ________ is turned on,the macro executes one action at a time and pauses between actions.
Question 93
Short Answer
Data macros are typically used to implement ________ into tables and automatically set values in fields.
Question 94
Matching
Match the macro syntax with the following key assignments.
Premises:
Responses:
Press Ctrl and type r
{DEL}
Press Shift + F3
{INS}
Press Insert
^{F2}
Premises:
Press Ctrl and type r
Press Shift + F3
Press Insert
Responses:
{DEL}
{INS}
^{F2}
Question 95
Matching
Match the following common events to their description.
Premises:
Responses:
On Enter
Occurs when a user presses Tab to move the focus
On Exit
Occurs after a user presses and releases the left mouse button
On Lost Focus
Occurs when a user presses Tab to focus on an object
Premises:
On Enter
On Exit
On Lost Focus
Responses:
Occurs when a user presses Tab to move the focus
Occurs after a user presses and releases the left mouse button
Occurs when a user presses Tab to focus on an object