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.

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.