Question 1

Which of the following is an individual command inside of a macro?

Accepted Answer

A)  program flow statement 
B)  Action 
C)  Comment 
D)  Macro Builder 
A)  program flow statement 
B)  Action 
C)  Comment 
D)  Macro Builder

Question 2

Which of the following Access templates is used to track information about reported issues that need to be resolved?

Accepted Answer

A)  Desktop asset tracking 
B)  Desktop contacts 
C)  Desktop issue tracking 
D)  Desktop project management 
A)  Desktop asset tracking 
B)  Desktop contacts 
C)  Desktop issue tracking 
D)  Desktop project management

Question 3

What are data macros?

Accepted Answer

In contrast to user interface macros,dat

Question 4

Which of the following lets you paste an action?

Accepted Answer

A)  Ctrl+C 
B)  Ctrl+X 
C)  Ctrl+V 
D)  Ctrl+P 
A)  Ctrl+C 
B)  Ctrl+X 
C)  Ctrl+V 
D)  Ctrl+P

Question 5

A stand-alone macro is a separate Access object that appears in the Navigation pane.

Accepted Answer

A) True 
 B)False

Question 6

Which of the following executes after a form or report is already opened and the object gains the focus?

Accepted Answer

A)  On Mouse Up 
B)  On Key Up 
C)  On Open 
D)  On Activate 
A)  On Mouse Up 
B)  On Key Up 
C)  On Open 
D)  On Activate

Question 7

Which of the following executes when the user releases a key that he or she was pressing?

Accepted Answer

A)  On Mouse Up 
B)  On Key Up 
C)  On Open 
D)  On Activate 
A)  On Mouse Up 
B)  On Key Up 
C)  On Open 
D)  On Activate

Question 8

Explain what submacros are and why they are useful.

Accepted Answer

Occasionally you may need to create a su

Question 9

Which of the following categories of user interface macros relates to changing the database system?

Accepted Answer

A)  Database Objects 
B)  Data Entry Operations 
C)  System Commands 
D)  User Interface Commands 
A)  Database Objects 
B)  Data Entry Operations 
C)  System Commands 
D)  User Interface Commands

Question 10

Which of the following Access templates is used to track information about different projects and their related tasks?

Accepted Answer

A)  Desktop asset tracking 
B)  Desktop contacts 
C)  Desktop issue tracking 
D)  Desktop project management 
A)  Desktop asset tracking 
B)  Desktop contacts 
C)  Desktop issue tracking 
D)  Desktop project management

Question 11

Using a parameter in a named data macro allows you to pass data out of a macro.

Accepted Answer

A) True 
 B)False

Question 12

Which of the following Access templates is used to track information about people,such as team members,customers,etc?

Accepted Answer

A)  Desktop asset tracking 
B)  Desktop contacts 
C)  Desktop issue tracking 
D)  Desktop project management 
A)  Desktop asset tracking 
B)  Desktop contacts 
C)  Desktop issue tracking 
D)  Desktop project management

Question 13

Which of the following can execute a macro one action,or step,at a time?

Accepted Answer

A)  parameter 
B)  Single Step tool 
C)  Application Log 
D)  Macro Builder 
A)  parameter 
B)  Single Step tool 
C)  Application Log 
D)  Macro Builder

Question 14

Which of the following exits an EditRecord or CreateRecord data block and does not save the current record?

Accepted Answer

A)  After Update data macro event 
B)  CancelRecordChange data macro action 
C)  RaiseError data macro action 
D)  EditRecord data block macro action 
A)  After Update data macro event 
B)  CancelRecordChange data macro action 
C)  RaiseError data macro action 
D)  EditRecord data block macro action

Question 15

Which of the following returns only records that have matching values in both tables?

Accepted Answer

A)  join type property 
B)  inner join 
C)  left outer join 
D)  right outer join 
A)  join type property 
B)  inner join 
C)  left outer join 
D)  right outer join

Question 16

When a relationship is created,Access assigns it an inner join type.

Accepted Answer

A) True 
 B)False

Question 17

Which of the following is a named block of actions?

Accepted Answer

