Question 1

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 A

Question 2

Which of the following are ways to add records to an existing table? Select all the options that apply.

Accepted Answer

A)  Enter records in Query Design View. 
B)  Import records from an Excel workbook. 
C)  Enter records directly in the datasheet. 
D)  Run an Append query to add records from another table. 
A)  Enter records in Query Design View. 
B)  Import records from an Excel workbook. 
C)  Enter records directly in the datasheet. 
D)  Run an Append query to add records from another table. B, C, D

Question 3

If you want to increase the price of products in a particular category by 10%, use a(n) Append query.

Accepted Answer

False - Update
False - update
False - UPDATE

Question 4

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

Accepted Answer

The answer of AND criteria means that all criteria must...

Question 5

You enter _____ criteria on the same row of the query design grid.

Accepted Answer

A)  NOT 
B)  AND 
C)  TEXT 
D)  OR 
A)  NOT 
B)  AND 
C)  TEXT 
D)  OR

Question 6

_____ criteria are two or more criteria on different Criteria rows of the query design grid.

Accepted Answer

A)  AND 
B)  OR 
C)  SHOW 
D)  SELECT 
A)  AND 
B)  OR 
C)  SHOW 
D)  SELECT

Question 7

A(n) self join selects all the records from the "one" table regardless of whether there is a related record in the "many" table.

Accepted Answer

False - ou

Question 8

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.

Question 9

When you click the Delete button in the Query Type group, Access adds the Update row to the query design grid.

Accepted Answer

False - De

Question 10

To enter data in a table, open it in Table Datasheet view.

Accepted Answer

A) True 
 B)False

Question 11

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 12

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 13

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 14

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

Accepted Answer

A) True 
 B)False

Question 15

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 16

In a database with a Products table and Orders table, you want to see which products have not been ordered. What type of query should you create?

Accepted Answer

A)  Select query with a self join. 
B)  Update query. 
C)  Select query with an outer join. 
D)  Append query. 
A)  Select query with a self join. 
B)  Update query. 
C)  Select query with an outer join. 
D)  Append query.

Question 17

_____ 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 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

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

Accepted Answer

A) True 
 B)False

Question 20

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

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

Which of the following are ways to add records to an existing table? Select all the options that apply.

If you want to increase the price of products in a particular category by 10%, use a(n) Append query.

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

You enter _____ criteria on the same row of the query design grid.

_____ criteria are two or more criteria on different Criteria rows of the query design grid.

A(n) self join selects all the records from the "one" table regardless of whether there is a related record in the "many" table.

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

When you click the Delete button in the Query Type group, Access adds the Update row to the query design grid.

To enter data in a table, open it in Table Datasheet view.

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

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.

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

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

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

In a database with a Products table and Orders table, you want to see which products have not been ordered. What type of query should you create?

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

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

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

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

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

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

Which of the following are ways to add records to an existing table? Select all the options that apply.

If you want to increase the price of products in a particular category by 10%, use a(n) Append query.

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

You enter _____ criteria on the same row of the query design grid.

_____ criteria are two or more criteria on different Criteria rows of the query design grid.

A(n) self join selects all the records from the "one" table regardless of whether there is a related record in the "many" table.

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

When you click the Delete button in the Query Type group, Access adds the Update row to the query design grid.

To enter data in a table, open it in Table Datasheet view.

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

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.

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

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

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

In a database with a Products table and Orders table, you want to see which products have not been ordered. What type of query should you create?

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

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

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

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

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