Question 1

Create a(n)_____ query to change the name of a supervisor in an Employee table.

Accepted Answer

A)  Make-Table 
B)  Update 
C)  Self-Join 
D)  Target 
A)  Make-Table 
B)  Update 
C)  Self-Join 
D)  Target

Question 2

Access provides four types of action queries: _____,Append,Delete,and Update.

Accepted Answer

A)  Top Values 
B)  Crosstab 
C)  Make-Table 
D)  Inner Join 
A)  Top Values 
B)  Crosstab 
C)  Make-Table 
D)  Inner Join

Question 3

Which of the following are true about action queries? Select all the options that apply.

Accepted Answer

A)  Every action query starts as a Select query. 
B)  You run an action query by clicking the View button in Query Design View. 
C)  An action query changes data. 
D)  In the Navigation Pane,the icon for an action query includes an exclamation point. 
A)  Every action query starts as a Select query. 
B)  You run an action query by clicking the View button in Query Design View. 
C)  An action query changes data. 
D)  In the Navigation Pane,the icon for an action query includes an exclamation point.

Question 4

An Append query adds selected records to an existing table.

Accepted Answer

A) True 
 B)False

Question 5

_____ view is a spreadsheet-like view of the data in a table.

Accepted Answer

A)  Design 
B)  Layout 
C)  Form 
D)  Datasheet 
A)  Design 
B)  Layout 
C)  Form 
D)  Datasheet

Question 6

If you often sort on a field,you should set its_____ property to Yes.

Accepted Answer

A)  Required 
B)  Caption 
C)  Bound Column 
D)  Indexed 
A)  Required 
B)  Caption 
C)  Bound Column 
D)  Indexed

Question 7

What happens if you delete a row from the query design grid?

Accepted Answer

A)  You delete all the records that match the specified criteria. 
B)  You delete the field from the grid,but not from the field list. 
C)  You delete the criteria in the row. 
D)  You receive an error message and cannot continue deleting the row. 
A)  You delete all the records that match the specified criteria. 
B)  You delete the field from the grid,but not from the field list. 
C)  You delete the criteria in the row. 
D)  You receive an error message and cannot continue deleting the row.

Question 8

You can add rows to the query grid,but you cannot delete them.

Accepted Answer

A) True 
 B)False

Question 9

Enter _____ criteria on different Criteria rows in the query design grid.

Accepted Answer

A)  AND 
B)  Date/Time 
C)  null 
D)  OR 
A)  AND 
B)  Date/Time 
C)  null 
D)  OR

Question 10

When you create a table with a Make-Table query,you can store the new table _____.

Accepted Answer

A)  in the current database or another Access database 
B)  in the current database only 
C)  in another Access database only 
D)  in any Excel workbook 
A)  in the current database or another Access database 
B)  in the current database only 
C)  in another Access database only 
D)  in any Excel workbook

Question 11

The upper pane of _____ view shows field names and data types.

Accepted Answer

A)  Table Datasheet 
B)  Query Design 
C)  Table Tools 
D)  Table Design 
A)  Table Datasheet 
B)  Query Design 
C)  Table Tools 
D)  Table Design

Question 12

If you want to add records from one table to a backup table,create a(n)Append query.

Accepted Answer

A) True 
 B)False

Question 13

When you add a field to a table in Table Design view,entering the field name is optional.

Accepted Answer

A) True 
 B)False

Question 14

As with other action queries,the icon for an Append query includes a(n)_____ to remind you that it changes data when you run the query.

Accepted Answer

A)  question mark 
B)  red asterisk 
C)  exclamation point 
D)  red X 
A)  question mark 
B)  red asterisk 
C)  exclamation point 
D)  red X

Question 15

To remove retired employees from an Employee table,create a(n)_____ query.

Accepted Answer

A)  Delete 
B)  Parameter 
C)  History 
D)  Update 
A)  Delete 
B)  Parameter 
C)  History 
D)  Update

Question 16

Which of the following is a difference between Table Design view and Table Datasheet view?

Accepted Answer

