Q1. Why is it important to set up sorting within a report in Access, instead of relying solely on sorting in the query?
A. Because reports will ignore query sorting and use their own
B. Because query sorting is more complex than report sorting
C. Because reports can only sort numeric fields from queries
D. Because sorting in queries is not possible in Access

Q2. What must be done to ensure that a report is sorted first by student name and then by customer ID?
A. Place the sort by customer ID above the sort by student name
B. Place the sort by student name above the sort by customer ID
C. Only sort by one field at a time
D. Remove the group by customer ID option

Q3. When sorting attendance records within each group in the report, how should the dates be sorted?
A. In random order
B. With the oldest dates at the top (ascending)
C. By student name first, then date in descending order
D. By class name first

Q4. According to the video, if you want to display the report showing each date with the students absent for that date, how should you adjust the sorting?
A. Sort first by date, then by student
B. Sort only by student, then by class
C. Sort by class first, then by date
D. Only use one group at a time

Q5. What is the main advantage mentioned for learning basic VBA in Access?
A. It is required to use filters in reports
B. It allows you to make your databases more powerful
C. It eliminates the need for queries
D. It is the only way to create tables

Q6. In VBA, how do you represent a date literal in a filter string for Access?
A. By surrounding the date with asterisks
B. By surrounding the date with pound symbols
C. By surrounding the date with double quotes
D. By surrounding the date with parentheses

Q7. What property must be set to True to apply the filter in Access using VBA?
A. FilterApply
B. FilterOn
C. ApplyFilter
D. DoFilter

Q8. What is the purpose of the AttendanceAppendQ query mentioned in the lesson?
A. To delete old attendance records
B. To append/add new student attendance records for a specific date
C. To filter the attendance records
D. To generate a report of absent students

Q9. Why is it important to requery the form after running the append query to add new students?
A. To save changes to the database
B. To refresh the form and show the updated records
C. To reset all filters
D. To close the form and reopen it

Q10. What potential issue arises if you run the "Add Students" process for a date where students have already been added, and how does the video suggest handling it in the extended cut?
A. No issue, students can be added as many times as needed
B. Attendance records will be duplicated; code should check if records already exist and confirm before appending again
C. Students will be removed; data must be restored from backup
D. There is no way to resolve this

Q11. What is a suggested way in the video to handle situations where you may have forgotten to take attendance on previous dates?
A. Ignore those dates completely
B. Manually check calendars for missed days
C. Write code to detect missing attendance records and prompt the user
D. Re-enter all data for the semester

Q12. Why did the instructor recommend naming buttons such as AddStudentsBtn in forms?
A. Because unnamed buttons are not recognized by VBA
B. Because it is easier to reference and maintain in code
C. Because Access does not allow unnamed controls
D. Because unnamed buttons cause errors in queries

Q13. What was one of the advanced options or features suggested by users for future attendance system videos?
A. Using a barcode reader to scan students in
B. Sorting by phone number
C. Automatically sending emails for absences
D. Printing ID cards for all students

Q14. According to the instructor, what is the purpose of the TechHelp video series with respect to Attendance, as opposed to the Access Expert templates?
A. To provide a fully built, production-ready attendance system
B. To help beginners get started and learn concepts
C. To address only theoretical uses of Access
D. To focus only on coding and programming techniques

Q15. What does the instructor say about learning VBA for Access?
A. You will master it in twenty minutes
B. It is easy to get started, but it takes a long time to master
C. Only experts should attempt to learn it
D. It is not necessary for creating efficient Access databases

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