Question 1

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

Accepted Answer

A) True 
 B)False  False

Question 2

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

Accepted Answer

A) True 
 B)False  False

Question 3

After becoming familiar with the data in a database, what should be the first step when creating an action query?

Accepted Answer

A)  Backup the database 
B)  Save the database in an earlier version 
C)  Using design view, create the query 
D)  Run the query 
A)  Backup the database 
B)  Save the database in an earlier version 
C)  Using design view, create the query 
D)  Run the query A

Question 4

Why should you backup your database before testing an action query?

Accepted Answer

A)  Action queries change data in your database that cannot be reversed. 
B)  Action queries change data in your database but the changes are temporary. 
C)  Action queries do not make any changes to your database. 
D)  Action queries duplicate data in your database. 
A)  Action queries change data in your database that cannot be reversed. 
B)  Action queries change data in your database but the changes are temporary. 
C)  Action queries do not make any changes to your database. 
D)  Action queries duplicate data in your database.

Question 5

You use a ________ query to select records of former employees from a table and use them to create a new table.

Accepted Answer

A)  create table 
B)  merge tables 
C)  combine tables 
D)  make table 
A)  create table 
B)  merge tables 
C)  combine tables 
D)  make table

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

You should NOT rerun an action query.

Accepted Answer

A) True 
 B)False

Question 8

An append query selects records from one or more tables and uses then to create a new table.

Accepted Answer

A) True 
 B)False

Question 9

You would use a(n) ________ query to identify records of all customers who live in Tennessee in order to change their area code to a new number.

Accepted Answer

The answer of You would use a(n) ________ query to...

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

Back up th

Question 12

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

Question 13

What is the purpose of a crosstab query?

Accepted Answer

A crosstab query is

Question 14

A purge query is used to remove records from a table.

Accepted Answer

A) True 
 B)False

Question 15

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 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 is used to update or change data automatically based on criteria that you specify.

Accepted Answer

A) True 
 B)False

Question 18

Why is it important to monitor how many times an update query is executed?

Accepted Answer

Because update queri

Question 19

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 20

What is the first step in creating an append query?

Accepted Answer

A)  Create a select query 
B)  Create a make table query 
C)  Create a delete query 
D)  Create a find duplicates query 
A)  Create a select query 
B)  Create a make table query 
C)  Create a delete query 
D)  Create a find duplicates query

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

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

After becoming familiar with the data in a database, what should be the first step when creating an action query?

Why should you backup your database before testing an action query?

You use a ________ query to select records of former employees from a table and use them to create a new table.

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

You should NOT rerun an action query.

An append query selects records from one or more tables and uses then to create a new table.

You would use a(n) ________ query to identify records of all customers who live in Tennessee in order to change their area code to a new number.

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

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

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

What is the purpose of a crosstab query?

A purge query is used to remove records from a table.

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

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

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

Why is it important to monitor how many times an update query is executed?

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

What is the first step in creating an append query?

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

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

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

After becoming familiar with the data in a database, what should be the first step when creating an action query?

Why should you backup your database before testing an action query?

You use a ________ query to select records of former employees from a table and use them to create a new table.

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

You should NOT rerun an action query.

An append query selects records from one or more tables and uses then to create a new table.

You would use a(n) ________ query to identify records of all customers who live in Tennessee in order to change their area code to a new number.

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

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

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

What is the purpose of a crosstab query?

A purge query is used to remove records from a table.

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

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

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

Why is it important to monitor how many times an update query is executed?

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

What is the first step in creating an append query?

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