Question 1

Find unmatched queries provide a subset of the data that answers most questions that users ask about the data in their databases.

Accepted Answer

A) True 
 B)False

Question 2

A(n)________ query provides the easiest way to move records from one table to another.

Accepted Answer

The answer of A(n)________ query provides the easiest way to...

Question 3

An append query selects records from one or more tables and uses then to create a new table.

Accepted Answer

A) True 
 B)False

Question 4

Match between columns
                        Premises: crosstab query
action query
find duplicate query
find unmatched query

Accepted Answer

The Answer of adds,edits,or deletes data in a database and is...

Question 5

Before running a make table query,what should you do?

Accepted Answer

A)  Preview the datasheet to verify that the records are those that you intend to insert into the table.
B)  View the results in Design view.
C)  Create the table,you can always delete it if the information is wrong.
D)  Create a delete query at the same time.

Question 6

Duplicate values should always be deleted from a database table.

Accepted Answer

A) True 
 B)False

Question 7

To remove the duplicate records found in a table,you would run a(n)________ query.

Accepted Answer

The answer of To remove the duplicate records found in...

Question 8

A find duplicates query compares records in two related tables and displays the values found in one table but not the other.

Accepted Answer

A) True 
 B)False

Question 9

To test an update query before running the query,what should you do first?

Accepted Answer

A)  From Design view,click View in the Results group and click Datasheet view.
B)  From Design view,click the Run button.
C)  From Design view,verify that all fields are listed.
D)  From Design view,click Update in the Query type group.

Question 10

Where do the column headings display in a crosstab query?

Accepted Answer

A)  Along the top of a crosstab query
B)  Along the left side of a crosstab query
C)  Along the right side of a crosstab query
D)  Along the bottom of a crosstab query

Question 11

Why should you backup your database before running an action query?

Accepted Answer

A)  Action queries are irreversible.
B)  Action queries are reversible.
C)  Action queries are temporary.
D)  Action queries add extra tables to the database.

Question 12

Once you run an action query,you are committing yourself to an irreversible change.

Accepted Answer

A) True 
 B)False

Question 13

The grouping in a crosstab query comes from the definitions of row and column headings.

Accepted Answer

A) True 
 B)False

Question 14

What is the purpose of a crosstab query?

Accepted Answer

A crosstab query is ...

Question 15

Action queries include update,append,make table,and delete.

Accepted Answer

A) True 
 B)False

Question 16

Match between columns
                        Premises: make table query
update query
append query
delete query

Accepted Answer

The Answer of adds records to an existing table and is...

Question 17

How is a crosstab query different from other queries?

Accepted Answer

A)  You can only reference one object (table or query) as the data source
B)  You can use records from several objects in a crosstab query
C)  You can preview the data before finalizing the query
D)  You can select a data source with several grouping fields

Question 18

When running an append query,the data types of the source fields do not have to match the data types of the destination fields.

Accepted Answer

A) True 
 B)False

Question 19

An append query is used to update or change data automatically based on criteria that you specify.

Accepted Answer

A) True 
 B)False

Question 20

What summarizes a data source into a grid of rows and columns?

Accepted Answer

A)  Crosstab query
B)  Append query
C)  Make table query
D)  Find duplicates table

Exam 14: Action and Specialized Queries: Moving Beyond the Select Query

Find unmatched queries provide a subset of the data that answers most questions that users ask about the data in their databases.

Correct Answer
verified

What summarizes a data source into a grid of rows and columns?

Correct Answer
verified

Why should you backup your database before running an action query?

Correct Answer
verified

Duplicate values should always be deleted from a database table.

Correct Answer
verified

Match the following terms with their meanings:

An append query is used to update or change data automatically based on criteria that you specify.

Correct Answer
verified

To test an update query before running the query,what should you do first?

Correct Answer
verified

An append query selects records from one or more tables and uses then to create a new table.

Correct Answer
verified

Once you run an action query,you are committing yourself to an irreversible change.

Correct Answer
verified

The grouping in a crosstab query comes from the definitions of row and column headings.

Correct Answer
verified

Where do the column headings display in a crosstab query?

Correct Answer
verified

A(n)________ query provides the easiest way to move records from one table to another.

Correct Answer
verified

Action queries include update,append,make table,and delete.

Correct Answer
verified

To remove the duplicate records found in a table,you would run a(n)________ query.

Correct Answer
verified

How is a crosstab query different from other queries?

Correct Answer
verified

Match the following terms with their meanings:

When running an append query,the data types of the source fields do not have to match the data types of the destination fields.

Correct Answer
verified

Before running a make table query,what should you do?

Correct Answer
verified

A find duplicates query compares records in two related tables and displays the values found in one table but not the other.

Correct Answer
verified

What is the purpose of a crosstab query?

Correct Answer
verified
A crosstab query is ...
View Answer

Exam 14: Action and Specialized Queries: Moving Beyond the Select Query

Find unmatched queries provide a subset of the data that answers most questions that users ask about the data in their databases.

Correct AnswerverifiedShow Answer

What summarizes a data source into a grid of rows and columns?

Correct AnswerverifiedShow Answer

Why should you backup your database before running an action query?

Correct AnswerverifiedShow Answer

Duplicate values should always be deleted from a database table.

Correct AnswerverifiedShow Answer

Match the following terms with their meanings:

An append query is used to update or change data automatically based on criteria that you specify.

Correct AnswerverifiedShow Answer

To test an update query before running the query,what should you do first?

Correct AnswerverifiedShow Answer

An append query selects records from one or more tables and uses then to create a new table.

Correct AnswerverifiedShow Answer

Once you run an action query,you are committing yourself to an irreversible change.

Correct AnswerverifiedShow Answer

The grouping in a crosstab query comes from the definitions of row and column headings.

Correct AnswerverifiedShow Answer

Where do the column headings display in a crosstab query?

Correct AnswerverifiedShow Answer

A(n)________ query provides the easiest way to move records from one table to another.

Correct AnswerverifiedShow Answer

Action queries include update,append,make table,and delete.

Correct AnswerverifiedShow Answer

To remove the duplicate records found in a table,you would run a(n)________ query.

Correct AnswerverifiedShow Answer

How is a crosstab query different from other queries?

Correct AnswerverifiedShow Answer

Match the following terms with their meanings:

When running an append query,the data types of the source fields do not have to match the data types of the destination fields.

Correct AnswerverifiedShow Answer

Before running a make table query,what should you do?

Correct AnswerverifiedShow Answer

A find duplicates query compares records in two related tables and displays the values found in one table but not the other.

Correct AnswerverifiedShow Answer

What is the purpose of a crosstab query?

Correct AnswerverifiedA crosstab query is ...View AnswerShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
A crosstab query is ...
View Answer