Q1. In the tutorial, what is used to store the return value when a button is clicked?
A. A global variable
B. A message box
C. A temp var
D. A form property

Q2. How is the return value typecast when storing it in the temp var?
A. As a string (CStr)
B. As a double (CDbl)
C. As a long (CLng)
D. As a Boolean (CBool)

Q3. What is the purpose of setting the temp var in the code?
A. To display the clicked button's caption
B. To store the ID value for use by the calling form
C. To save the user's preference
D. To debug the button click event

Q4. After storing the return value, what action is taken next in the code?
A. The form is minimized
B. The form is closed
C. A message box is displayed
D. The form is refreshed

Q5. What is the eventual goal mentioned in the tutorial regarding selecting multiple options?
A. To allow batch processing
B. To create dynamic reports
C. To potentially handle multiple selections in a future series
D. To improve the user interface design

Q6. How does the customer form use the temp var?
A. It updates the database directly
B. It displays the returned ID in a text box
C. It shows the returned ID in a message box
D. It logs the ID to a file

Q7. Which variables are declared to store the information needed from the button clicks?
A. VMakeID, VModelID, VYearID
B. VarMake, VarModel, VarYear
C. VMakeCode, VModelCode, VYearCode
D. TempMake, TempModel, TempYear

Q8. What SQL modification is necessary to display models based on the selected make?
A. Adding an ORDER BY clause
B. Creating a new table
C. Adding a WHERE condition for vMakeID
D. Converting model IDs to strings

Q9. What common mistake is highlighted when adjusting the SQL statement?
A. Forgetting to alias the table names
B. Forgetting to add spaces around keywords
C. Incorrectly using JOIN clauses
D. Using reserved SQL keywords as column names

Q10. What is the ultimate purpose of the cascading combo boxes?
A. To dynamically filter and display options based on prior selections
B. To provide predefined static lists for user selections
C. To update database records in real-time
D. To simplify the user interface by reducing the number of forms

Q11. What is the pet peeve of the instructor regarding the wizard in Microsoft Access?
A. The wizard does not automatically save forms
B. The wizard adds unnecessary fields to forms
C. The wizard does not ask for control names
D. The wizard is not user-friendly

Q12. What additional feature is planned to address when a user cancels mid-selection?
A. Implementing an undo function
B. Adding a cancel button to reset values
C. Adding an auto-save functionality
D. Redirecting to a different form

Q13. What issue arises when a new make is added but no models are available?
A. The form crashes
B. An incorrect ID is stored
C. A 'no current record' error is displayed
D. The combo box does not update

Q14. What is the final outcome demonstrated in this part of the tutorial?
A. The form displays error messages successfully
B. The user can pick make, model, and year in a cascading manner
C. The user can add new records directly
D. The user can select multiple options at once

Answers: 1-C; 2-C; 3-B; 4-B; 5-C; 6-C; 7-A; 8-C; 9-B; 10-A; 11-C; 12-B; 13-C; 14-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.