Exam 8: Workshop 8: Action Queries and Advanced Relationships

An outer join,the default join type in Access,is a join that selects only those records from both database tables that have matching values.

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

When a company archives data for later analysis,its employees will use ________ tools to work with the data and obtain information on how the organization is progressing toward its goals.

Running update and delete queries are the same as using the Cascade Update and Cascade Delete Related Records property in the Relationships window.

When running a(n)________,the data types for both the source and destination fields must either match or be compatible.

An operational database contains a large amount of different types of data that present a clear picture of your business environment at a specific point in time.

Suppose your database may have initially been built to track customers and the orders they placed.Now you decide to also track marketing efforts and the quantity of customers who use coupons that were mailed or e-mailed to them.You would need to run a(n)________ to track who redeemed coupons and when they were redeemed.

The spa manager could learn a lot about the business and use this information to help increase sales.If the manager knows that two items are most likely to sell together in one transaction,he could ensure he has equal amounts of inventory in stock.This is known as ________.

________ helps an organization attain their goals and objectives by giving them a better understanding of past performance as well as information on how the organization is progressing toward its goals.

A simple delete query is used to remove one or more records from a table or another query.

Which of the following is NOT true regarding outer joins?

In terms of action queries,"Run" is synonymous with ________.

An operational database is a database used to carry out regular operations,such as payroll and inventory management,of an organization.

A(n)________ query is similar to a make table query,except that a query dataset is appended to an existing table.

Which of the following is NOT true regarding make table queries?

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

Update queries are similar to the ________ dialog box,but much more powerful.

When you update data from one table to another and use compatible data types instead of matching data types,Access converts the data types of the fields in the destination table.As a result,some of the data in the destination fields may be truncated.

Loading historical data into a separate table and using that table as a data source can reduce time and provide a convenient data archive.Remember that the data in the new table is just a ________ of the data at a specific time.

When a bank customer withdraws money from an ATM,the record is being stored in the bank's ________.