Question 1

The ________ is an interface for building and editing macros.

Accepted Answer

The answer of The ________ is an interface for building...

Question 2

The ________ argument has a 255 character limit,just as a Text data type in tables.

Accepted Answer

The answer of The ________ argument has a 255 character...

Question 3

Match between columns
                        Premises: On Enter
On Exit
On Lost Focus
On Got Focus
On Click

Accepted Answer

The Answer of Occurs when a user presses Tab to is...

Question 4

Macros can add functionality to reports and forms,as well as the controls that forms and reports contain.

Accepted Answer

A) True 
 B)False

Question 5

Which of the following is NOT true regarding the Actions group?

Accepted Answer

A) The same Program Flow information is also provided in the Help window located at the bottom of the Action Catalog when an action is selected. 
B) The Actions group contains several different categories of actions. 
C) The categories of actions are grouped together based on purpose and function and can be used to build a macro. 
D) As you point to each action group and action,Access displays a ScreenTip that explains the general purpose of the object. 
A) The same Program Flow information is also provided in the Help window located at the bottom of the Action Catalog when an action is selected. 
B) The Actions group contains several different categories of actions. 
C) The categories of actions are grouped together based on purpose and function and can be used to build a macro. 
D) As you point to each action group and action,Access displays a ScreenTip that explains the general purpose of the object.

Question 6

If part of your macro is functioning correctly,then you can begin single stepping at a specific point in the macro by adding the Single Step macro action at the point where you wish to begin single stepping.

Accepted Answer

A) True 
 B)False

Question 7

________ in data macros occur after the changes have been successfully made to the table.

Accepted Answer

The answer of ________ in data macros occur after the...

Question 8

When a macro group is created,only the name appears in the navigation form regardless of how many submacros it contains.

Accepted Answer

A) True 
 B)False

Question 9

The Action Catalog consists of three different groups: Program Flow,Actions,and In this Database.

Accepted Answer

A) True 
 B)False

Question 10

Match between columns
                        Premises: Action
Submacro
Comment
Group
If

Accepted Answer

The Answer of Internal documentation and A self-contained instruction and is...

Question 11

________ that describe the purpose of a macro or complex program flows are considered best practice but are many times neglected by database programmers.

Accepted Answer

A) Comments 
B) Notes 
C) Group 
D) Data Actions 
A) Comments 
B) Notes 
C) Group 
D) Data Actions

Question 12

Which of the following is NOT true in regard to selecting the appropriate macro setting?

Accepted Answer

A) The most common settings are Disable all macros with notification and Disable all macros except digitally signed macros. 
B) Settings can help to mitigate the risk of a macro virus and still allow useful macros to run. 
C) Depending on the nature of the organization,the policy may be to disable all macros. 
D) If the database is in a location defined as a Trusted Location,the macros will not be ignored by the Trust Center security system. 
A) The most common settings are Disable all macros with notification and Disable all macros except digitally signed macros. 
B) Settings can help to mitigate the risk of a macro virus and still allow useful macros to run. 
C) Depending on the nature of the organization,the policy may be to disable all macros. 
D) If the database is in a location defined as a Trusted Location,the macros will not be ignored by the Trust Center security system.

Question 13

________ macros do not include the entire action list that is available in other macros.

Accepted Answer

The answer of ________ macros do not include the entire...

Question 14

Macros can be printed by clicking the Design tab on the Ribbon,clicking Database Documenter in the Analyze group,clicking the Macros tab,and then clicking the macro to be printed.

Accepted Answer

A) True 
 B)False

Question 15

Data macros are typically used to implement ________ into tables and automatically set values in fields.

Accepted Answer

The answer of Data macros are typically used to implement...

Question 16

If you receive an Error Number of ________ when stepping through a macro,then it means there is no error detected with a macro action.

Accepted Answer

A) zero 
B) none 
C) null 
D) one 
A) zero 
B) none 
C) null 
D) one

Question 17

