MS Access Query Quiz

In a calculated field, what does the expression [Price] * 0.9 calculate?

• Adds 10% to the price

• Subtracts 10% from the price

• Calculates 90% of the price

• Doubles the price

If you want to concatenate (join together) two text fields, which operator should you use?

• +

• &

• *

• /

What is a calculated query in MS Access?

• A query that retrieves data from multiple tables.

• A query that performs calculations using data from fields.

• A query that only retrieves data from one table.

• A query that does not use any expressions.

Which of the following can be used in a calculated field expression in MS Access?

• Functions

• Field names

• Operators

• All of the above

How can you ensure that a calculated field displays the result as currency?

• Format the field as Text

• Use the Format function with "Currency"

• Multiply the result by 100

• Use the SUM function

How do you create a calculated field in a query design view in MS Access?

• Add a new field and enter the calculation in the Criteria row.

• Use the Expression Builder to define the calculation.

• Enter the calculation directly in the Field row.

• Both b and c

To calculate the total price by multiplying Quantity and UnitPrice fields, what would the expression look like?

• [Quantity] + [UnitPrice]

• [Quantity] / [UnitPrice]

• [Quantity] * [UnitPrice]

• [Quantity] - [UnitPrice]

Which function is used to return the current date and time in a calculated field?

• NOW()

• DATE()

• TODAY()

• TIME()

Which function would you use to calculate the average value of a field in a query?

• SUM()

• AVG()

• COUNT()

• MIN()

What is the purpose of the IIF function in a calculated field?

• To import data

• To perform conditional logic

• To iterate over a range of values

• To filter data