Deck 7: Improving Queries

Question 1

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

Answer 1

True

Question 2

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.

Answer 2

True

Question 3

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

Answer 3

False

Question 4

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

Question 5

In the accompanying figure, the criteria in the first row of the query would be considered AND criteria.

Question 6

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

Question 7

In the accompanying figure, the criteria in the TourStartDate column would be considered OR criteria.

Question 8

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

Question 9

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

Question 10

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

Question 11

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.

Question 12

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

Question 13

In a query, the <> operator means not equal.

Question 14

In the accompanying figure, fields from how many tables will display on the datasheet?

A) 1
B) 2
C) 3
D) 4

Question 15

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

A) field list
B) one-to-many link line
C) query design grid
D) Show Table window

Question 16

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

Question 17

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

Question 18

You can specify more than one sort field in Query Design View.

Question 19

A select query is the most common type of query.

Question 20

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 21

In the accompanying figure, item 3 points to ____.

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

Question 22

In the accompanying figure, 1 refers to a ____.

A) function
B) operator
C) expression
D) calculated field name

Question 23

In the query design grid, what characters surround text criteria?

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

Question 24

An SQL statement determines how the resulting records are sorted after the ____ keyword.

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

Question 25

____ 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 26

How many calculated fields are shown in the accompanying figure?

A) 1
B) 2
C) 3
D) 4

Question 27

The < comparison operator means ____.

A) less than
B) not equal to
C) greater than
D) null

Question 28

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

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

Question 29

The wildcard character that represents one character in query criteria is the ____.

A) asterisk (*)
B) exclamation point (!)
C) tilde (~)
D) question mark (?)

Question 30

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

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

Question 31

The < comparison operator means ____.

A) greater than
B) less than
C) like
D) not

Question 32

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

A) table name
B) field list
C) query design grid
D) one-to-many join line

Question 33

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

A) asterisk (*)
B) exclamation point (!)
C) tilde (~)
D) question mark (?)

Question 34

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

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

Question 35

The > comparison operator means ____.

A) greater than
B) greater than or equal to
C) less than
D) less than or equal to

Question 36

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

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

Question 37

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 38

When the comparison operator Null is used as criteria in the query design grid, the query 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 39

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

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

Question 40

The >= comparison operator means ____.

A) less than or greater than
B) within
C) in
D) greater than or equal to

Question 41

Which arithmetic operator signifies division?

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

Question 42

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

Question 43

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

Question 44

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

Question 45

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

Question 46

Which row in the query design grid identifies which of the three positions each field takes in the crosstab query?

A) Group By row
B) Total row
C) Values row
D) Crosstab row

Question 47

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

Question 48

Which aggregate function would NOT work well on a Short Text field?

A) Sum
B) Min
C) Max
D) Count

Question 49

A(n) ____ query is used to calculate statistics about a group of records.

Question 50

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

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

Question 51

Which arithmetic operator signifies exponentiation?

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

Question 52

Which aggregate function is used to find the average of values in a field?

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

Question 53

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

Question 54

Which aggregate function is used to find the number of values in a field?

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

Question 55

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

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

Question 56

____ 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 57

A summary query calculates statistics about ____.

A) one record
B) groups of records
C) one field
D) groups of fields

Question 58

When you create a summary query, which row is added to the query design grid?

A) Criteria
B) Table
C) Field
D) Total

Question 59

Which query wizard helps you build a crosstab query?

A) Select Query Wizard
B) Crosstab Query Wizard
C) Simple Query Wizard
D) Find Aggregates Query Wizard

Question 60

Which aggregate function is used to find the total of values in a field?

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

Question 61

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

Question 62

Match each of the following with the correct definition or statement.
a.Calculated field
d.Aggregate function
b.Expression
e.Sort
c.Function
f.Wildcard character
A predefined Access formula that returns a value such as a subtotal or count

Question 63

Match each of the following with the correct definition or statement.
a.Calculated field
d.Aggregate function
b.Expression
e.Sort
c.Function
f.Wildcard character
A field of data that is created based on values of other fields

Question 64

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

Question 65

Discuss the use of the * wildcard character in query criteria.

Question 66

When a query is saved, it saves VBA statements. _________________________

Question 67

Queries evaluate sort orders from left to right. _________________________

Question 68

You can view the SQL code for any query by switching to Code View. _________________________

Question 69

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

Question 70

Explain the relationship between the Like operator and the wildcard character using an example that describes how to create criteria for all values in a CompanyName field that start with the letter J.

Question 71

Match each of the following with the correct definition or statement.
a.Calculated field
d.Aggregate function
b.Expression
e.Sort
c.Function
f.Wildcard character
An asterisk or question mark used in a query

Question 72

The > operator means less than in a query. _________________________

Question 73

In SQL, the FROM keyword determines how records are sorted. _________________________

Question 74

Match each of the following with the correct definition or statement.
a.Calculated field
d.Aggregate function
b.Expression
e.Sort
c.Function
f.Wildcard character
A statistic such as a subtotal or count is determined on a given field in a group of records

Question 75

When you are saving a query, you are saving a set of instructions written in Standard Query Language. _________________________

Question 76

Syntax are tests, or limiting conditions, that must be true for a record to be selected for a datasheet in a query. _________________________

Question 77

You want to add the PaymentDate field from the Payments table in the query shown in the accompanying figure. Describe how you can do this.

Question 78

Match each of the following with the correct definition or statement.
a.Calculated field
d.Aggregate function
b.Expression
e.Sort
c.Function
f.Wildcard character
A datasheet's records are placed in a determined order

Question 79

SQL statements start with the FROM keyword. _________________________

Question 80

Match each of the following with the correct definition or statement.
a.Calculated field
d.Aggregate function
b.Expression
e.Sort
c.Function
f.Wildcard character
A combination of field names, operators and functions