A)  group 
B)  argument 
C)  submacro 
D)  If block 
A)  group 
B)  argument 
C)  submacro 
D)  If block

Question 18

Which of the following happens after completing the Lookup Wizard?

Accepted Answer

A)  Access automatically creates a relationship between the two tables. 
B)  Access does not create a relationship between the two tables. 
C)  Access sometimes creates a relationship between the two tables,depending on your selections. 
D)  Access gives you the option of creating a relationship between the two tables. 
A)  Access automatically creates a relationship between the two tables. 
B)  Access does not create a relationship between the two tables. 
C)  Access sometimes creates a relationship between the two tables,depending on your selections. 
D)  Access gives you the option of creating a relationship between the two tables.

Question 19

Edit a stand-alone macro by right-clicking the macro name from the Navigation pane and selecting design view.

Accepted Answer

A) True 
 B)False

Question 20

Which of the following categories of user interface macros relates to changing the data?

Accepted Answer

A)  Data Entry Operations 
B)  Data Import/ Export 
C)  Database Objects 
D)  Filter/ Query/ Search 
A)  Data Entry Operations 
B)  Data Import/ Export 
C)  Database Objects 
D)  Filter/ Query/ Search

Which of the following is an individual command inside of a macro?

Which of the following Access templates is used to track information about reported issues that need to be resolved?

What are data macros?

Which of the following lets you paste an action?

A stand-alone macro is a separate Access object that appears in the Navigation pane.

Which of the following executes after a form or report is already opened and the object gains the focus?

Which of the following executes when the user releases a key that he or she was pressing?

Explain what submacros are and why they are useful.

Which of the following categories of user interface macros relates to changing the database system?

Which of the following Access templates is used to track information about different projects and their related tasks?

Using a parameter in a named data macro allows you to pass data out of a macro.

Which of the following Access templates is used to track information about people,such as team members,customers,etc?

Which of the following can execute a macro one action,or step,at a time?

Which of the following exits an EditRecord or CreateRecord data block and does not save the current record?

Which of the following returns only records that have matching values in both tables?

When a relationship is created,Access assigns it an inner join type.

Which of the following is a named block of actions?

Which of the following happens after completing the Lookup Wizard?

Edit a stand-alone macro by right-clicking the macro name from the Navigation pane and selecting design view.

Which of the following categories of user interface macros relates to changing the data?

Creating a Database and Tables

Using Design View, Data Validation, and Relationships

Creating and Using Queries

Creating and Using Forms and Reports

Templates, Advanced Relationships, and Macros

Creating Advanced Forms

Integrating Applications

Designing and Managing Databases

Customizing Access and Using Skydrive and Office Web Apps

Filters

Exam 6: Creating Advanced Queries and Reports and Using SQL

Which of the following is an individual command inside of a macro?

Which of the following Access templates is used to track information about reported issues that need to be resolved?

What are data macros?

Which of the following lets you paste an action?

A stand-alone macro is a separate Access object that appears in the Navigation pane.

Which of the following executes after a form or report is already opened and the object gains the focus?

Which of the following executes when the user releases a key that he or she was pressing?

Explain what submacros are and why they are useful.

Which of the following categories of user interface macros relates to changing the database system?

Which of the following Access templates is used to track information about different projects and their related tasks?

Using a parameter in a named data macro allows you to pass data out of a macro.

Which of the following Access templates is used to track information about people,such as team members,customers,etc?

Which of the following can execute a macro one action,or step,at a time?

Which of the following exits an EditRecord or CreateRecord data block and does not save the current record?

Which of the following returns only records that have matching values in both tables?

When a relationship is created,Access assigns it an inner join type.

Which of the following is a named block of actions?

Which of the following happens after completing the Lookup Wizard?

Edit a stand-alone macro by right-clicking the macro name from the Navigation pane and selecting design view.

Which of the following categories of user interface macros relates to changing the data?

Creating a Database and Tables

Using Design View, Data Validation, and Relationships

Creating and Using Queries

Creating and Using Forms and Reports

Templates, Advanced Relationships, and Macros

Creating Advanced Forms

Integrating Applications

Designing and Managing Databases

Customizing Access and Using Skydrive and Office Web Apps

Filters