Deck 3: Customize, analyze, and Summarize Query Data: Hands-On-Exercise Videos

Question 1

The results of PricePerRoom: [ListPrice]/([Beds]+[Baths]+3)will appear in a column with the heading ________.

A) PricePerRoom
B) ListPrice
C) Beds
D) Baths

Answer 1

A

Question 2

When using date data,the date is surrounded by ________.

A) parentheses ( )
B) pound signs # #
C) brackets [ ]
D) braces { }

Answer 2

B

Question 3

When a(n)________ query is run,it contains an extra row that displays aggregate data.

A) aggregate
B) totals
C) summary
D) condensed

Answer 3

B

Question 4

Which of the following is NOT an aggregate function?

A) COUNT
B) AVG
C) MINIMUM
D) PMT

Question 5

A(n)________ function performs a calculation on an entire column and returns a single result.

A) compound
B) aggregate
C) summary
D) abridged

Question 6

You can use the Expression Wizard to supply fields,operators,and functions to help you create expressions.

Question 7

When the result of a calculated field is too large to fit in a column,a series of pound signs # is displayed.

Question 8

The order of operations specifies that any exponents are performed first.

Question 9

Pmt is an example of a(n)________.

A) parameter
B) function
C) argument
D) subroutine

Question 10

If you misspell a field name in a calculated field of a query and then run the query,Access will:

A) display a dialog box asking for a value for the field.
B) substitute a zero value for the field and proceed with the calculation.
C) substitute a value of NULL for the field and proceed with the calculation.
D) stop running the query and produce no results.

Question 11

When creating a calculated field using field names,Access automatically surrounds the field names with ________.

A) braces { }
B) parentheses ( )
C) brackets [ ]
D) quotation marks " "

Question 12

Which of the following is NOT an Access arithmetic operator?

A) ÷
B) +
C) *
D) ^

Question 13

You can use Pmt to find the future value of a mortgage.

Question 14

When the results of using the COUNT or MAXIMUM aggregate functions in a query are displayed,they appear in the Total row.

Question 15

What is the value of =4+3*2^2?

A) 16
B) 28
C) 40
D) 196