Question 1

Using an Append query,you can append a Short Text field from one table to a Number field in another table.

Accepted Answer

A) True 
 B)False

Question 2

When building an action query,you do not change data until you click the _____ button.

Accepted Answer

A)  Update 
B)  Select 
C)  Run 
D)  View 
A)  Update 
B)  Select 
C)  Run 
D)  View

Question 3

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 4

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.

Question 5

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

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

Accepted Answer

A) True 
 B)False

Question 8

After setting up a Delete query,you delete selected records by clicking the _____ button.

Accepted Answer

A)  Delete 
B)  Run 
C)  View 
D)  Select 
A)  Delete 
B)  Run 
C)  View 
D)  Select

Question 9

A Make-Table query is a type of _____.

Accepted Answer

A)  select query 
B)  parameters query 
C)  action query 
D)  crosstab query 
A)  select query 
B)  parameters query 
C)  action query 
D)  crosstab query

Question 10

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 11

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

Accepted Answer

A)  right inner 
B)  orphan outer 
C)  select inner 
D)  right outer 
A)  right inner 
B)  orphan outer 
C)  select inner 
D)  right outer

Question 12

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 13

A(n)_____ query changes the values in a field.

Accepted Answer

A)  Make-Table 
B)  Append 
C)  Update 
D)  Change Value 
A)  Make-Table 
B)  Append 
C)  Update 
D)  Change Value

Question 14

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 15

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

Accepted Answer

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

Question 16

How do you specify an outer join between two tables?

Accepted Answer

A)  In the Relationships window,click the Modify Join button. 
B)  In Query Design View,double-click the join line. 
C)  Add the "outer" criterion to the query design grid. 
D)  Change the order of the fields in the query design grid. 
A)  In the Relationships window,click the Modify Join button. 
B)  In Query Design View,double-click the join line. 
C)  Add the "outer" criterion to the query design grid. 
D)  Change the order of the fields in the query design grid.

Using an Append query,you can append a Short Text field from one table to a Number field in another table.

When building an action query,you do not change data until you click the _____ button.

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

Which of the following are ways to add records to an existing table? 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?

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

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

After setting up a Delete query,you delete selected records by clicking the _____ button.

A Make-Table query is a type of _____.

A join line is also called a _____ line.

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

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

A(n)_____ query changes the values in a field.

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

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

How do you specify an outer join between two tables?

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

Using an Append query,you can append a Short Text field from one table to a Number field in another table.

When building an action query,you do not change data until you click the _____ button.

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

Which of the following are ways to add records to an existing table? 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?

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

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

After setting up a Delete query,you delete selected records by clicking the _____ button.

A Make-Table query is a type of _____.

A join line is also called a _____ line.

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

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

A(n)_____ query changes the values in a field.

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

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

How do you specify an outer join between two tables?

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