Exploring Microsoft Office 2010 Volume 1 Access Chapter 3

Exploring Microsoft Office 2010 Volume 1
Access Chapter 3
Testbank

1) When designing a calculated field, complex formulas can be created with the ________.
A) Expression Builder
B) Table Wizard
C) Form Wizard
D) Report Builder
Answer: A
Diff: 1
Reference: Calculations, Expressions, and Functions
Objective: 3
AppChap: Access 3: Customize, Analyze, and Summarize Query Data

2) All of the following are arguments of the built-in PMT function EXCEPT:
A) Rate
B) Present value
C) Future value
D) Loan payment
Answer: D
Diff: 1
Reference: Expression Builder, Functions, and Date Arithmetic
Objective: 4
AppChap: Access 3: Customize, Analyze, and Summarize Query Data

3) The built-in IIf Function evaluates a condition and displays ________.
A) the same value for conditions that evaluate to true or false
B) a value only if the condition is true
C) one value when the condition is true and another value when the condition is false
D) a value only if the condition is false
Answer: C
Diff: 1
Reference: Expression Builder, Functions, and Date Arithmetic
Objective: 4
AppChap: Access 3: Customize, Analyze, and Summarize Query Data

4) The ________ function isolates a specific portion of a date, such as the day, month, or year, in a date field.
A) DatePart
B) Date
C) DateDiff
D) DateArithmetic
Answer: A
Diff: 1
Reference: Expression Builder, Functions, and Date Arithmetic
Objective: 5
AppChap: Access 3: Customize, Analyze, and Summarize Query Data
5) The ________ function measures the amount of time that has elapsed between two dates.
A) DatePart
B) Date
C) DateDiff
D) DateArithmetic
Answer: C
Diff: 1
Reference: Expression Builder, Functions, and Date Arithmetic
Objective: 5
AppChap: Access 3: Customize, Analyze, and Summarize Query Data

6) Sum, Avg, and Max are examples of ________ functions that are used to evaluate entire columns of data.
A) Date
B) Aggregate
C) Number
D) Totalling
Answer: B