Q1. What is the main topic of the video tutorial?
A. How to program in VBA within Microsoft Access
B. How to display the customer's last contact and last order date in a Microsoft Access database
C. How to set up referential integrity in Microsoft Access
D. How to create a new form in Microsoft Access

Q2. Which function is recommended for displaying the last contact date on a single form in Microsoft Access?
A. DSUM
B. DMAX
C. DMIN
D. DAVERAGE

Q3. When using a continuous form in Microsoft Access, what method is preferred for displaying aggregate data like the last contact date?
A. Using individual D-functions for each record
B. Using a single text box for all records
C. Using an aggregate query
D. Copying data manually to each record

Q4. Why should you not use D-functions like DLOOKUP or DMAX in continuous forms?
A. They require VBA programming which can be complex
B. They are not supported by Microsoft Access
C. They slow down performance if there are many records
D. They do not allow for any data to be edited

Q5. In the video, what is mentioned as a potential issue when joining customer and contact tables?
A. Some customers might be shown multiple times
B. Customers without contacts might not show up
C. Creating a circular reference error
D. Duplicating all customer records

Q6. What is the purpose of using the 'NZ' function in the context of the tutorial?
A. To calculate the net zero balance for customers
B. To skip null values when summing up order totals
C. To handle null values by substituting a default value in the DMAX function
D. To rename query fields in Microsoft Access

Q7. What is a key difference between using single forms and continuous forms for displaying data in Access, as discussed in the video?
A. Single forms require aggregate queries while continuous forms do not
B. Continuous forms allow for editing all records simultaneously, single forms do not
C. D-functions are suitable for single forms but should be avoided in continuous forms
D. Single forms can display data from multiple tables simultaneously, continuous forms cannot

Q8. Why is it important to create a left outer join between the customer table and the contact table in an aggregate query?
A. To ensure only matched records are displayed
B. To ascertain that customers without contacts are still shown in the results
C. To improve query performance significantly
D. To prevent accidental data modifications

Q9. What does the speaker suggest using if you want to rename a field in the results of a query?
A. Use the NZ function
B. Use an alias
C. Use a VBA script
D. Use the MACRO builder

Q10. What is the disadvantage of using an aggregate query in a Microsoft Access form?
A. They cannot include data from more than one table
B. They are prone to data entry errors
C. The resulting record set becomes non-updatable
D. Queries take longer to write and execute

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