Question 1

You can use Undo when running an update or delete query.

Accepted Answer

A) True 
 B)False

Question 2

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.

Question 3

You would use a find duplicates query to find the same values in a table.

Accepted Answer

A) True 
 B)False

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

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

Question 6

A(n) ________ query can be used to archive older records that need to be stored outside of the current table.

Accepted Answer

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

Question 7

When updating records, convert the select query to an update query and insert the missing information.

Accepted Answer

A) True 
 B)False

Question 8

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 9

While reviewing a table, you find that the same customer was added to the customers table twice, you decide to run a(n) ________ query to determine if there are any other records added multiple times.

Accepted Answer

The answer of While reviewing a table, you find that...

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

Moving records from one table to another can be accomplished with the combination of an append query and a delete query.

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

The Answer of creates a new table from data that is...

Question 13

Duplicate values should always be deleted from a database table.

Accepted Answer

A) True 
 B)False

Question 14

What is the difference between an update query and an append query?

Accepted Answer

An append query adds records t

Question 15

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 16

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

Accepted Answer

A) True 
 B)False

You can use Undo when running an update or delete query.

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

You would use a find duplicates query to find the same values in a table.

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

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

A(n) ________ query can be used to archive older records that need to be stored outside of the current table.

When updating records, convert the select query to an update query and insert the missing information.

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

While reviewing a table, you find that the same customer was added to the customers table twice, you decide to run a(n) ________ query to determine if there are any other records added multiple times.

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

Moving records from one table to another can be accomplished with the combination of an append query and a delete query.

Duplicate values should always be deleted from a database table.

What is the difference between an update query and an append query?

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

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

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

You can use Undo when running an update or delete query.

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

You would use a find duplicates query to find the same values in a table.

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

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

A(n) ________ query can be used to archive older records that need to be stored outside of the current table.

When updating records, convert the select query to an update query and insert the missing information.

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

While reviewing a table, you find that the same customer was added to the customers table twice, you decide to run a(n) ________ query to determine if there are any other records added multiple times.

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

Moving records from one table to another can be accomplished with the combination of an append query and a delete query.

Duplicate values should always be deleted from a database table.

What is the difference between an update query and an append query?

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

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

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