Question 1

All the fields selected in a(n) _____ query must match fields with the same data types in the target table.

Accepted Answer

A)  Make-Table 
B)  Crosstab 
C)  Apply 
D)  Append 
A)  Make-Table 
B)  Crosstab 
C)  Apply 
D)  Append

Question 2

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 3

If you set the _____ property for a field that is often used for sorting, you improve database performance.

Accepted Answer

A)  Sort 
B)  Indexed 
C)  Duplicates 
D)  Validation 
A)  Sort 
B)  Indexed 
C)  Duplicates 
D)  Validation

Question 4

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 5

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 6

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

Question 7

An action query, such as a Make-Table query, selects and changes all of the selected data when you run it.

Accepted Answer

A) True 
 B)False

Question 8

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 9

Which of the following could you use to export records to a new table?

Accepted Answer

A)  Parameter query 
B)  Make-Table query 
C)  Update query 
D)  Delete query 
A)  Parameter query 
B)  Make-Table query 
C)  Update query 
D)  Delete query

Question 10

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 11

To view all the indexes in a table at the same time, use the Indexes button in Table Design view.

Accepted Answer

A) True 
 B)False

Question 12

If you want to export records to another Access database, create a Top Values query.

Accepted Answer

False - Make-Table
False - Mak

Question 13

If you are creating a query using fields from two related tables, the join line Identifies which fields establish a relationship between the tables.

Accepted Answer

A) True 
 B)False

Question 14

The fields and data types in an Append query must _____.

Accepted Answer

A)  be identical 
B)  be different from the fields and data types in the target table 
C)  be different from one another 
D)  match the fields and data types in the target table 
A)  be identical 
B)  be different from the fields and data types in the target table 
C)  be different from one another 
D)  match the fields and data types in the target table

Question 15

What type of query should you create if you want to change a manager's name from "Jones" to "Ames" for all selected records?

Accepted Answer

A)  Update 
B)  Select with self join 
C)  Is Null 
D)  Append 
A)  Update 
B)  Select with self join 
C)  Is Null 
D)  Append

Question 16

A join line is also called a _____ line.

Accepted Answer

A)  query 
B)  connection 
C)  link 
D)  property 
A)  query 
B)  connection 
C)  link 
D)  property

Question 17

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 18

The purpose of a Delete query is to _____.

Accepted Answer

A)  delete fields from a table 
B)  correct errors in table records 
C)  delete records from a table 
D)  move records to a backup table 
A)  delete fields from a table 
B)  correct errors in table records 
C)  delete records from a table 
D)  move records to a backup table

Question 19

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 20

After running a Delete query, you cannot _____.

Accepted Answer

A)  run another action query 
B)  undo the deletions 
C)  view the table with the deleted records 
D)  save the query 
A)  run another action query 
B)  undo the deletions 
C)  view the table with the deleted records 
D)  save the query

All the fields selected in a(n) _____ query must match fields with the same data types in the target table.

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

If you set the _____ property for a field that is often used for sorting, you improve database performance.

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

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.

An action query, such as a Make-Table query, selects and changes all of the selected data when you run it.

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

Which of the following could you use to export records to a new table?

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

To view all the indexes in a table at the same time, use the Indexes button in Table Design view.

If you want to export records to another Access database, create a Top Values query.

If you are creating a query using fields from two related tables, the join line Identifies which fields establish a relationship between the tables.

The fields and data types in an Append query must _____.

What type of query should you create if you want to change a manager's name from "Jones" to "Ames" for all selected records?

A join line is also called a _____ line.

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

The purpose of a Delete query is to _____.

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

After running a Delete query, you cannot _____.

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

All the fields selected in a(n) _____ query must match fields with the same data types in the target table.

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

If you set the _____ property for a field that is often used for sorting, you improve database performance.

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

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.

An action query, such as a Make-Table query, selects and changes all of the selected data when you run it.

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

Which of the following could you use to export records to a new table?

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

To view all the indexes in a table at the same time, use the Indexes button in Table Design view.

If you want to export records to another Access database, create a Top Values query.

If you are creating a query using fields from two related tables, the join line Identifies which fields establish a relationship between the tables.

The fields and data types in an Append query must _____.

What type of query should you create if you want to change a manager's name from "Jones" to "Ames" for all selected records?

A join line is also called a _____ line.

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

The purpose of a Delete query is to _____.

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

After running a Delete query, you cannot _____.

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