Deck 6: Improving Queries

Question 1

The operators, and NOT are equivalent.

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

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

Answer 3

True

Question 4

To sort records by last name then by payment date, the last name field must be the secondary sort field and the payment date must be the primary sort field.

Question 5

When you enter criteria in a query, you must be aware that criteria are case sensitive, that is, BIO and Bio are not equivalent.

Question 6

A select query is the most common type of query.

Question 7

In a query, the operator means not equal.

Question 8

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

Question 9

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

Question 10

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

Question 11

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

Question 12

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

Question 13

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

Question 14

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

Question 15

Queries evaluate sort orders from left to right . _________________________

Question 16

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

Question 17

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 18

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

Question 19

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 20

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

Question 21

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 22

The

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

Question 23

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

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

Question 24

The

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

Question 25

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 26

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

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

Question 27

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

Question 28

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

Question 29

The > comparison operator means ____.

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

Question 30

The > operator means less than in a query. _________________________

Question 31

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

Question 32

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

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

Question 33

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

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 35

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

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

Question 36

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 37

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

Question 38

The >= comparison operator means ____.

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

Question 39

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

Question 40

SQL statements start with the FROM keyword. _________________________

Question 41

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

Question 42

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 43

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

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

Question 44

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 45

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

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

Question 46

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

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

Question 47

A summary query calculates statistics about ____.

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

Question 48

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

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

Question 49

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

Question 50

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

Question 51

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

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

Question 52

Which arithmetic operator signifies exponentiation?

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

Question 53

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

Question 54

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

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

Question 55

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

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

Question 56

Which arithmetic operator signifies division?

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

Question 57

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

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

Question 58

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

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

Question 59

To find all first names that are either Tom or Tim, you would use the____ wildcard character.

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

Question 60

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

Question 62

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

Question 63

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

Question 64

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

Question 65

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

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

Question 67

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 68

You want to add the PaymentDate field from the Payments table to the query grid. Describe how you can do this.

Question 69

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

Question 70

You want to search for all last names beginning with the letter M. The field name for last name is LName. Describe how to do this.