Question 1

The delete query saves you the chore of having to locate and delete records manually.

Accepted Answer

A) True 
 B)False

Question 2

A(n) ________ query is used to display aggregate data in a row-and-column layout.

Accepted Answer

A)  summary 
B)  crosstab 
C)  action 
D)  outline 
A)  summary 
B)  crosstab 
C)  action 
D)  outline

Question 3

How do appended records appear in the destination table?

Accepted Answer

They appear in primary key ord

Question 4

A crosstab query works best when the data source has at least two grouping fields.

Accepted Answer

A) True 
 B)False

Question 5

To avoid a mistake when using an update query that includes making calculations on a field, what is one thing you can do to prevent losing the original information?

Accepted Answer

A)  Add an additional field with the original figures. 
B)  When you run the query, just undo if you question the new figures. 
C)  Rerun the query to make sure the figures have updated. 
D)  Backup the database after you have run the query. 
A)  Add an additional field with the original figures. 
B)  When you run the query, just undo if you question the new figures. 
C)  Rerun the query to make sure the figures have updated. 
D)  Backup the database after you have run the query.

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

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

What should you do before running a delete query?

Accepted Answer

Create a backup copy

Question 9

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 10

Before running a delete query, what should you do?

Accepted Answer

A)  Preview the datasheet to verify that the records are those that you intend to delete. 
B)  View the results in Design view. 
C)  Create the table, you can always delete it if the information is wrong. 
D)  Manually go through the table and delete the information, then use the delete query to verify all information is removed. 
A)  Preview the datasheet to verify that the records are those that you intend to delete. 
B)  View the results in Design view. 
C)  Create the table, you can always delete it if the information is wrong. 
D)  Manually go through the table and delete the information, then use the delete query to verify all information is removed.

Question 11

A(n) ________ would be used to replace null values with zeros?

Accepted Answer

A)  update query 
B)  make table query 
C)  append query 
D)  delete query 
A)  update query 
B)  make table query 
C)  append query 
D)  delete 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

An action query can be used to add, edit, or delete data in a database.

Accepted Answer

A) True 
 B)False

Question 14

An append query is a query that:

Accepted Answer

A)  copies records from one table to another. 
B)  changes the data values in one or more fields that meet specific criteria. 
C)  automatically creates a new table from data that already exists. 
D)  removes records from a table based on criteria. 
A)  copies records from one table to another. 
B)  changes the data values in one or more fields that meet specific criteria. 
C)  automatically creates a new table from data that already exists. 
D)  removes records from a table based on criteria.

Question 15

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

An append query changes the data values in one or more fields for all records that meet specific criteria.

Accepted Answer

A) True 
 B)False

Question 17

You can use a make table query to copy some or all records from a source table to a destination table even if the destination table does not exist.

Accepted Answer

A) True 
 B)False

Question 18

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

A(n) ________ can be used when records with missing data have been found.

Accepted Answer

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

Question 20

Moving records from one table to another can be accomplished with the combination of what two types of queries?

Accepted Answer

A)  Append and delete 
B)  Append and make table 
C)  Append and select 
D)  Append and update 
A)  Append and delete 
B)  Append and make table 
C)  Append and select 
D)  Append and update

The delete query saves you the chore of having to locate and delete records manually.

A(n) ________ query is used to display aggregate data in a row-and-column layout.

How do appended records appear in the destination table?

A crosstab query works best when the data source has at least two grouping fields.

To avoid a mistake when using an update query that includes making calculations on a field, what is one thing you can do to prevent losing the original information?

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

Where do the column headings display in a crosstab query?

What should you do before running a delete query?

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

Before running a delete query, what should you do?

A(n) ________ would be used to replace null values with zeros?

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

An action query can be used to add, edit, or delete data in a database.

An append query is a query that:

How is a crosstab query different from other queries?

An append query changes the data values in one or more fields for all records that meet specific criteria.

You can use a make table query to copy some or all records from a source table to a destination table even if the destination table does not exist.

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

A(n) ________ can be used when records with missing data have been found.

Moving records from one table to another can be accomplished with the combination of what two types of queries?

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

The delete query saves you the chore of having to locate and delete records manually.

A(n) ________ query is used to display aggregate data in a row-and-column layout.

How do appended records appear in the destination table?

A crosstab query works best when the data source has at least two grouping fields.

To avoid a mistake when using an update query that includes making calculations on a field, what is one thing you can do to prevent losing the original information?

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

Where do the column headings display in a crosstab query?

What should you do before running a delete query?

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

Before running a delete query, what should you do?

A(n) ________ would be used to replace null values with zeros?

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

An action query can be used to add, edit, or delete data in a database.

An append query is a query that:

How is a crosstab query different from other queries?

An append query changes the data values in one or more fields for all records that meet specific criteria.

You can use a make table query to copy some or all records from a source table to a destination table even if the destination table does not exist.

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

A(n) ________ can be used when records with missing data have been found.

Moving records from one table to another can be accomplished with the combination of what two types of queries?

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