Deck 8: Using Advanced Queries

Question 1

Parameter queries provide a single query that you may use many times .

Answer 1

True

Question 2

Parameter queries increase efficiency.

Answer 2

True

Question 3

You can undo changes made with an update action query.

Answer 3

False

Question 4

You run a query by right-clicking the query in the Navigation pane.

Question 5

You use a query to ask Access a question.

Question 6

Using parallel tables that have a common field allows you to display information from more than one table.

Question 7

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

A) action
B) embedded
C) parameter
D) expression

Question 8

Parameter means to ____.

A) remove
B) embed
C) vary
D) add

Question 9

When you save a parameter query, you can add ____ before the query name to easily recognize it as a query in a list.

A) 1-
B) qry-
C) #-
D) my-

Question 10

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

Question 11

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

Question 12

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

Question 13

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

Question 14

To display the Query Design window, click the ____ tab and then click the Query Design button in the Queries group.

A) Open
B) Insert
C) Create
D) Query

Question 15

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

Question 16

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

A) formulas
B) edits
C) operations
D) expressions

Question 17

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

Question 18

Typically records in a table appear in rows, and the columns display the information for the field.

Question 19

Each time you run a parameter query, you can type a different criterion in the text box.

Question 20

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

Question 21

You can run a query by ____.

A) clicking the View button on the Design tab
B) double-clicking the View button in the Navigation pane
C) clicking the View button in the Results group
D) double-clicking the Execute button on the Design tab

Question 22

When creating an append query, you place the mouse pointer over the first field in the highlighted fields, press and hold down the mouse button, and drag them to ____ in the query design grid.

A) the first row
B) the last row
C) the middle row
D) any row

Question 23

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

A) string
B) numerical
C) text
D) variable

Question 24

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

A) action
B) crosstab
C) parameter
D) criterion

Question 25

You ____ the empty field to the right of the Description field in the design grid to display the shortcut menu.

A) click
B) double-click
C) triple-click
D) right-click

Question 26

When you run a parameter query, it displays a ____.

A) message box
B) pop up
C) ScreenTip
D) new window

Question 27

When creating an append query, you can add all of the fields at one time to the query design by double-clicking the ____ to select all of the fields.

A) table column
B) table row title
C) table name title
D) table grid outline

Question 28

With an action query, the records in the table are changed ____.

A) after you run the query
B) as soon as you run the query
C) after the next replication
D) before the next replication

Question 29

____________________ refers to the specific information you are searching for.

Question 30

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?

A) Eric's server is displaying last years test data.
B) Eric ran the query on the wrong server.
C) Records in his price table were changed as soon as Eric ran the query.
D) A competitor's Web site is listing Eric's phone number.

Question 31

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".

A) *son
B) son*
C) *so*
D) *son*

Question 32

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". By using ____, Betty will be able to enter only the criterion that she is certain of in a provided message box.

A) a crosstab query
B) only wildcards
C) only parameters
D) both parameters and wildcards

Question 33

You can run a query by ____.

A) clicking the Run button on the Design tab
B) double-clicking the View button in the Navigation pane
C) double-clicking the query in the Results group
D) clicking the Run button in the Navigation pane

Question 34

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

A) rows
B) columns
C) fields
D) cells

Question 35

The word append means to ____.

A) remove
B) embed
C) query
D) add

Question 36

Figure AC 8-1 In Figure AC 8-1 above, item 1 points to the area illustrating ____.

A) multiple tables in a query
B) parameters for the criteria field
C) the results from the query
D) the relationship with Employee ID fields

Question 37

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?

A) Eric should have made a copy of the price table before he ran the query.
B) Eric should have made a copy of the query before he ran the update.
C) Eric should have gone to a competitor's store to compare their prices to his.
D) Eric should have set a restore point.

Question 38

You double-click ____ in the New Query dialog box to display the Crosstab Query Wizard dialog box.

A) New Query
B) Crosstab Wizard
C) New Wizard
D) Crosstab Query Wizard

Question 39

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

A) multiple tables in a query
B) parameters for the criteria field
C) the results from the query
D) the relationship with Employee ID fields

Question 40

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

A) action
B) crosstab
C) parameter
D) criterion

Question 42

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

Question 43

A(n) ____________________ character is a character, such as an asterisk, that you can use to represent incomplete or unknown information.

Question 44

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

Question 45

Update queries let you change ____________________ values in a table.

Question 46

A(n) ____________________ query makes changes to the records in a table.