Exam 17: Access: Presentation Design

When designing an expression using Expression builder in Access, expressions can only be created with constants

When you use a table field in an expression, Access will automatically correct any spelling errors in the field name.

SUM and COUNT are examples of ________ functions that perform calculations on entire columns of data.

Functions do not work the same way in Access and Excel.

Rounding fields to two decimal places in a column formatted as currency formats can help you avoid potential problems when the column is totaled.

You can use the ________ function in an expression requiring the current date.

Expression Builder can be opened by selecting Builder located in the Query:

Steve is working in a database that stores student exam grades. He needs to create a query that will show the numerical mean of exam grades. He should use the ________ function on the column containing the grades.

If you needed to design a query to calculate the year contained in a date field, you would use the ________ function.

All of the following are true in reference to built-in functions EXCEPT:

The ________ function inserts the system day, month, and year into an expression.

Previous versions of Access allowed you to add calculated fields to tables.

Calculated fields in Datasheet view can be edited in the same way other fields from a table are edited.

The Average or AVG function can only be used with the Number datatype.

The PMT function returns the monthly payment due on a loan.

Expression builder can launched by right-clicking the cell where you want the expression, and selecting Build from the shortcut menu.