Q1. What is the main purpose of using a nested if function in Microsoft Access as discussed in the video?
A. To handle complex arithmetic calculations
B. To categorize data based on multiple conditions
C. To sort data in ascending order
D. To perform data validation checks

Q2. Why is a single if function insufficient for categorizing customer spending into high, medium, and low categories?
A. It can only handle numerical data
B. It cannot perform calculations
C. A single if function only handles two conditions
D. It requires additional software to function

Q3. What condition is set to categorize customer spending as "high"?
A. Spending equals $1,000
B. Spending is less than $1,000
C. Spending is greater than $1,000
D. Spending is less than $500

Q4. According to the video, what happens when an if function encounters a true condition?
A. It continues to evaluate all conditions
B. It loops back to the start
C. It exits and does not evaluate further conditions
D. It throws an error

Q5. Which function is recommended as an alternative to nested if functions for handling more than three or four options?
A. DLookup function
B. Switch function
C. Calculate function
D. Sum function

Q6. In the video, what tool is used to improve the readability of writing long if functions outside of Microsoft Access?
A. Excel
B. Word
C. Notepad
D. PowerPoint

Q7. What feature is demonstrated in the video to visually distinguish categories like high, medium, and low in a form?
A. Data Validation
B. Conditional Formatting
C. Form Navigation
D. Report Generation

Q8. In the context of the form's calculated field, what does it mean when a field is marked as "unbound"?
A. It is connected to multiple fields in the table
B. It is no longer linked to any field in the table
C. It requires a mandatory value
D. It automatically updates with any field changes

Answers: 1-B; 2-C; 3-C; 4-C; 5-B; 6-C; 7-B; 8-B

DISCLAIMER: Quiz questions are AI generated. If you find any that are wrong, don't make sense, or aren't related to the video topic at hand, then please post a comment and let me know. Thanks.