Chapter 3 questions and Answer - access

Question 1

Aggregate functions perform calculations on:

Answer 1

entire columns of data.

Question 2

Dates in Access are stored as sequential numbers, allowing for calculations known as ______________ to be performed on dates.

Answer 2

Date Arithmetic

Question 3

Tara is working on a database that holds employee information. There is a table called Employees that includes a field called HireDate. Tara needs to design a query with an expression that will have the query results show all employees hired in a certain year. Which function will assist Tara in completing this query?

Answer 3

DatePart()

Question 4

What is the order of operations?

Answer 4

Exponentiation, Multiplication, Division, Addition, Subtraction

Question 5

Consider the following equation: (5+3) * 2/4 =. What is the value of this equation?

Answer 5

Correct Answer:

4

Question 6

An expression may contain a constant which is a:

Answer 6

value that does not change.

Question 7

A set of rules that Access follows when evaluating expressions is called:

Answer 7

syntax.

Question 8

All of the following statements regarding functions are true EXCEPT that:

Answer 8

function arguments need not be in any specific order.

Question 9

The ________________________ function allows you to enter the current date into an expression.

Answer 9

Date()

Question 10

What does the following expression do?

DatePart(“yyyy”,[Employee]![BirthDate])

Answer 10

Isolates the year in the BirthDate field of Employee table

Question 11

True or False An aggregate function, unlike other functions, can return multiple values

Answer 11

False

Question 12

True of False Arguments used to produce output for functions must be constants.

Answer 12

False

Question 13

True or False A function produces a single value based on inputs.

Answer 13

True

Question 14

True or False The PMT() function calculates the interest paid on a loan.

Answer 14

False

Question 15

True or False Date formatting changes the underlying value of a date field.

Answer 15

False

Question 16

True or False If you forget to add a name to a calculated field in expression builder, an error will result.

Answer 16

False

Question 17

True or False The Count() function calculates the number of items in a column, but does not add their values.

Answer 17

True

Question 18

True or False Many common functions are located in the Built-In Functions folder in the Expression Builder.

Answer 18

True

Question 19

True or False Dates in Access are stored as the number of days that have elapsed since December 31st, 1899.

Answer 19

True

Question 20

True or False The IIf() function is used when different values must be used for true or false conditions.

Answer 20

True

Question 21

True or False The IIf() function may be nested when two conditions are not sufficient to evaluate an expression.

Answer 21

True

Question 22

True or False Using Expression Builder for a calculated field helps eliminate spelling errors in field names.

Answer 22

True

Question 23

True or False Some elements of expressions include functions, tables, constants, and operators.

Answer 23

True

Question 24

An Excel spreadsheet can be used to verify True or False results in a query containing calculated fields.

Answer 24

True

Question 25

True or False Calculated fields can be used as input for other calculated fields.

Answer 25

True