Question 1

A(n)________ calculates a sum,average,or other statistic and groups the results by sets of values.

Accepted Answer

crosstab query

Question 2

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

Accepted Answer

delete

Question 3

Which of the following is NOT a rule for appending queries?

Accepted Answer

A)  Data field types do not have to be the same. 
B)  All the normal rules for adding a new record to the destination table apply. 
C)  A field from the source table does not exist in the destination table. 
D)  The destination table should not contain an AutoNumber field. 
A)  Data field types do not have to be the same. 
B)  All the normal rules for adding a new record to the destination table apply. 
C)  A field from the source table does not exist in the destination table. 
D)  The destination table should not contain an AutoNumber field. A

Question 4

To find which customers have not yet ordered,you would run a(n)________ query.

Accepted Answer

The answer of To find which customers have not yet...

Question 5

Which type of query automatically creates a new table from data that already exists in a database?

Accepted Answer

A)  Make Table 
B)  Update 
C)  Append 
D)  Delete 
A)  Make Table 
B)  Update 
C)  Append 
D)  Delete

Question 6

A find unmatched query compares records in two related tables and displays the records found in both tables.

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

Backing up the database prior to running an update query is the best precaution.

Accepted Answer

A) True 
 B)False

Question 9

When running a delete query,you are prompted with a warning message.

Accepted Answer

A) True 
 B)False

Question 10

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 11

The process of creating a make table query is very similar to which other type of query?

Accepted Answer

A)  Append query 
B)  Delete query 
C)  Find duplicates query 
D)  Update query 
A)  Append query 
B)  Delete query 
C)  Find duplicates query 
D)  Update query

Question 12

What do you do if you make a mistake when running a Find Unmatched query?

Accepted Answer

A)  Delete the query and start over, then reverse the order of the tables. 
B)  Rerun the query using different fields. 
C)  Delete associated records in the table. 
D)  Modify the aggregate function. 
A)  Delete the query and start over, then reverse the order of the tables. 
B)  Rerun the query using different fields. 
C)  Delete associated records in the table. 
D)  Modify the aggregate function.

Question 13

Why is it better to enter zero in a field instead of leaving the field blank?

Accepted Answer

Access does not alwa

Question 14

A delete query automatically creates a new table from data that already exists in a database.

Accepted Answer

A) True 
 B)False

Question 15

The find unmatched query only works if two tables share a common field.

Accepted Answer

A) True 
 B)False

Question 16

Prior to updating data in a table,you must first locate the records that need to be modified.

Accepted Answer

A) True 
 B)False

Question 17

An append query deletes records from one or more tables and adds them to an existing table.

Accepted Answer

A) True 
 B)False

Question 18

What should be the first step taken before creating an update query?

Accepted Answer

A)  Back up the database 
B)  Switch to Datasheet view 
C)  Move the records to a different table 
D)  Run the query 
A)  Back up the database 
B)  Switch to Datasheet view 
C)  Move the records to a different table 
D)  Run the query

Question 19

What does the type of data displayed in a crosstab query depend on?

Accepted Answer

A)  Which aggregate function used when the query was created 
B)  The intersection of columns and rows 
C)  What the query was based on 
D)  The grouping of the data 
A)  Which aggregate function used when the query was created 
B)  The intersection of columns and rows 
C)  What the query was based on 
D)  The grouping of the data

Question 20

A(n)________ query can be used for adding records to an existing table.

Accepted Answer

A)  append 
B)  update 
C)  make table 
D)  delete 
A)  append 
B)  update 
C)  make table 
D)  delete

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

A(n)________ calculates a sum,average,or other statistic and groups the results by sets of values.

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

Which of the following is NOT a rule for appending queries?

To find which customers have not yet ordered,you would run a(n)________ query.

Which type of query automatically creates a new table from data that already exists in a database?

A find unmatched query compares records in two related tables and displays the records found in both tables.

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

Backing up the database prior to running an update query is the best precaution.

When running a delete query,you are prompted with a warning message.

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

The process of creating a make table query is very similar to which other type of query?

What do you do if you make a mistake when running a Find Unmatched query?

Why is it better to enter zero in a field instead of leaving the field blank?

A delete query automatically creates a new table from data that already exists in a database.

The find unmatched query only works if two tables share a common field.

Prior to updating data in a table,you must first locate the records that need to be modified.

An append query deletes records from one or more tables and adds them to an existing table.

What should be the first step taken before creating an update query?

What does the type of data displayed in a crosstab query depend on?

A(n)________ query can be used for adding records to an existing table.

Introduction to Access: Hands-On-Exercise Videos

Tables and Queries in Relational Databases: Hands-On-Exercise Videos

Customize, analyze, and Summarize Query Data: Hands-On-Exercise Videos

Creating and Using Professional Forms and Reports: Hands-On-Exercise Videos

Data Validation and Data Analysis: Hands-On-Exercise Videos

Action and Specialized Queries: Hands-On-Exercise Videos

Advanced Forms and Reports: Hands-On-Exercise Videos

Get Connected: Hands-On-Exercise Videos

Fine-Tuning the Database: Hands-On-Exercise Videos

Using Macros and SQL in Access: Hands-On-Exercise Videos

Introduction to Access: Finding Your Way Through an Access Database

Office Fundamentals and File Management: Hands-On-Exercise Videos

Office Fundamentals and File Management

Tables and Queries in Relational Databases: Designing Databases and Extracting Data

Customize, analyze, and Summarize Query Data: Creating and Using Queries to Make Decisions

Creating and Using Professional Forms and Reports: Moving Beyond Tables and Queries

Data Validation and Data Analysis: Reducing Errors and Extracting Better Information

Advanced Forms and Reports: Moving Beyond the Basics

Get Connected: Exchanging Data Between Access and Other Applications

Fine-Tuning the Database: Analyzing and Improving Database Performance

Using Macros and SQL in Access: Advanced Techniques

Filters