Deck 6: Modifying the Database Structure

Question 1

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

Answer 1

True

Question 2

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

Answer 2

False

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

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

Question 5

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

Question 6

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

Question 7

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 8

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 9

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

Question 10

In a query, the operator means not equal.

Question 11

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 12

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

Question 13

A select query is the most common type of query.

Question 14

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

Question 15

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

Question 16

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

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

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

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

Question 19

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

Question 20

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

Question 21

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 22

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

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

Question 23

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

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

Question 24

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

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

Question 25

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

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

Question 26

The < comparison operator means ____.

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

Question 27

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

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

Question 28

How many calculated fields are shown in the accompanying figure?

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

Question 29

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 30

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

The > comparison operator means ____.

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

Question 32

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 33

The >= comparison operator means ____.

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

Question 34

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

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

Question 35

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

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

Question 36

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

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

Question 37

The < comparison operator means ____.

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

Question 38

In the accompanying figure, 1 refers to a ____.

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

Question 39

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 40

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 41

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

Question 42

A summary query calculates statistics about ____.

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

Question 43

Which arithmetic operator signifies exponentiation?

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

Question 44

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

Question 45

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

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

Question 46

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 47

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

Question 48

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

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

Question 50

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

Question 51

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

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

Question 52

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

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

Question 53

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 54

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

Question 55

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

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

Question 56

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

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

Question 57

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

Question 58

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

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

Question 59

Which arithmetic operator signifies division?

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

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

In the query shown in the accompanying figure, what are the names of the tables involved in the query?

Question 62

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 63

In the query shown in the accompanying figure, what sort orders have been specified?

Question 65

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 66

SQL statements start with the FROM keyword.

Question 67

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

Question 68

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

Question 69

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

Question 70

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

Question 71

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

Question 72

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

Question 73

The > operator means less than in a query.

Question 74

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

Question 75

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

Question 76

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

Question 77

Queries evaluate sort orders from left to right .

Question 78

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

Question 79

When a query is saved, it saves VBA statements.

Question 80

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