Question 1

Both the number and complexity of macros can grow over time as the business grows and needs change.

Accepted Answer

A) True 
 B)False

Question 2

The ________ action pauses a macro so the message can be displayed.

Accepted Answer

The answer of The ________ action pauses a macro so...

Question 3

If the Single Step feature is on when the macro ends,it automatically turns off.

Accepted Answer

A) True 
 B)False

Question 4

________ contain an area to add one or more data actions,and it executes all the actions contained as part of its operation.

Accepted Answer

A) Before events 
B) After events 
C) Data actions 
D) Data blocks 
A) Before events 
B) After events 
C) Data actions 
D) Data blocks

Question 5

An AutoExec macro is a macro group that assigns keys on the keyboard to execute each submacro.

Accepted Answer

A) True 
 B)False

Question 6

Actions can be moved around by ________ them to the desired location.

Accepted Answer

The answer of Actions can be moved around by ________...

Question 7

Embedded macros are displayed in the Navigation Pane.

Accepted Answer

A) True 
 B)False

Question 8

Each submacro in a macro group must have a(n)________ name.

Accepted Answer

A) event 
B) unique 
C) command 
D) submacro 
A) event 
B) unique 
C) command 
D) submacro

Question 9

A(n)________ macro is a macro group that assigns keys on the keyboard to execute each submacro.

Accepted Answer

A) Embedded 
B) AutoExec 
C) Data 
D) AutoKeys 
A) Embedded 
B) AutoExec 
C) Data 
D) AutoKeys

Question 10

An ________ can be bypassed by holding down the Shift key when opening the database.

Accepted Answer

A) AutoKey 
B) AutoExec macro 
C) Action 
D) Action Group 
A) AutoKey 
B) AutoExec macro 
C) Action 
D) Action Group

Question 11

________ are database objects that provide a method of automating routine database tasks.

Accepted Answer

The answer of ________ are database objects that provide a...

Question 12

________ macros are stored in Access tables and are triggered by table events and are typically used to implement business logic into tables and automatically set values in fields.

Accepted Answer

The answer of ________ macros are stored in Access tables...

Question 13

________ can help increase both the efficiency and the usability of a database.

Accepted Answer

A) Business rules 
B) Processing time 
C) Arguments 
D) Macros 
A) Business rules 
B) Processing time 
C) Arguments 
D) Macros

Question 14

When the MessageBox action is executed the macro is paused so the message can be displayed.You need to click ________ in order for the macro to continue.

Accepted Answer

A) Cancel 
B) Continue 
C) OK 
D) Go 
A) Cancel 
B) Continue 
C) OK 
D) Go

Question 15

The ________ is a searchable set of macro actions that can retrieve actions based on keywords.

Accepted Answer

The answer of The ________ is a searchable set of...

Question 16

If you disable all macros except digitally signed macros,then ________.

Accepted Answer

A) all macros are disabled and Access provides security alerts if there are macros present,which is the default setting 
B) you disable all macros with notification ,except digitally assigned macros which are enabled by default 
C) Access allows all macros to run which makes your computer vulnerable to potentially malicious code and is not recommended 
D) all macros and security alerts about macros are disabled 
A) all macros are disabled and Access provides security alerts if there are macros present,which is the default setting 
B) you disable all macros with notification ,except digitally assigned macros which are enabled by default 
C) Access allows all macros to run which makes your computer vulnerable to potentially malicious code and is not recommended 
D) all macros and security alerts about macros are disabled

Question 17

A(n)________ is a self-contained instruction that can be combined with other instructions to automate tasks and is considered to be the basic building block of macros.

Accepted Answer

The answer of A(n)________ is a self-contained instruction that can...

Question 18

A ________ is two or more submacros that are similar in function and are stored under the same macro name.

Accepted Answer

A) macro group 
B) data actions group 
C) submacro group 
D) data blocks group 
A) macro group 
B) data actions group 
C) submacro group 
D) data blocks group

Question 19

Match between columns
                        Premises: Stand-alone macro
Data macro
Embedded macro
Macro
Argument

Accepted Answer

The Answer of Stored as part of a database object is...

Question 20

Which of the following is NOT true regarding the safety and security of your database?

Accepted Answer

A) The sequence of macro commands can be harmful when executed. 
B) Harmful macros have been known to add,edit,or remove data from a database. 
C) A Trusted Location will fully protect you from any harmful attack. 
D) Harmful macros can often spread to other databases or even to the user's computer. 
A) The sequence of macro commands can be harmful when executed. 
B) Harmful macros have been known to add,edit,or remove data from a database. 
C) A Trusted Location will fully protect you from any harmful attack. 
D) Harmful macros can often spread to other databases or even to the user's computer.

