Q1. What is the primary function of the buttons or labels described in the video?
A. To jump between different records in a customer table based on the first letter of customer names
B. To delete records from a customer database
C. To create new customer records
D. To update customer information

Q2. What type of form did Dana from Arlington use to view her customer list?
A. Continuous form
B. Single form
C. Datasheet form
D. Split form

Q3. Before creating buttons to jump to a specific letter, what should be set for the customer list?
A. The list should be sorted by a field, such as first name or last name
B. The list should be filtered to show only new customers
C. A specific font size should be applied to the customer names
D. The list should be grouped by customer state

Q4. What is critical to set in the form's properties to maintain sorting order on load?
A. Order by on load should be set to 'yes'
B. Record source should be set to 'dynamic'
C. Allow additions must be disabled
D. Navigation buttons should be enabled

Q5. How did the instructor suggest handling code reusability for multiple buttons in Access?
A. By copying the same code into each button's click event
B. By creating a private subroutine to handle jumps to specific letters
C. By using a public function to redirect all button clicks
D. By linking each button to an external script file

Q6. What VBA command is used to find a record that starts with a specific letter?
A. DoCmd.GotoRecord
B. DoCmd.RunCommand
C. DoCmd.FindRecord
D. DoCmd.OpenTable

Q7. When re-sorting the list upon button click, what property must be set to ensure sorting is applied?
A. Me.OrderByOn must be set to true
B. Me.Filter must be applied
C. Me.RecordSource must be redefined
D. Me.AllowEdits must be set to false

Q8. Which event handler type was suggested to simplify assigning actions to button clicks?
A. A sub
B. A macro
C. A function
D. A query

Q9. What alternate method to buttons did the instructor mention for jumping to a record by letter?
A. Creating a report
B. Using a combo box or list box
C. Establishing a new form
D. Implementing a toggle button

Q10. What does the 'OrderBy on load' property do when set to 'yes'?
A. It allows records to be deleted on form load
B. It keeps the previous session's record open
C. It retains the sort order of records each time the form is opened
D. It orders records alphabetically without user input

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