Test Yourself

1. Which Date Differences can Access calculate?

(Give all correct answers.)
A. Day
B. Month
C. Year
D. Week
E. Hour
F. Minute
Tip: Advanced Access, page 220

2. Which of the following is true?

(Give all correct answers.)
A. The Left() Function leaves only the number on the left of a string of text
B. The Left() Function removes the text to the left of a number
C. The Right() Function leaves only the number on the right of a string of text
D. The Right() Function removes the text to the right of a number
Tip: Advanced Access, page 221

3. Access uses the IF function for Logical functions, the same as Excel.
A. True
B. False
Tip: Advanced Access, page 222

4. Which of the following is true about the Grid?

(Give all correct answers.)
A. Visible in Design Mode
B. Can be used to align items
Tip: Advanced Access, page 229

5. A Control can use Fields that are not visible in the Report Print Preview
A. True
B. False
Tip: Advanced Access, page 232