In reference to a message box that appears during the execution of a macro,the frequency and duration of the ________ depend on the hardware,which varies between computers.

Accepted Answer

A) AutoExec 
B) MessageBox 
C) SelectObject 
D) Beep 
A) AutoExec 
B) MessageBox 
C) SelectObject 
D) Beep

Question 18

A(n)________ is a form of internal documentation that can help explain the purpose of a macro.

Accepted Answer

The answer of A(n)________ is a form of internal documentation...

Question 19

A well-designed ________ takes,among other things,efficiency and usability into consideration.

Accepted Answer

A) database application 
B) navigation form 
C) macro 
D) embedded macro 
A) database application 
B) navigation form 
C) macro 
D) embedded macro

Question 20

Any file that you put in a(n)________ can be opened without being checked by the Trust Center security feature.

Accepted Answer

A) Trusted Location 
B) embedded macro 
C) path 
D) macro 
A) Trusted Location 
B) embedded macro 
C) path 
D) macro

The ________ is an interface for building and editing macros.

The ________ argument has a 255 character limit,just as a Text data type in tables.

Macros can add functionality to reports and forms,as well as the controls that forms and reports contain.

Which of the following is NOT true regarding the Actions group?

If part of your macro is functioning correctly,then you can begin single stepping at a specific point in the macro by adding the Single Step macro action at the point where you wish to begin single stepping.

________ in data macros occur after the changes have been successfully made to the table.

When a macro group is created,only the name appears in the navigation form regardless of how many submacros it contains.

The Action Catalog consists of three different groups: Program Flow,Actions,and In this Database.

________ that describe the purpose of a macro or complex program flows are considered best practice but are many times neglected by database programmers.

Which of the following is NOT true in regard to selecting the appropriate macro setting?

________ macros do not include the entire action list that is available in other macros.

Macros can be printed by clicking the Design tab on the Ribbon,clicking Database Documenter in the Analyze group,clicking the Macros tab,and then clicking the macro to be printed.

Data macros are typically used to implement ________ into tables and automatically set values in fields.

If you receive an Error Number of ________ when stepping through a macro,then it means there is no error detected with a macro action.

In reference to a message box that appears during the execution of a macro,the frequency and duration of the ________ depend on the hardware,which varies between computers.

A(n)________ is a form of internal documentation that can help explain the purpose of a macro.

A well-designed ________ takes,among other things,efficiency and usability into consideration.

Any file that you put in a(n)________ can be opened without being checked by the Trust Center security feature.

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

The ________ is an interface for building and editing macros.

The ________ argument has a 255 character limit,just as a Text data type in tables.

Macros can add functionality to reports and forms,as well as the controls that forms and reports contain.

Which of the following is NOT true regarding the Actions group?

If part of your macro is functioning correctly,then you can begin single stepping at a specific point in the macro by adding the Single Step macro action at the point where you wish to begin single stepping.

________ in data macros occur after the changes have been successfully made to the table.

When a macro group is created,only the name appears in the navigation form regardless of how many submacros it contains.

The Action Catalog consists of three different groups: Program Flow,Actions,and In this Database.

________ that describe the purpose of a macro or complex program flows are considered best practice but are many times neglected by database programmers.

Which of the following is NOT true in regard to selecting the appropriate macro setting?

________ macros do not include the entire action list that is available in other macros.

Macros can be printed by clicking the Design tab on the Ribbon,clicking Database Documenter in the Analyze group,clicking the Macros tab,and then clicking the macro to be printed.

Data macros are typically used to implement ________ into tables and automatically set values in fields.

If you receive an Error Number of ________ when stepping through a macro,then it means there is no error detected with a macro action.

In reference to a message box that appears during the execution of a macro,the frequency and duration of the ________ depend on the hardware,which varies between computers.

A(n)________ is a form of internal documentation that can help explain the purpose of a macro.

A well-designed ________ takes,among other things,efficiency and usability into consideration.

Any file that you put in a(n)________ can be opened without being checked by the Trust Center security feature.

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