Question 1

An append query is used to add records to an existing table.

Accepted Answer

A) True 
 B)False

Question 2

A make table query selects records from one or more tables and uses them to create a new table.

Accepted Answer

A) True 
 B)False

Question 3

You would use a(n) ________ query to make changes to the retail price field for records meeting a specified criteria.

Accepted Answer

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

Question 4

Access does not have a way to identify duplicate values.

Accepted Answer

A) True 
 B)False

Question 5

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 
A)  Crosstab query 
B)  Append query 
C)  Make table query 
D)  Find duplicates table

Question 6

Delete, append, and update queries are all examples of a(n) ________ query.

Accepted Answer

The answer of Delete, append, and update queries are all...

Question 7

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

Accepted Answer

Access does not alwa

Question 8

The field names that display on the left side of a crosstab query are called ________.

Accepted Answer

The answer of The field names that display on the...

Question 9

What are the four types of action queries?

Accepted Answer

update query, append

Question 10

You should back up your database before testing an action query.

Accepted Answer

A) True 
 B)False

Question 11

Match the following terms with their meanings:
I. crosstab query
II. find duplicate query
III. find unmatched query
IV. action query
A. helps identify duplicate values in a table
B. usually created to show trends in values over time
C. adds, edits, or deletes data in a database
D. compares records in two related tables and displays the records found in one table but not the other

Accepted Answer

The answer of Match the following terms with their meanings:
I....

Question 12

Choosing the wrong matched field in an unmatched query will cause you to query incorrect information.

Accepted Answer

A) True 
 B)False

Question 13

A(n) ________ query is used to copy new employee records from one table and add them to an existing table.

Accepted Answer

A)  make table 
B)  append 
C)  select 
D)  dispose 
A)  make table 
B)  append 
C)  select 
D)  dispose

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

One reason an append query can fail is because of duplicate primary keys in the source and destination tables.

Accepted Answer

A) True 
 B)False

Question 16

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 17

The field names that display at the top of a crosstab query are called ________.

Accepted Answer

The answer of The field names that display at the...

Question 18

You CANNOT edit a crosstab query.

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

The answer of A(n) ________ calculates a sum, average, or...

Question 20

It is important to ensure that when you delete duplicate records, you do not delete associated records in a related table.

Accepted Answer

A) True 
 B)False

An append query is used to add records to an existing table.

A make table query selects records from one or more tables and uses them to create a new table.

You would use a(n) ________ query to make changes to the retail price field for records meeting a specified criteria.

Access does not have a way to identify duplicate values.

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

Delete, append, and update queries are all examples of a(n) ________ query.

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

The field names that display on the left side of a crosstab query are called ________.

What are the four types of action queries?

You should back up your database before testing an action query.

Choosing the wrong matched field in an unmatched query will cause you to query incorrect information.

A(n) ________ query is used to copy new employee records from one table and add them to an existing table.

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

One reason an append query can fail is because of duplicate primary keys in the source and destination tables.

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

The field names that display at the top of a crosstab query are called ________.

You CANNOT edit a crosstab query.

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

It is important to ensure that when you delete duplicate records, you do not delete associated records in a related table.

Introduction to Access: Finding Your Way Through an Access Database

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 Sqlin Access: Advanced Techniques

Office Fundamentals and File Management

Filters

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

An append query is used to add records to an existing table.

A make table query selects records from one or more tables and uses them to create a new table.

You would use a(n) ________ query to make changes to the retail price field for records meeting a specified criteria.

Access does not have a way to identify duplicate values.

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

Delete, append, and update queries are all examples of a(n) ________ query.

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

The field names that display on the left side of a crosstab query are called ________.

What are the four types of action queries?

You should back up your database before testing an action query.

Choosing the wrong matched field in an unmatched query will cause you to query incorrect information.

A(n) ________ query is used to copy new employee records from one table and add them to an existing table.

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

One reason an append query can fail is because of duplicate primary keys in the source and destination tables.

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

The field names that display at the top of a crosstab query are called ________.

You CANNOT edit a crosstab query.

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

It is important to ensure that when you delete duplicate records, you do not delete associated records in a related table.

Introduction to Access: Finding Your Way Through an Access Database

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 Sqlin Access: Advanced Techniques

Office Fundamentals and File Management

Filters