Question 1

To create a query that includes a customer and the products that the customer has purchased would require you to create a(n)________.

Accepted Answer

This requires matching data from two tables, the customer table and the products table. An inner join will match only the customers who have made purchases and display the products they have purchased.

Question 2

Which of the following is NOT a characteristic of the Unmatched Query Wizard?

Accepted Answer

This statement is not true as you can also manually create an unmatched records query without using the Unmatched Query Wizard.

Question 3

Which of the following is NOT true regarding complex update queries?

Accepted Answer

The statement that the data types for both the source and destination fields must match and be compatible is NOT true. Access can convert the data types of fields in the destination table if they are compatible with the source data type.

Question 4

An action query is a query that makes changes to records or moves many records from one table to another.

Accepted Answer

An action query is designed to alter data in some way, either by modifying existing records or creating and deleting records.

Question 5

Which of the following is NOT true about using the Cascade Update and Cascade Delete Related Records property in the Relationships window?

Accepted Answer

When you set the Cascade Update Related Records property, Access only updates the related records in all related tables, it does not delete them. Option B is the statement that is not true.

Question 6

Which of the following is NOT a reason to cleanse data within your database?

Accepted Answer

Removing newer data from the database completely is not a reason for cleansing data. The other three options are valid reasons for data cleansing.

Question 7

You can use a(n)________ query to delete data in one or more fields in a database.However,to delete entire records,including the primary key value that makes the record unique,you can use a(n)________ query.

Accepted Answer

An update query is used to modify data in one or more fields, while a delete query is used to remove entire records from a database.

Question 8

To create a query that includes all customers and only the products that have been purchased would require you to create a(n)________.

Accepted Answer

The answer of To create a query that includes all...

Question 9

Perhaps an employee no longer works at the salon and there are dozens of future appointments that need to be changed to a different employee's name.You could create a(n)________ that changes the name of the employee for all future appointments from the employee who left to the a employee.

Accepted Answer

An update query is used to modify existing data. In this scenario, an update query can be used to update the employee name for all future appointments from the employee who left to the new employee. The other options are not suitable for this scenario - a make table query creates a new table from existing data, a delete query is used to permanently remove data, and an append query adds new data to an existing table.

Question 10

Which of the following is NOT true regarding query joins?

Accepted Answer

Tables that are joined in a saved query do not automatically save to the Relationships window. This is a separate step that must be taken if you want to establish a permanent relationship between the tables.

Question 11

________ is a process where the delete query will remove data that is not useful or needed anymore.

Accepted Answer

The process described in the question is data cleansing, which involves identifying and removing irrelevant, inaccurate, or outdated data from a database. Cascade update and cascade delete refer to specific types of database operations related to maintaining data integrity between related tables. Data mining involves analyzing large datasets in order to discover patterns and insights. None of these options directly involve removing data that is no longer needed or useful.

Question 12

Which of the following is NOT true regarding simple update queries?

Accepted Answer

The data types for each table field do not necessarily need to match in a simple update query. As long as the data being updated can be converted to the data type of the field being updated, the query will work.

Question 13

Action queries permanently modify the data in tables,but you can undo the changes to your data if you change your mind.

Accepted Answer

You can undo the changes made by action queries by using the Undo command or restoring a backup of your database.

Question 14

Which of the following is NOT true regarding outer joins?

Accepted Answer

Option B is not true because it describes how to create an inner join, while the question asks for a statement that is not true about outer joins. The other options are all true statements about outer joins.

Question 15

Which of the following is NOT a factor to consider when running a delete query?

Accepted Answer

In a many-to-many relationship, you typically need to delete the relationship first before running a delete query on the data, not after.

Question 16

Which of the following is NOT true regarding simple delete queries?

Accepted Answer

The number of rows deleted is not dependent upon the criteria within the Having clause of the delete query. The criteria for deleting specific rows is usually specified within the Where clause of the delete query.

Question 17

If you are working in your employee database and you accidently delete three employee records,which also removed all payroll records,the best way to recover this data is ________.

Accepted Answer

The best way to recover the deleted data is to restore it from the backup database. This will ensure that all the deleted employee and payroll records are recovered accurately and without any errors. Running an update or append query may not be effective in this situation, as they are designed to modify existing data, not recover deleted records. Physically re-entering the data is also not a recommended option as it is time-consuming and there is a risk of errors being introduced during the process.

Question 18

The spa manager decided to remove all coupon codes from the database that were not redeemed and have now expired.By using a(n)________,the database will remain cleansed.

