Q1. What is the main advantage of having an 'edit mode' in a database form?
A. It allows users to automatically update records without confirmation
B. It prevents accidental changes by requiring users to explicitly enter edit mode
C. It hides sensitive data from all users
D. It automatically backs up the database

Q2. What is the downside of setting the form's AllowEdits property to False to create a read-only mode?
A. It deletes all data from the form
B. It locks all controls, including those you may want to remain editable
C. It hides all controls except buttons
D. It prevents the form from opening

Q3. What was Ken's issue with the original edit mode technique?
A. The combo box in the header used for record selection became locked and unusable
B. The form would not display any records
C. The database would corrupt on entering edit mode
D. The buttons would disappear

Q4. What is the suggested solution for locking only specific controls on a form?
A. Set AllowEdits property to False for the form
B. Use the Locked property of each individual control you want to secure
C. Delete all unwanted controls
D. Place all controls in subforms

Q5. What is the main drawback of manually setting the Locked property for each individual control in code?
A. The code does not work for checkboxes
B. It requires hardcoding and is difficult to maintain as fields are added or removed
C. It prevents the form from opening
D. It significantly slows down form loading

Q6. What property is recommended for identifying which controls should be locked in the subroutine?
A. Name property
B. ControlSource property
C. Tag property
D. Visible property

Q7. How does the recommended subroutine determine which controls to lock?
A. By checking if the control's Tag property matches a specific value
B. By checking if the control is visible
C. By checking the label caption
D. By looping through only textboxes

Q8. When creating the code to lock fields, what type of argument is passed to indicate whether to lock or unlock the controls?
A. String
B. Integer
C. Boolean
D. Currency

Q9. In the For Each loop for controls, what variable type is used for the control variable?
A. Variant
B. Control
C. Object
D. Collection

Q10. What should you be cautious about when using the BackColor property in the lock/unlock routine?
A. Only textboxes and combo boxes support BackColor, not all control types
B. It changes the font color instead
C. It can cause the database to close
D. It deletes existing data

Q11. What technique is demonstrated to prevent runtime errors when changing properties that some controls do not have?
A. Using Stop statement
B. On Error Resume Next to skip errors for unsupported controls
C. Using If statements for every control property
D. Deleting all unsupported controls

Q12. What is the role of Debug.Print in the code example?
A. It prints values to an external file
B. It displays the value in the Immediate Window for troubleshooting
C. It highlights errors in the Current event
D. It changes the value of the control

Q13. Why is it important to turn AllowEdits back to Yes for the form when switching to the new lock/unlock strategy?
A. The new approach depends on the form's AllowEdits property to allow any control to be edited
B. AllowEdits must be set to No for code to function
C. Locking properties of controls only work with AllowEdits set to No
D. It prevents users from printing the form

Q14. Why is it helpful to visually gray out locked fields?
A. It prevents users from seeing the data
B. It provides a visual cue that the field is read-only
C. It reduces eye strain
D. It speeds up data entry

Q15. What is the correct statement about error handling with On Error Resume Next in this context?
A. It should always be used in all procedures
B. It can hide important bugs if not used carefully
C. It is only allowed in public procedures
D. It only works in Access 2007 and later

Q16. What is the main difference between a subroutine and a function in VBA, as discussed in the video?
A. A subroutine can return multiple values
B. A subroutine does not return a value, unlike a function
C. A subroutine can only be used for mathematical calculations
D. A subroutine cannot execute code


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