Question 1

Vertical Tabs,Left is one of the _____ you can select for a Navigation form.

Accepted Answer

A)  navigation system styles 
B)  startup options 
C)  form dependencies 
D)  database objects 
A)  navigation system styles 
B)  startup options 
C)  form dependencies 
D)  database objects

Question 2

What is the first step in creating a query with a self join in Query Design View?

Accepted Answer

A)  Display two field lists for the same table. 
B)  Add the Join Type row to the query design grid. 
C)  Remove all field lists from the upper pane. 
D)  Establish a one-to-many relationship between two tables. 
A)  Display two field lists for the same table. 
B)  Add the Join Type row to the query design grid. 
C)  Remove all field lists from the upper pane. 
D)  Establish a one-to-many relationship between two tables.

Question 3

_____ are properties of an action that provide additional information on how the action should execute.

Accepted Answer

A)  Comments 
B)  Arguments 
C)  Events 
D)  Conditions 
A)  Comments 
B)  Arguments 
C)  Events 
D)  Conditions

Question 4

In Access macros,you can use conditional expressions in If statements.

Accepted Answer

A) True 
 B)False

Question 5

Which argument of the MessageBox macro action determines the text in the title bar of the message dialog box?

Accepted Answer

A)  Message 
B)  View 
C)  Title 
D)  Type 
A)  Message 
B)  View 
C)  Title 
D)  Type

Question 6

If you want a macro to display a message after opening a form,where should you insert the MessageBox action?

Accepted Answer

A)  As the first action in the macro 
B)  After the OpenForm action 
C)  As the last action in the macro 
D)  Before the OpenForm action 
A)  As the first action in the macro 
B)  After the OpenForm action 
C)  As the last action in the macro 
D)  Before the OpenForm action

Question 7

You can view the SQL code for any query by switching to _____ view.

Accepted Answer

A)  Code 
B)  Design 
C)  SQL 
D)  Layout 
A)  Code 
B)  Design 
C)  SQL 
D)  Layout

Question 8

Which of the following are benefits of using macros? Select all the options that apply.

Accepted Answer

A)  They can increase accuracy by flagging data entry errors. 
B)  They can increase accuracy by flagging data entry errors 
C)  They decrease the number of objects required in the database. 
D)  They help users by responding to their interactions within a form. 
A)  They can increase accuracy by flagging data entry errors. 
B)  They can increase accuracy by flagging data entry errors 
C)  They decrease the number of objects required in the database. 
D)  They help users by responding to their interactions within a form.

Question 9

Which of the following clauses can an If statement contain in a macro?

Accepted Answer

A)  Otherwise and Never 
B)  Where and When 
C)  Else and Else If 
D)  Do and Until 
A)  Otherwise and Never 
B)  Where and When 
C)  Else and Else If 
D)  Do and Until

Question 10

In a macro,a Group component lets you sort macro arguments.

Accepted Answer

A) True 
 B)False

Question 11

The Action Catalog lists all of the macro actions organized by category.

Accepted Answer

A) True 
 B)False

Question 12

You cannot view a query with a self join in SQL View.

Accepted Answer

A) True 
 B)False

Question 13

Change a form's Navigation Buttons property to No to remove the navigation bar from the form.

Accepted Answer

A) True 
 B)False

Question 14

The part of an If statement that is evaluated as either true or false is called a(n)_____.

Accepted Answer

A)  procedure 
B)  conditional expression 
C)  event 
D)  Else clause 
A)  procedure 
B)  conditional expression 
C)  event 
D)  Else clause

Question 15

When you single step a macro,you _____.

Accepted Answer

A)  create the macro with one action 
B)  run the macro one action at a time 
C)  record the macro as you perform steps 
D)  add an action with only one argument 
A)  create the macro with one action 
B)  run the macro one action at a time 
C)  record the macro as you perform steps 
D)  add an action with only one argument

Question 16

Which of the following tasks is a good candidate for a macro?

Accepted Answer

A)  Modifying the design of a form 
B)  Printing several reports 
C)  Creating a report 
D)  Adding a chart to a tab control 
A)  Modifying the design of a form 
B)  Printing several reports 
C)  Creating a report 
D)  Adding a chart to a tab control

