Question 1

When using date data, the date is surrounded by ________.
A) parentheses ( )
B) pound signs # #
C) brackets [ ]
D) braces { }

Accepted Answer

The answer of When using date data, the date is...

Question 2

When a(n) ________ query is run, it contains an extra row that displays aggregate data.
A) aggregate
B) totals
C) summary
D) condensed

Accepted Answer

A "totals" query adds an extra row to display aggregate data such as sum or count, while an "aggregate" query involves grouping and summarizing data. A "summary" query generally refers to a report or summary of data rather than a specific type of query. "Condensed" is not a commonly used term in database querying.

Question 3

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

Accepted Answer

The heading for the column is explicitly stated to be PricePerRoom in the question prompt.

Question 4

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.

Accepted Answer

The answer of If you misspell a field name in...

Question 5

When creating a calculated field using field names, Access automatically surrounds the field names with ________.
A) braces { }
B) parentheses ( )
C) brackets [ ]
D) quotation marks " "

Accepted Answer

Access surrounds field names with brackets [ ] when creating a calculated field.

Question 6

A(n) ________ function performs a calculation on an entire column and returns a single result.
A) compound
B) aggregate
C) summary
D) abridged

Accepted Answer

The answer of A(n) ________ function performs a calculation on...

Question 7

What is the value of =4+3*2^2?
A) 16
B) 28
C) 40
D) 196

Accepted Answer

The answer of What is the value of =4+3*2^2?
A) 16
B)...

Question 8

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

Accepted Answer

The Expression Wizard is a tool that provides fields, operators, and functions to assist in the creation of expressions.

Question 9

Which of the following is NOT an Access arithmetic operator?
A) ÷
B) +
C) *
D) ^

Accepted Answer

The division operator in Access is /, not ÷. Therefore, A is the correct answer as it is not an Access arithmetic operator.

Question 10

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

Accepted Answer

The answer of The order of operations specifies that any...

Question 11

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

Accepted Answer

The results of aggregate functions are displayed in the Total row in a query.

Question 12

Pmt is an example of a(n)________.
A) parameter
B) function
C) argument
D) subroutine

Accepted Answer

PMT is a function in Excel that calculates the periodic payment for an annuity based on constant payments and a constant interest rate. A function is a pre-written program or series of commands that carries out a specific task, such as performing calculations or manipulating data.

Question 13

Which of the following is NOT an aggregate function?
A) COUNT
B) AVG
C) MINIMUM
D) PMT

Accepted Answer

PMT stands for payment and is not a aggregate function in SQL. COUNT, AVG, and MINIMUM are all examples of aggregate functions in SQL.

Question 14

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

Accepted Answer

This is true. When the result of a calculated field is too large to fit in a column, Microsoft Excel displays a series of pound signs (#) to indicate that the cell content is too wide to be displayed.

Question 15

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

Accepted Answer

Pmt function is used to calculate the periodic payment required to pay off a loan/mortgage. It cannot be used to find the future value of a mortgage. To find the future value of a mortgage, you would typically use the FV function.

Question 16

Match between columns
                        Premises: Grouping
Order of operations
Argument
Total Row
Expression

Accepted Answer

The Answer of Data needed to produce the output for is...

Question 17

Match between columns
                        Premises: Aggregate function
Expression Builder
Property sheet
Totals Query
Syntax

Accepted Answer

The Answer of Performs calculations on a column of data is...

Question 18

Match between columns
                        Premises: +
*
/
^
-

Accepted Answer

The Answer of Exponentiation and Multiplication and Subtraction and Addition is...

Question 19

Match between columns
                        Premises: Identifiers
Operators
Functions
Constants
Variables

Accepted Answer

The Answer of Produce results based on inputs and Values is...

Question 20

Match between columns
                        Premises: Avg
Count
Maximum
Minimum
Sum

Accepted Answer

The Answer of Returns the data item with the highest is...

Quiz 3: Customize, Analyze, and Summarize Query Data: Creating and Using Queries to Make Decisions

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

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

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

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

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

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

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

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

Which of the following is NOT an Access arithmetic operator?

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

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

Pmt is an example of a(n) ________.

Which of the following is NOT an aggregate function?

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

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

Match the following terms to their meanings:

Match the following terms to their meanings:

Match each mathematical symbols to the operation that is performed:

Match each element of an expression with is definition:

Match each aggregate function with the value it returns: