Deck 17: Access 2013 : Improving Queries

Question 1

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

Answer 1

True

Question 2

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

Answer 2

True

Question 3

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

Answer 3

True

Question 4

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

Question 5

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 6

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

Question 7

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

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 the accompanying figure,fields from how many tables will display on the datasheet?

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

Question 10

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

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

Question 13

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

Question 14

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

Question 15

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

Question 16

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

Question 17

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 18

A select query is the most common type of query.

Question 19

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

Question 20

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

Question 21

How many calculated fields are shown in the accompanying figure?

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

Question 22

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

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

Question 23

The < comparison operator means ____.

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

Question 24

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

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

Question 25

The > comparison operator means ____.

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

Question 26

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 27

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

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

Question 28

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 29

The < comparison operator means ____.

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

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

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 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 accompanying figure,1 refers to a ____.

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

Question 34

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 35

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

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

Question 36

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

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

Question 37

The >= comparison operator means ____.

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

Question 38

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

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

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

Question 41

Which arithmetic operator signifies division?

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

Question 42

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

Question 43

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

Question 44

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

Question 45

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

Question 46

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

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

Question 47

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 48

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

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

Question 49

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

Question 50

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

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

Question 51

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

Question 52

Which arithmetic operator signifies exponentiation?

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

Question 53

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 54

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

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

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

Question 56

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

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

Question 57

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

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

Question 58

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

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

Question 59

A summary query calculates statistics about ____.

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

Question 60

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

Question 61

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

Question 62

The > operator means less than in a query._________________________

Question 63

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

Question 64

SQL statements start with the FROM keyword._________________________

Question 65

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 66

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

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

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

Question 69

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

Question 70

Queries evaluate sort orders from left to right._________________________

Question 71

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

Question 72

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

Question 73

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

Question 74

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

Question 75

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

Question 76

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

Question 77

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