Q1. What is the main goal demonstrated in the video tutorial?
A. How to create a report that summarizes customer orders
B. How to open a modal form above an active control and return a value to that control
C. How to export data from Access to Excel
D. How to secure a database with a password

Q2. What is the difference between a modal form and a pop-up form as discussed in the video?
A. Modal forms can be accessed behind while open, pop-up forms cannot
B. Modal forms require user interaction before returning to the main form, pop-up forms just stay on top of other forms
C. Modal forms can move outside the application window, pop-up forms cannot
D. There is no difference between modal and pop-up forms

Q3. Why did Richard recommend not setting the "Pop Up" property to Yes for this example?
A. Because pop-up forms cannot be closed easily
B. Because pop-up forms are not supported in newer versions of Access
C. Because pop-up forms may appear outside the Access window and are harder to position accurately
D. Because pop-up forms require advanced VBA skills

Q4. What technique is suggested for determining where to position the modal form?
A. Use the form's DefaultView property
B. Add a fixed offset from the top left corner of the main form
C. Calculate x and y coordinates by adding ActiveForm's WindowLeft/WindowTop to ActiveControl's Left/Top properties
D. Place the modal form at the center of the screen every time

Q5. Why is it preferable to use a reusable function like PopUpOverControl rather than hard-coding coordinates for each control?
A. To ensure compatibility with all database versions
B. To reduce redundant code and make applying the feature to more controls easier
C. To make the code more complex for learning purposes
D. To allow pop-up forms to work in web browsers

Q6. What purpose do the VBA object variables ActiveCtl and ActiveFrm serve in this process?
A. They store the last values entered by the user
B. They hold references to the currently active control and form for use in calculations
C. They contain calculated window coordinates for the modal form
D. They track how many forms are open in the application

Q7. What is the significance of setting ActiveCtl = Nothing and ActiveFrm = Nothing at the end of the process?
A. It resets the form to its original position
B. It closes the modal form automatically
C. It releases object variables from memory to avoid potential issues
D. It triggers the value to return to the main form

Q8. What problem is avoided by turning off the Maximize and Minimize buttons on the modal form?
A. Users accidentally closing the form
B. Users being unable to move the modal form by grabbing the title bar
C. The modal form being resized dynamically
D. The appearance of extra scroll bars

Q9. When the modal form is opened over a control, how is the initial value to be edited set in the ReturnValue text box?
A. By manually typing it in before opening the form
B. By passing the current value from the active control to the modal form after opening it
C. By always displaying a default value such as "Picard"
D. By using a TempVar to retrieve it on form load

Q10. Why is it important to Compile the VBA code after writing or modifying it?
A. To see how many lines of code were added
B. To ensure that errors are caught before running the code in Access
C. To make the modal form visible in the navigation pane
D. To export the code to a text file

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