Both the number and complexity of macros can grow over time as the business grows and needs change.

The ________ action pauses a macro so the message can be displayed.

If the Single Step feature is on when the macro ends,it automatically turns off.

________ contain an area to add one or more data actions,and it executes all the actions contained as part of its operation.

An AutoExec macro is a macro group that assigns keys on the keyboard to execute each submacro.

Actions can be moved around by ________ them to the desired location.

Embedded macros are displayed in the Navigation Pane.

Each submacro in a macro group must have a(n)________ name.

A(n)________ macro is a macro group that assigns keys on the keyboard to execute each submacro.

An ________ can be bypassed by holding down the Shift key when opening the database.

________ are database objects that provide a method of automating routine database tasks.

________ macros are stored in Access tables and are triggered by table events and are typically used to implement business logic into tables and automatically set values in fields.

________ can help increase both the efficiency and the usability of a database.

When the MessageBox action is executed the macro is paused so the message can be displayed.You need to click ________ in order for the macro to continue.

The ________ is a searchable set of macro actions that can retrieve actions based on keywords.

If you disable all macros except digitally signed macros,then ________.

A(n)________ is a self-contained instruction that can be combined with other instructions to automate tasks and is considered to be the basic building block of macros.

A ________ is two or more submacros that are similar in function and are stored under the same macro name.

Which of the following is NOT true regarding the safety and security of your database?

Workshop 1: The Four Main Database Objects

Workshop 2: Tables, Keys, and Relationships

Workshop 3: Queries and Data Access

Workshop 4: Access Information From an Access Database

Workshop 5: Advanced Tables

Workshop 6: Pattern Matching and Functions in Queries

Workshop 7: Aggregated Calculations, Subquerying, and Sql

Workshop 8: Action Queries and Advanced Relationships

Workshop 9: Advanced Reports and Mailing Labels

Workshop 10: Advanced Form Settings and Form Types

Workshop 11: Develop Navigation Forms and the User Interface

Workshop 13: Use VBA in Access

Workshop 14: Implement Your Database

Normalize a Database for Effective Design

The Common Features of Microsoft Office

Efficient Interaction With a Touch Screen

Filters

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

Both the number and complexity of macros can grow over time as the business grows and needs change.

The ________ action pauses a macro so the message can be displayed.

If the Single Step feature is on when the macro ends,it automatically turns off.

________ contain an area to add one or more data actions,and it executes all the actions contained as part of its operation.

An AutoExec macro is a macro group that assigns keys on the keyboard to execute each submacro.

Actions can be moved around by ________ them to the desired location.

Embedded macros are displayed in the Navigation Pane.

Each submacro in a macro group must have a(n)________ name.

A(n)________ macro is a macro group that assigns keys on the keyboard to execute each submacro.

An ________ can be bypassed by holding down the Shift key when opening the database.

________ are database objects that provide a method of automating routine database tasks.

________ macros are stored in Access tables and are triggered by table events and are typically used to implement business logic into tables and automatically set values in fields.

________ can help increase both the efficiency and the usability of a database.

When the MessageBox action is executed the macro is paused so the message can be displayed.You need to click ________ in order for the macro to continue.

The ________ is a searchable set of macro actions that can retrieve actions based on keywords.

If you disable all macros except digitally signed macros,then ________.

A(n)________ is a self-contained instruction that can be combined with other instructions to automate tasks and is considered to be the basic building block of macros.

A ________ is two or more submacros that are similar in function and are stored under the same macro name.

Which of the following is NOT true regarding the safety and security of your database?

Workshop 1: The Four Main Database Objects

Workshop 2: Tables, Keys, and Relationships

Workshop 3: Queries and Data Access

Workshop 4: Access Information From an Access Database

Workshop 5: Advanced Tables

Workshop 6: Pattern Matching and Functions in Queries

Workshop 7: Aggregated Calculations, Subquerying, and Sql

Workshop 8: Action Queries and Advanced Relationships

Workshop 9: Advanced Reports and Mailing Labels

Workshop 10: Advanced Form Settings and Form Types

Workshop 11: Develop Navigation Forms and the User Interface

Workshop 13: Use VBA in Access

Workshop 14: Implement Your Database

Normalize a Database for Effective Design

The Common Features of Microsoft Office

Efficient Interaction With a Touch Screen

Filters