Question 17

When you add actions to a Group program flow,the macro does not perform the actions.

Accepted Answer

A) True 
 B)False

Question 18

Create a(n)_____ join to relate an Employee table to itself using two fields in the same table to identify the relationship between employees and supervisors.

Accepted Answer

A)  inner 
B)  outer 
C)  self 
D)  referential 
A)  inner 
B)  outer 
C)  self 
D)  referential

Question 19

Which argument of the OpenReport macro action determines the report to open?

Accepted Answer

A)  Title 
B)  On Click 
C)  View 
D)  Report Name 
A)  Title 
B)  On Click 
C)  View 
D)  Report Name

Question 20

One way to _____ a macro is to single step through the macro.

Accepted Answer

A)  modify 
B)  rename 
C)  program 
D)  debug 
A)  modify 
B)  rename 
C)  program 
D)  debug

Vertical Tabs,Left is one of the _____ you can select for a Navigation form.

What is the first step in creating a query with a self join in Query Design View?

_____ are properties of an action that provide additional information on how the action should execute.

In Access macros,you can use conditional expressions in If statements.

Which argument of the MessageBox macro action determines the text in the title bar of the message dialog box?

If you want a macro to display a message after opening a form,where should you insert the MessageBox action?

You can view the SQL code for any query by switching to _____ view.

Which of the following are benefits of using macros? Select all the options that apply.

Which of the following clauses can an If statement contain in a macro?

In a macro,a Group component lets you sort macro arguments.

The Action Catalog lists all of the macro actions organized by category.

You cannot view a query with a self join in SQL View.

Change a form's Navigation Buttons property to No to remove the navigation bar from the form.

The part of an If statement that is evaluated as either true or false is called a(n)_____.

When you single step a macro,you _____.

Which of the following tasks is a good candidate for a macro?

When you add actions to a Group program flow,the macro does not perform the actions.

Create a(n)_____ join to relate an Employee table to itself using two fields in the same table to identify the relationship between employees and supervisors.

Which argument of the OpenReport macro action determines the report to open?

One way to _____ a macro is to single step through the macro.

Getting Started With Excel

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

Analyzing and Charting Financial Data

Generating Reports From Multiple Worksheets and Workbooks

Managing Data With Data Tools

Summarizing Data With Pivottables

Performing What-If Analyses

Exploring Financial Tools and Functions

Exploring Pivottable Design

Developing an Excel Application

Filters

Exam 10: Analyzing Data With Business Intelligence Tools

Vertical Tabs,Left is one of the _____ you can select for a Navigation form.

What is the first step in creating a query with a self join in Query Design View?

_____ are properties of an action that provide additional information on how the action should execute.

In Access macros,you can use conditional expressions in If statements.

Which argument of the MessageBox macro action determines the text in the title bar of the message dialog box?

If you want a macro to display a message after opening a form,where should you insert the MessageBox action?

You can view the SQL code for any query by switching to _____ view.

Which of the following are benefits of using macros? Select all the options that apply.

Which of the following clauses can an If statement contain in a macro?

In a macro,a Group component lets you sort macro arguments.

The Action Catalog lists all of the macro actions organized by category.

You cannot view a query with a self join in SQL View.

Change a form's Navigation Buttons property to No to remove the navigation bar from the form.

The part of an If statement that is evaluated as either true or false is called a(n)_____.

When you single step a macro,you _____.

Which of the following tasks is a good candidate for a macro?

When you add actions to a Group program flow,the macro does not perform the actions.

Create a(n)_____ join to relate an Employee table to itself using two fields in the same table to identify the relationship between employees and supervisors.

Which argument of the OpenReport macro action determines the report to open?

One way to _____ a macro is to single step through the macro.

Getting Started With Excel

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

Analyzing and Charting Financial Data

Generating Reports From Multiple Worksheets and Workbooks

Managing Data With Data Tools

Summarizing Data With Pivottables

Performing What-If Analyses

Exploring Financial Tools and Functions

Exploring Pivottable Design

Developing an Excel Application

Filters