Question 1

A query join is a permanent relationship between two tables in a query that do not have an established relationship or common field with the same field name and data type.

Accepted Answer

A) True 
 B)False

Question 2

Match the following terms to their definition.
I.Truncate
II.Suggestive sell
III.Data cleansing
IV.BI tools
V.Forecasting
A.Help managers make improved business decisions
B.Adds more revenue
C.Shortens part of a value
D.Estimates future sales trends
E.Removes data that is not useful or needed

Accepted Answer

The answer of Match the following terms to their definition.
I.Truncate
II.Suggestive...

Question 3

Switching to Design view allows you to preview the records that will be added to the other table before actually running the query.

Accepted Answer

A) True 
 B)False

Question 4

Which of the following is NOT a reason why managers would archive data?

Accepted Answer

A) Managers do not have access to data warehouses; thus,they want to keep their own copies of data to refer to as needed. 
B) Managers do not want to delete historical data because it can be used to help manage and develop their business. 
C) A manager may decide at some point,perhaps once you have a few years' worth of data,that you want to archive some of the older data into another database. 
D) A major use of historical data is for forecasting.

Question 5

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

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

Question 6

A simple update query involves updating data in ________ table,allowing you to specify two values-the value you want to replace and the value to use as a replacement.

Accepted Answer

The answer of A simple update query involves updating data...

Question 7

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

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

Question 8

You should always back up your database or the destination table before running an append query.

Accepted Answer

A) True 
 B)False

Question 9

Match between columns
                        Premises: Text to Currency
Text to Hyperlink
Number to Yes/No
Text to AutoNumber
Number to Hyperlink

Accepted Answer

The Answer of Not allowed if field serves as primary is...

Question 10

A company's ________ database is the database used to carry out day-to-day tasks,such as payroll and inventory management,of an organization.

Accepted Answer

The answer of A company's ________ database is the database...

Question 11

An outer join selects all of the records from one database table and only those records in the second table that have matching values in the joined field.

Accepted Answer

A) True 
 B)False

Question 12

A(n)________ selects all of the records from one database table and only those records in the second table that have matching values in the joined field.

Accepted Answer

The answer of A(n)________ selects all of the records from...

Question 13

One way BI tools are used is for data warehousing,which helps expose trends,patterns,and relationships within the data that might have otherwise remained undetected.

Accepted Answer

A) True 
 B)False

Question 14

The Find Unmatched Query Wizard finds records in one table that do not have related records in another table.

Accepted Answer

A) True 
 B)False

Question 15

To delete records on the one side of the relationship and related records on the many side,enable Referential Integrity and Cascade Delete Related Records.

Accepted Answer

A) True 
 B)False

Question 16

The only way to verify that an action query worked correctly is to look in the table to see that the proper action occurred.

Accepted Answer

A) True 
 B)False

Question 17

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

A) update,delete 
B) append,delete 
C) update,append 
D) delete,update

Question 18

A company's ________ database is the database used to record daily transactions.

Accepted Answer

The answer of A company's ________ database is the database...

Question 19

You can use the Find Unmatched Query Wizard to edit,analyze,and ________ data in a table.

Accepted Answer

The answer of You can use the Find Unmatched Query...

Question 20

An append query selects records from one or more data sources and copies the selected records to an existing table.

Accepted Answer

A) True 
 B)False

Exam 8: Workshop 8: Action Queries and Advanced Relationships

A query join is a permanent relationship between two tables in a query that do not have an established relationship or common field with the same field name and data type.

Match the following terms to their definition. I.Truncate II.Suggestive sell III.Data cleansing IV.BI tools V.Forecasting A.Help managers make improved business decisions B.Adds more revenue C.Shortens part of a value D.Estimates future sales trends E.Removes data that is not useful or needed

Switching to Design view allows you to preview the records that will be added to the other table before actually running the query.

Which of the following is NOT a reason why managers would archive data?

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.

A simple update query involves updating data in ________ table,allowing you to specify two values-the value you want to replace and the value to use as a replacement.

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 should always back up your database or the destination table before running an append query.

Match the following data type conversions to their restriction.

A company's ________ database is the database used to carry out day-to-day tasks,such as payroll and inventory management,of an organization.

An outer join selects all of the records from one database table and only those records in the second table that have matching values in the joined field.

A(n)________ selects all of the records from one database table and only those records in the second table that have matching values in the joined field.

One way BI tools are used is for data warehousing,which helps expose trends,patterns,and relationships within the data that might have otherwise remained undetected.

The Find Unmatched Query Wizard finds records in one table that do not have related records in another table.

To delete records on the one side of the relationship and related records on the many side,enable Referential Integrity and Cascade Delete Related Records.

The only way to verify that an action query worked correctly is to look in the table to see that the proper action occurred.

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.

A company's ________ database is the database used to record daily transactions.

You can use the Find Unmatched Query Wizard to edit,analyze,and ________ data in a table.

An append query selects records from one or more data sources and copies the selected records to an existing table.

Exam 8: Workshop 8: Action Queries and Advanced Relationships

A query join is a permanent relationship between two tables in a query that do not have an established relationship or common field with the same field name and data type.

Match the following terms to their definition. I.Truncate II.Suggestive sell III.Data cleansing IV.BI tools V.Forecasting A.Help managers make improved business decisions B.Adds more revenue C.Shortens part of a value D.Estimates future sales trends E.Removes data that is not useful or needed

Switching to Design view allows you to preview the records that will be added to the other table before actually running the query.

Which of the following is NOT a reason why managers would archive data?

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.

A simple update query involves updating data in ________ table,allowing you to specify two values-the value you want to replace and the value to use as a replacement.

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 should always back up your database or the destination table before running an append query.

Match the following data type conversions to their restriction.

A company's ________ database is the database used to carry out day-to-day tasks,such as payroll and inventory management,of an organization.

An outer join selects all of the records from one database table and only those records in the second table that have matching values in the joined field.

A(n)________ selects all of the records from one database table and only those records in the second table that have matching values in the joined field.

One way BI tools are used is for data warehousing,which helps expose trends,patterns,and relationships within the data that might have otherwise remained undetected.

The Find Unmatched Query Wizard finds records in one table that do not have related records in another table.

To delete records on the one side of the relationship and related records on the many side,enable Referential Integrity and Cascade Delete Related Records.

The only way to verify that an action query worked correctly is to look in the table to see that the proper action occurred.

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.

A company's ________ database is the database used to record daily transactions.

You can use the Find Unmatched Query Wizard to edit,analyze,and ________ data in a table.

An append query selects records from one or more data sources and copies the selected records to an existing table.

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.