A)  Table Datasheet view does not display data. 
B)  Table Design view displays table relationships. 
C)  Table Design view does not display data. 
D)  Table Datasheet view does not allow changes. 
A)  Table Datasheet view does not display data. 
B)  Table Design view displays table relationships. 
C)  Table Design view does not display data. 
D)  Table Datasheet view does not allow changes.

Question 17

A Make-Table query is a type of _____ query that creates a new table of data.

Accepted Answer

A)  action 
B)  select 
C)  structured 
D)  create 
A)  action 
B)  select 
C)  structured 
D)  create

Question 18

When you change a select query to an Update query,Access displays the _____ row in the query design grid.

Accepted Answer

A)  Update To 
B)  Totals 
C)  Calculated Field 
D)  Join 
A)  Update To 
B)  Totals 
C)  Calculated Field 
D)  Join

Question 19

What kind of criteria would you use to find records with OrderDate values in May or June?

Accepted Answer

A)  IS NULL 
B)  PLUS 
C)  AND 
D)  OR 
A)  IS NULL 
B)  PLUS 
C)  AND 
D)  OR

Question 20

To select records from the Customers table that have no related records in the Sales table,create a(n)_____ join.

Accepted Answer

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

Create a(n)_____ query to change the name of a supervisor in an Employee table.

Access provides four types of action queries: _____,Append,Delete,and Update.

Which of the following are true about action queries? Select all the options that apply.

An Append query adds selected records to an existing table.

_____ view is a spreadsheet-like view of the data in a table.

If you often sort on a field,you should set its_____ property to Yes.

What happens if you delete a row from the query design grid?

You can add rows to the query grid,but you cannot delete them.

Enter _____ criteria on different Criteria rows in the query design grid.

When you create a table with a Make-Table query,you can store the new table _____.

The upper pane of _____ view shows field names and data types.

If you want to add records from one table to a backup table,create a(n)Append query.

When you add a field to a table in Table Design view,entering the field name is optional.

As with other action queries,the icon for an Append query includes a(n)_____ to remind you that it changes data when you run the query.

To remove retired employees from an Employee table,create a(n)_____ query.

Which of the following is a difference between Table Design view and Table Datasheet view?

A Make-Table query is a type of _____ query that creates a new table of data.

When you change a select query to an Update query,Access displays the _____ row in the query design grid.

What kind of criteria would you use to find records with OrderDate values in May or June?

To select records from the Customers table that have no related records in the Sales table,create a(n)_____ join.

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

Analyzing Data With Business Intelligence Tools

Exploring Pivottable Design

Developing an Excel Application

Filters

Exam 9: Exploring Financial Tools and Functions

Create a(n)_____ query to change the name of a supervisor in an Employee table.

Access provides four types of action queries: _____,Append,Delete,and Update.

Which of the following are true about action queries? Select all the options that apply.

An Append query adds selected records to an existing table.

_____ view is a spreadsheet-like view of the data in a table.

If you often sort on a field,you should set its_____ property to Yes.

What happens if you delete a row from the query design grid?

You can add rows to the query grid,but you cannot delete them.

Enter _____ criteria on different Criteria rows in the query design grid.

When you create a table with a Make-Table query,you can store the new table _____.

The upper pane of _____ view shows field names and data types.

If you want to add records from one table to a backup table,create a(n)Append query.

When you add a field to a table in Table Design view,entering the field name is optional.

As with other action queries,the icon for an Append query includes a(n)_____ to remind you that it changes data when you run the query.

To remove retired employees from an Employee table,create a(n)_____ query.

Which of the following is a difference between Table Design view and Table Datasheet view?

A Make-Table query is a type of _____ query that creates a new table of data.

When you change a select query to an Update query,Access displays the _____ row in the query design grid.

What kind of criteria would you use to find records with OrderDate values in May or June?

To select records from the Customers table that have no related records in the Sales table,create a(n)_____ join.

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

Analyzing Data With Business Intelligence Tools

Exploring Pivottable Design

Developing an Excel Application

Filters