Exam 17: Access: Presentation Design

Which of the following statements is INCORRECT regarding aggregate functions?

The set of rules that Access follows when evaluating expressions in calculated fields is called ________.

Access stores dates as the number of ________ that have elapsed since the date of December 1st, 1899.

Access contains ________ that perform routine calculations.

A ________ query is used to display only aggregate data when the query is run.

Which of the following statements is true in reference to calculated fields:

Syntax can most accurately be defined as the ________.

Expression Builder inserts ________ that tell you where each argument belongs.

The ________ function evaluates a condition and displays different values for true and false conditions.

The currency field format automatically rounds to two decimal places.

You create a calculated field that finds the average of a column of numbers. Access automatically names the field Expr1. Which of the following statements is true regarding the automatic naming of the calculated field?

Glen is working on a database table that stores patient billing information, including the date an invoice was issued. Glen needs to design a query that shows how long the bills in the table have been outstanding. He can use the ________ function in conjunction with the Date function in Expression Builder to determine amount of time that has elapsed between the date the invoice was issued and the current date.

The PMT function is BEST suited to determine:

-Consider the table pictured above. The value of $17.50 in the totals row represents the mean hourly wage. How was this value calculated in the totals row?

Constants that are used as arguments in expressions can be defined as ________.

Aggregate functions only work with numerical data.

Craig is working in a database that stores homes for sale for a Realtor. The database contains a table called HomeListings which contains a field called ListingDate that holds the date that a home was listed. Craig is designing a query that will identify houses on the market for less than 30 days as new listings, and houses on the market 30 days or more as old listings. This information will be included in a query column called ListingAge. Which of the following expressions will achieve these results:

The order of operations determines the sequence by which operations are calculated.

The ________ function returns the number of fields that have data entered in a particular column but ignores null values.

Which of the following statements offers the best method for ensuring that a database is recoverable in case of corruption?