Question 1

What is the purpose of a find unmatched query?

Accepted Answer

A)  To compare records in two related tables and display the records found in one table and not the other. 
B)  To find records that are the same in two related tables. 
C)  To combine information in one table with information in another table. 
D)  To summarize a table into columns and rows to show trends. 
A)  To compare records in two related tables and display the records found in one table and not the other. 
B)  To find records that are the same in two related tables. 
C)  To combine information in one table with information in another table. 
D)  To summarize a table into columns and rows to show trends.

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

How do appended records appear in the destination table?

Accepted Answer

They appear in primary key ord

Question 4

When running an append query,an append query warning message appears specifying the number of rows to be appended.

Accepted Answer

A) True 
 B)False

Question 5

There is no way to verify that the correct records will be updated when using an update query.

Accepted Answer

A) True 
 B)False

Question 6

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 7

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 8

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 9

What is the best precaution to take prior to running an update query?

Accepted Answer

Back up th

Question 10

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 11

It is usually better to enter the value of zero rather than have a null value in a field.

Accepted Answer

A) True 
 B)False

Question 12

Which type of query calculates data using a sum,average,or other function and groups the results by two sets of values?

Accepted Answer

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

Question 13

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 14

Access does not have a way to identify duplicate values.

Accepted Answer

A) True 
 B)False

Question 15

It is not recommended to preview the datasheet prior to running a make table query.

Accepted Answer

A) True 
 B)False

Question 16

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 17

When running an append query,what happens if a record violates the primary key rule for the destination table?

Accepted Answer

A)  The record is rejected. 
B)  The original record is selected. 
C)  The record is added without the primary key field. 
D)  The append query is rejected. 
A)  The record is rejected. 
B)  The original record is selected. 
C)  The record is added without the primary key field. 
D)  The append query is rejected.

Question 18

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 19

The ________ is responsible for maintaining databases,including performing backups,security checks,and upgrades to keep data both safe and accessible.

Accepted Answer

database a

Question 20

The type of data displayed in a crosstab query depends on which aggregate function you choose when creating the query.

Accepted Answer

A) True 
 B)False

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

What is the purpose of a find unmatched query?

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

How do appended records appear in the destination table?

When running an append query,an append query warning message appears specifying the number of rows to be appended.

There is no way to verify that the correct records will be updated when using an update query.

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

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

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

What is the best precaution to take prior to running an update query?

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

It is usually better to enter the value of zero rather than have a null value in a field.

Which type of query calculates data using a sum,average,or other function and groups the results by two sets of values?

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.

Access does not have a way to identify duplicate values.

It is not recommended to preview the datasheet prior to running a make table query.

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

When running an append query,what happens if a record violates the primary key rule for the destination table?

An append query is a query that:

The ________ is responsible for maintaining databases,including performing backups,security checks,and upgrades to keep data both safe and accessible.

The type of data displayed in a crosstab query depends on which aggregate function you choose when creating the query.

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