Deck 6: Improving Queries Question

Question 1

Access helps you with criteria syntax in the query design grid.

Answer 1

True

Question 2

OR queries narrow the number of records that will appear in the datasheet because a record must be true for all criteria.

Answer 2

False

Question 3

If you change a customer name from "Miller" to "Millen" in a query's datasheet, you will need to make the update in any other query that also displays this customer's name.

Answer 3

False

Question 4

In Query Design View, a table's name displays in the field list title bar.

Question 5

In the query above, the criteria in the TourStartDate column would be considered OR criteria.

Question 6

Changes you make to PivotChart View are automatically reflected in PivotTable View and vice versa.

Question 7

A query can display fields from one or more tables in a relational database.

Question 8

When you open a query in Datasheet View, you run it.

Question 9

A select query is the most common type of query.

Question 10

In the figure above, item 3 points to the ____.

A)field from the Payments table
B)field from the Tours table
C)Payments field list
D)Sales field list

Question 11

In the query above, the criteria in the first row would be considered AND criteria.

Question 12

Which type of query retrieves data from one or more linked tables and displays the results in a datasheet?

A)Common
B)Select
C)Linking
D)Web

Question 13

The operator means not equal to in a query.

Question 14

A select query can be used to develop summary calculations, such as the sum of the values in a field.

Question 15

Sort orders defined in Query Design View are not saved with the query object.

Question 16

Deleting a field from the query design grid deletes it from the table that contains that field.

Question 17

Queries allow you to specify more than one sort field in Query Design View.

Question 18

In Query Design View, one-to-many join lines identify linking fields between related tables.

Question 19

Multiple criteria added to the same line of the query design grid means that each must be true for the record to appear in the datasheet.

Question 20

Each criteria row of the query design grid is evaluated separately.

Question 21

The wildcard character that represents any combination of characters in criteria is the ____.

A)Asterisk (*)
B)Exclamation point (!)
C)Tilde (~)
D)Question mark (?)

Question 22

Which operator signifies exponentiation?

A)#
B)*
C)/
D)^

Question 23

The operator Null used as criteria in the query design grid finds records in which _____.

A)The value is not equal to the text "Null"
B)The field value is equal to the text "Null"
C)Any value has been entered for a field
D)No value has been entered for a field

Question 24

Which function would you use to calculate today's current date?

A)CURRENT
B)DATE
C)YEAR
D)DAY

Question 25

The operator > means ____.

A)Greater than
B)Greater than or equal to
C)Less than
D)Less than or equal to

Question 26

____ criteria are two or more criteria on the same Criteria row of the query design grid.

A)OR
B)Expand
C)AND
D)Wildcard

Question 27

In the figure above, item 2 refers to a(n)____.

A)Field list
B)One-to-many link line
C)Query design grid
D)Show Table window

Question 28

The operator >= means ____.

A)Less than or greater than
B)Within
C)In
D)Greater than or equal to

Question 29

In the figure above, what is the primary key field of the Tours table?

A)TourNo
B)Customers
C)Sales
D)Tours

Question 30

A(n)____ character is used in criteria to represent any combination of characters.

A)Wildcard
B)Default
C)Criteria
D)Expression

Question 31

An SQL statement determines how the tables are joined after the ____ keyword

A)SELECT
B)RELATE
C)FROM
D)ORDER BY

Question 32

In Query Design View, primary key fields in a field list are ____.

A)Underlined
B)The first field listed
C)The last field listed
D)Indicated with a key icon

Question 33

In the figure above, how many fields will display on the resulting datasheet?

A)3
B)4
C)5
D)6

Question 34

In the figure above, item 1 refers to a(n)____.

A)Table name
B)Field list
C)Query design grid
D)One-to-many join line

Question 35

An SQL statement determines what fields are selected after the  ____ keyword.

A)SELECT
B)FROM
C)ORDER BY
D)LIST

Question 36

The operator < means ____.

A)Greater than
B)Less than
C)Like
D)Not

Question 37

Which character signifies the division operator?

A)^
B)*
C)/
D)\

Question 38

Text criteria are surrounded by these characters in the query design grid.

A)Pound signs (#)
B)Dollar signs ($)
C)Percent signs (%)
D)Quotation marks ("")

Question 39

The operator > means ____.

A)Less than
B)Not equal to
C)Greater than
D)Null

Question 40

Which function would you use to calculate the monthly payment on a loan?

A)PMT
B)LOAN
C)PAY
D)RATE

Question 41

A(n)____________________ calculates a statistic such as a sum or average by grouping records like a crosstab query with the additional benefit of allowing you to filter the presented data.

Question 42

The ____________________ function returns the number of characters in a field.

Question 43

The Find ____________________ Query Wizard is used to determine whether a table contains duplicate values in one or more fields.

Question 44

Compare the field drop areas between a PivotTable and PivotChart.

Question 45

The Find ____________________ Query Wizard is used to find records in one table that do not have related records in another table.

Question 46

A summary query calculates statistics about ____.

A)One record
B)Groups of records
C)One field
D)Groups of fields

Question 47

This aggregate function is used to find the total of values in a field.

A)Sum
B)Sub
C)Subtotal
D)Total

Question 48

Filtering refers to reordering records in either ascending or descending order based on the values in the field.

Question 49

This aggregate function is used to find the number of values in a field.

A)Values
B)Num
C)Number
D)Count

Question 50

The ____________________ function returns a number of characters from the first part of a field.

Question 51

When a query is saved, it saves VBA statements.

Question 52

The data displayed in a query is sometimes called a(n)____________________ view of the data.

Question 53

____________________ queries summarize data in which one or more fields are chosen for the row headings, another for the column heading, and yet another for the field summarized within the datasheet itself.

Question 54

This aggregate function is used to find the average of values in a field.

A)Avg
B)Average
C)Mean
D)Mode

Question 55

Explain the position and purpose for the three typical field positions used in a crosstab query.

Question 56

In Query Design View, you can drag the edge of a field list to resize it.

Question 57

A(n)____________________ query is used to calculate information about a group of records.

Question 58

Use the ____________________ Query Wizard to guide you through the steps of creating a crosstab query.

Question 59

Discuss the use of wildcard characters in query criteria: 1. Why are they used? 2. What two wildcard characters are provided to search for a single character or any number of characters?

Question 60

Use the ____________________ check box in the query design grid to select or unselect a field to display in the resulting datasheet.

Question 62

Describe the one-to-many relationships of the tables in the figure above.

Question 63

Queries evaluate sort orders from left to right .

Question 64

You decide to search for all last names beginning with the letter M in the query shown above. Describe how to do this.

Question 65

The > operator means less than in a query.

Question 66

You decide you want to see the PaymentDate field in the query above. Describe how to do this.

Question 67

In the query above, what are the names of the tables are involved in the query?

Question 68

What sort orders have been specified in the query above?