Question 1

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.

Accepted Answer

The answer of Before designing your own functions for a...

Question 2

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

Accepted Answer

The answer of SUM and COUNT are examples of ________...

Question 3

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

Accepted Answer

The answer of A ________ query is used to display...

Question 4

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

Accepted Answer

The answer of Access stores dates as the number of...

Question 5

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

Accepted Answer

The answer of The Report Wizard gives users a choice...

Question 6

According to the order of operations, expressions in ________ are calculated first.

Accepted Answer

The answer of According to the order of operations, expressions...

Question 7

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

Accepted Answer

The answer of The ________ function inserts the system day,...

Question 8

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.

Accepted Answer

The answer of David is working on a database that...

Question 9

Access requires the correct ________ when designing calculated fields..

Accepted Answer

The answer of Access requires the correct ________ when designing...

Question 10

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

Accepted Answer

The answer of If you needed to design a query...

Question 11

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

Accepted Answer

The answer of If two conditions are not sufficient to...

Question 12

Expressions to perform calculations such as using a birthdate to find a person's age can be built using ________.

Accepted Answer

The answer of Expressions to perform calculations such as using...

Question 13

________ changes the appearance of a field containing a date without affecting the data the field contains.

Accepted Answer

The answer of ________ changes the appearance of a field...

Question 14

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.

Accepted Answer

The answer of Maria is working on a database that...

Question 15

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

Accepted Answer

The answer of The ________ function returns the number of...

Question 16

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.

Accepted Answer

The answer of Glen is working on a database table...

Quiz 17: Access: Presentation Design