Question 1

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 B

Question 2

Table Design view shows how each table relates to other tables in the database.

Accepted Answer

A) True 
 B)False  False

Question 3

Which of the following statements describe OR criteria? Select all the options that apply.

Accepted Answer

A)  You enter OR criteria on different rows of the query design grid. 
B)  You use OR criteria when any one criterion must be true to select a record. 
C)  As you add OR criteria to a query,you increase the number of records in the resulting datasheet. 
D)  You use OR criteria when all of the criteria must be true to select a record. 
A)  You enter OR criteria on different rows of the query design grid. 
B)  You use OR criteria when any one criterion must be true to select a record. 
C)  As you add OR criteria to a query,you increase the number of records in the resulting datasheet. 
D)  You use OR criteria when all of the criteria must be true to select a record. A,B,C

Question 4

Which of the following join types can you create by double-clicking a join line in Query Design View? Select all the options that apply.

Accepted Answer

A)  right outer 
B)  left outer 
C)  inner 
D)  upper 
A)  right outer 
B)  left outer 
C)  inner 
D)  upper

Question 5

In a datasheet,which mode do you use for changing the value of a field?

Accepted Answer

A)  Update mode 
B)  Navigation mode 
C)  Edit mode 
D)  Modify mode 
A)  Update mode 
B)  Navigation mode 
C)  Edit mode 
D)  Modify mode

Question 6

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 7

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 8

Delete queries delete entire records,not just selected fields within records.

Accepted Answer

A) True 
 B)False

Question 9

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 10

Which action query would you use if you wanted to add records from one table to a backup table?

Accepted Answer

A)  Append query 
B)  Delete query 
C)  Backup query 
D)  Update query 
A)  Append query 
B)  Delete query 
C)  Backup query 
D)  Update query

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

The outer join is the default join operation in Access.

Accepted Answer

A) True 
 B)False

Question 13

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 14

AND criteria means that all criteria must be true to select a record.

Accepted Answer

A) True 
 B)False

Question 15

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

Question 16

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 17

_____ criteria are two or more criteria on the same Criteria row of the query design grid.

Accepted Answer

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

Question 18

If you want to find records in the table on the "one" side of a one-to-many relationship that do not have related records in the "many" side,which join do you use?

Accepted Answer

A)  inner 
B)  self 
C)  left outer 
D)  cascade updates 
A)  inner 
B)  self 
C)  left outer 
D)  cascade updates

Question 19

To create an Update query in Query Design view,you use the Add to row in the query design grid.

Accepted Answer

A) True 
 B)False

Question 20

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

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

Table Design view shows how each table relates to other tables in the database.

Which of the following statements describe OR criteria? Select all the options that apply.

Which of the following join types can you create by double-clicking a join line in Query Design View? Select all the options that apply.

In a datasheet,which mode do you use for changing the value of a field?

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

The purpose of a Delete query is to _____.

Delete queries delete entire records,not just selected fields within records.

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

Which action query would you use if you wanted to add records from one table to a backup table?

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

The outer join is the default join operation in Access.

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

AND criteria means that all criteria must be true to select a record.

After running a Delete query,you cannot _____.

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

_____ criteria are two or more criteria on the same Criteria row of the query design grid.

If you want to find records in the table on the "one" side of a one-to-many relationship that do not have related records in the "many" side,which join do you use?

To create an Update query in Query Design view,you use the Add to row in the query design grid.

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

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

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

Table Design view shows how each table relates to other tables in the database.

Which of the following statements describe OR criteria? Select all the options that apply.

Which of the following join types can you create by double-clicking a join line in Query Design View? Select all the options that apply.

In a datasheet,which mode do you use for changing the value of a field?

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

The purpose of a Delete query is to _____.

Delete queries delete entire records,not just selected fields within records.

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

Which action query would you use if you wanted to add records from one table to a backup table?

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

The outer join is the default join operation in Access.

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

AND criteria means that all criteria must be true to select a record.

After running a Delete query,you cannot _____.

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

_____ criteria are two or more criteria on the same Criteria row of the query design grid.

If you want to find records in the table on the "one" side of a one-to-many relationship that do not have related records in the "many" side,which join do you use?

To create an Update query in Query Design view,you use the Add to row in the query design grid.

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

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