Q1. What is the main focus of the video tutorial by AccessLearningZone.com?
A. How to create a report in Microsoft Access
B. How to number items in a continuous form in Microsoft Access
C. How to use Microsoft Excel with Access
D. How to design a table in Microsoft Access

Q2. Why is numbering items in a form more complex than in a report?
A. Reports are inherently simpler to work with
B. Forms require VBA programming
C. Forms do not have a running sum property
D. Reports are not designed for numbering

Q3. What Microsoft Access function is primarily used in this tutorial to number items?
A. DCount
B. DSum
C. DLookup
D. DMax

Q4. What is a possible problem when using DCount with large datasets or over a network?
A. DCount might miscalculate the count
B. DCount will sort the records unexpectedly
C. The calculation will run slowly
D. DCount will fail to execute

Q5. In the absence of records, which function is used to handle null values?
A. DMax
B. DSum
C. NZ
D. Trim

Q6. When creating a calculated field in the form, which property is used to write the calculation formula?
A. Format
B. Row Source
C. Control Source
D. Validation Rule

Q7. What does the NZ function do when applied in this context?
A. It sums all numbers in a field
B. It prevents null values from causing errors by converting them to zero
C. It divides all numbers in a field
D. It concatenates string values in a field

Q8. How is DCount configured to work with the CustomerID field in the tutorial?
A. DCount counts records greater than the current CustomerID
B. DCount counts records equal to the current CustomerID
C. DCount counts all records regardless of CustomerID
D. DCount counts records less than or equal to the current CustomerID

Q9. What is highlighted as a downside to using DCount in continuous forms?
A. It is hard to implement without VBA
B. It complicates the database schema
C. It cannot be used with calculated fields
D. It slows down performance in large or networked databases

Q10. What is suggested as a potential solution if a user resorts the records in a different order?
A. Re-calculate using a different field
B. Disable sorting altogether
C. Use a temporary table
D. Pull the records into another database

Answers: 1-B; 2-C; 3-A; 4-C; 5-C; 6-C; 7-B; 8-D; 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.