Exam 8: Workshop 8: Action Queries and Advanced Relationships

A simple delete query is used to remove data in multiple tables.

A make table query acquires data from one or more tables,and then automatically loads the resulting dataset into a new table once you switch to Datasheet view.

Data warehousing is a technology used to establish business intelligence.

A major use of historical data is for ________,predicting or estimating future sales trends,budget,and so forth.

You can use a make table query when you need to add new records to an existing table by using data from other sources such as an Excel workbook,a Word document,a text file,or another database.

When you run an action query,Access will always warn you that you are about to make a change to your data as well as ask you to confirm the change.Unfortunately,you cannot disable these messages.

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

The key thing to remember when running a simple update query is that although the data types for each table field do not have to match,they must be ________.

A(n)________ acquires data from one or more tables,and then automatically loads the resulting dataset into a new table once you run the query.

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

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.

A(n)________,the default join type in Access,is a join that selects only those records from both database tables that have matching values.

Match the following terms to their definition. I.Operational database II.Transactional database III.Business intelligence IV.Data mining V.Data warehouse A.Helps an organization attain their goals and objectives B.Contains a large amount of different types of data C.Helps expose trends,patterns,and relationships D.Used to record daily sales E.Used to record daily payroll or inventory

The data is not appended to your table until you click the ________ on the Query Tools Design tab.

Which of the following is NOT true regarding inner joins?

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

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

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

Update queries are similar to the Find and Replace dialog box,but not as powerful.

When a company archives data for later analysis,the data is being stored in the company's ________.