Q1. What does the pound name error typically indicate in Microsoft Access?
A. The formula has been entered correctly
B. Access does not recognize the field name or function used
C. The calculated field contains non-numeric data
D. The table being referenced is missing

Q2. In the video, Riley wants to sum up orders using which function?
A. D-Lookup
B. D-Sum
C. D-Max
D. D-Count

Q3. What is the prerequisite level of knowledge required for understanding the tutorial?
A. Beginner
B. Intermediate
C. Expert
D. Developer

Q4. Which of the following concepts is important to understand before using D-Sum or D-Lookup functions?
A. Conditional Formatting
B. Table Relationships
C. Concatenation
D. VBA Programming

Q5. When modifying a calculated control in Access to sum all of a customer's orders, which initial criterion was added to filter the results?
A. Order Date
B. Product ID
C. Customer ID
D. Payment Date

Q6. Which keyword does Access mistakenly consider a field name, causing an error, if not used correctly inside the D-Sum function?
A. Now
B. Current
C. Date
D. Today

Q7. What method was suggested to correctly handle date values in the D-Sum function?
A. Use an absolute date like '1/1/2023'
B. Remove square brackets around date
C. Encapsulate the date value within hashtags
D. Add quotation marks around the date

Q8. How can you handle a situation where the calculated field returns a null value, to display a zero instead in Access?
A. Use the IIf function
B. Use the DateDiff function
C. Use the NZ function
D. Use the Format function

Q9. If the calculated field still returns incorrect results after using the date function and the correct concatenation, what final adjustment should be applied to ensure proper date filtering?
A. Include the exact time with the date
B. Add a leading zero to the date value
C. Enclose the date in square brackets
D. Enclose the date in octothorpes (hashtags)

Q10. Why did placing the function 'Date' within square brackets cause an error in the tutorial?
A. It turned the function into a literal string
B. It referenced a non-existent table
C. It made Access look for a field named 'Date'
D. It changed the date format to text

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

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.