Exam 17: Access: Presentation Design

Which of the following is the correct mathematical sequence for the order of operations:

David is working on a database that stores student exam grades. He needs to design a query that will display the lowest exam grade. He should use the ________ function in Exprssion Builder on the column containing the exam grades.

The ________ function calculates loan payments.

Following the order of operations, 3+2*6 evaluates to 30.

If two conditions are not sufficient to evaluate an expression in an expression, Access users can use the ________ IIf function.

Maria is working on a database that stores client invoice data. She needs to design a query that will display the average balance of all invoices. She should use the ________ function in Expression Builder on the column containing invoice amounts.

A total row, which can be displayed as the last row in the Datasheet view of a table, provides a number of ________ functions that can be applied to columns of data.

-Consider the table pictured above. GrossPay is a calculated field. Which of the following expressions was used to calculate the data for the field?

According to the order of operations, addition and subtraction are evaluated before multiplication and division if the addition and subtraction equations are contained within parentheses.

Consider the following equation: 3 * (6 + 5) - 4 / 2. Which operation would be calculated FIRST according the order of operations:

All of the following are valid statements in reference to the IIf function EXCEPT:

The first two arguments of the DatePart function are ________ which describes the part of the date that will be returned; and ________ which tells Access where to locate the date / time information.

Jenna is working on a database that stores a company's invoices. The database includes a Table called Invoices, which has a column called outBalances that shows all outstanding balances. Jenna's boss has asked her to design a query that calculates the numerical mean of all outstanding balances. Which function should Jenna use on the outBalances column to help her complete this task?

What function in a Totals Row would calculate the least valued data item in a group?

When designing expressions in Expression Builder, you cannot use nested IIf functions.

An expression or integer value specifying total number of payments in a loan is the ________ argument in the PMT function.

Before designing your own functions for a query, you can open the Built-in functions folder in ________ to see if the function is already available.

Access requires the correct ________ when designing calculated fields..

The built-in IIf Function evaluates a condition and displays ________.

The Report Wizard gives users a choice to select ________ statistics if the user wants to see the aggregate data of a table.