Accepted Answer

A delete query will remove all the coupon codes from the database that were not redeemed and have expired, thus keeping the database clean by getting rid of unnecessary data.

Question 19

Which of the following is NOT true regarding inner joins?

Accepted Answer

This statement is not true. Multiple fields can serve as join fields, as long as they have matching values in both tables.

Question 20

Many new area codes have been created in the United States over the past few years.It would take too much time to have an employee look through each customer's data and modify the area code as needed.This is when a(n)________ query can be helpful.

Accepted Answer

An update query allows for the modification of data in a table, which is exactly what is needed in this scenario to update the area code for customers with the new area codes. This can be done efficiently without having to manually look through each customer's data.

Quiz 8: Workshop 8: Action Queries and Advanced Relationships

To create a query that includes a customer and the products that the customer has purchased would require you to create a(n) ________.

Which of the following is NOT a characteristic of the Unmatched Query Wizard?

Which of the following is NOT true regarding complex update queries?

An action query is a query that makes changes to records or moves many records from one table to another.

Which of the following is NOT true about using the Cascade Update and Cascade Delete Related Records property in the Relationships window?

Which of the following is NOT a reason to cleanse data within your database?

You can use a(n) query to delete data in one or more fields in a database.However,to delete entire records,including the primary key value that makes the record unique,you can use a(n) query.

To create a query that includes all customers and only the products that have been purchased would require you to create a(n) ________.

Perhaps an employee no longer works at the salon and there are dozens of future appointments that need to be changed to a different employee's name.You could create a(n) ________ that changes the name of the employee for all future appointments from the employee who left to the a employee.

Which of the following is NOT true regarding query joins?

________ is a process where the delete query will remove data that is not useful or needed anymore.

Which of the following is NOT true regarding simple update queries?

Action queries permanently modify the data in tables,but you can undo the changes to your data if you change your mind.

Which of the following is NOT true regarding outer joins?

Which of the following is NOT a factor to consider when running a delete query?

Which of the following is NOT true regarding simple delete queries?

If you are working in your employee database and you accidently delete three employee records,which also removed all payroll records,the best way to recover this data is ________.

The spa manager decided to remove all coupon codes from the database that were not redeemed and have now expired.By using a(n) ________,the database will remain cleansed.

Which of the following is NOT true regarding inner joins?

Many new area codes have been created in the United States over the past few years.It would take too much time to have an employee look through each customer's data and modify the area code as needed.This is when a(n) ________ query can be helpful.

Quiz 8: Workshop 8: Action Queries and Advanced Relationships

To create a query that includes a customer and the products that the customer has purchased would require you to create a(n) ________.

Which of the following is NOT a characteristic of the Unmatched Query Wizard?

Which of the following is NOT true regarding complex update queries?

An action query is a query that makes changes to records or moves many records from one table to another.

Which of the following is NOT true about using the Cascade Update and Cascade Delete Related Records property in the Relationships window?

Which of the following is NOT a reason to cleanse data within your database?

You can use a(n) ________ query to delete data in one or more fields in a database.However,to delete entire records,including the primary key value that makes the record unique,you can use a(n) ________ query.

To create a query that includes all customers and only the products that have been purchased would require you to create a(n) ________.

Perhaps an employee no longer works at the salon and there are dozens of future appointments that need to be changed to a different employee's name.You could create a(n) ________ that changes the name of the employee for all future appointments from the employee who left to the a employee.

Which of the following is NOT true regarding query joins?

________ is a process where the delete query will remove data that is not useful or needed anymore.

Which of the following is NOT true regarding simple update queries?

Action queries permanently modify the data in tables,but you can undo the changes to your data if you change your mind.

Which of the following is NOT true regarding outer joins?

Which of the following is NOT a factor to consider when running a delete query?

Which of the following is NOT true regarding simple delete queries?

If you are working in your employee database and you accidently delete three employee records,which also removed all payroll records,the best way to recover this data is ________.

The spa manager decided to remove all coupon codes from the database that were not redeemed and have now expired.By using a(n) ________,the database will remain cleansed.

Which of the following is NOT true regarding inner joins?

Many new area codes have been created in the United States over the past few years.It would take too much time to have an employee look through each customer's data and modify the area code as needed.This is when a(n) ________ query can be helpful.

You can use a(n) query to delete data in one or more fields in a database.However,to delete entire records,including the primary key value that makes the record unique,you can use a(n) query.