Exam 8: Using Advanced Queries

A(n) ____________________ query moves data from one table to another table.

A completed ____ query displays the data in a spreadsheet-like format.

A(n) crosstab query rearranges data in a table or query so that it appears in another format.

You can use an update action query to instantly update all the employee salaries in a table by five percent.

To protect the data in the table, it is best to make a copy of the table before you run a(n) ____ query.

Case AC 8-1 Eric runs a small computer repair service. He decides to reduce prices by 5% to see if he can obtain more clients. Eric quickly creates and runs an update database query against his price table to lower the prices displayed on his Web site and then decides to take a lunch break. In the meantime, Eric begins receiving many client emails and calls inquiring on the 50% price drop advertised on his Web site. What should Eric have done before running his query?

Case AC 8-1 Eric runs a small computer repair service. He decides to reduce prices by 5% to see if he can obtain more clients. Eric quickly creates and runs an update database query against his price table to lower the prices displayed on his Web site and then decides to take a lunch break. In the meantime, Eric begins receiving many client emails and calls inquiring on the 50% price drop advertised on his Web site. What is the most likely cause for Eric's Web site to be displaying a 50% price drop for services?

An append query is a form of a(n) ____ query.

You can use a wildcard character with letters or numbers in any order.

Parameter means to ____.

Parameter queries increase efficiency.

Queries are ____ that let you locate specific information in tables.

Case Access 8-2 Betty is an assistant at the local pet shelter. She uses an Access database to store information about people who have adopted a pet, dropped off pets, or those who have contributed money and supplies to the shelter. While preparing for a fundraising event for the shelter, she recalls a donor whom she would like to contact but cannot recall the donor's name. However, she is certain it ends in the letters "son". If Betty searches for a person by typing ____ in the last name field of her query, she will narrow down output to donors with a last name ending "son".

To create a parameter query, you enter a "prompt" in the Criteria cell of the desired field.

Figure AC 8-1 In Figure AC 8-1 above, item 2 points to ____.

Describe the differences between the three action queries that may be used to make changes to the records in a table.

Crosstab queries calculate a Sum, Avg, Count, or other type of calculation that you choose for numerical data.

For an action query, records may not be added correctly if the ____ in the two tables do not match.

Using both parameters and wildcards allows you to enter only the criterion that you are sure of in the provided message box.

Access prevents you from using parameters and wildcards in the same query.