Q1. What is the main improvement made to the attendance form in this video tutorial?
A. Automatically generating student IDs
B. Grabbing the default attendance date from a form field
C. Importing student data from Excel
D. Adding barcode scanning for attendance

Q2. Why is it recommended to avoid spaces in field, form, and object names in Access?
A. It allows for better formatting in reports
B. It makes databases look neater
C. It prevents issues when referencing fields in queries and code
D. It helps with faster data entry

Q3. How is today's date set as the default value in the attendance date field on the main form?
A. By typing it manually each time
B. By using =Now() in the control source
C. By setting the Default Value property to =Date()
D. By binding it to the date field in the attendance table

Q4. What does making the attendance date text box unbound allow you to do?
A. Prevent data from being stored at all
B. Always force attendance to be for today's date
C. Change the attendance date and use it for new records
D. Link it directly to the student list

Q5. What is the purpose of referencing Forms!MainMenuF!AttendanceDate in the attendance form's default value?
A. To display a message when the date is changed
B. To copy the date from the main menu form into new attendance records
C. To update all previous attendance records with the new date
D. To create a calculated field in the table

Q6. What is the advantage of using an append query in this context?
A. It calculates total attendance for each student
B. It automatically adds records for all students on the selected date
C. It deletes outdated attendance records
D. It exports attendance data to another database

Q7. Why was the class date time field missing an entry at first when running the append query?
A. The query was set to select instead of append
B. The studentID field was empty
C. The value for class date time was not specified in the query
D. The attendance table was locked

Q8. What does adding a button to run the append query on the main form accomplish?
A. It validates student attendance
B. It allows users to quickly add attendance records for all students for a specified date
C. It automatically calculates student grades
D. It refreshes the student list

Q9. What method was shown to open the attendance form using a button?
A. Embedding a macro inside the button
B. Typing the code DoCmd.OpenForm "AttendanceF" in the button's event handler
C. Linking to a website
D. Exporting data to Excel

Q10. Why might a user decide to utilize VBA for form and query actions instead of wizards?
A. Wizards cannot be used to open forms
B. VBA provides more flexibility and is quicker for experienced users
C. Wizards cannot create queries
D. VBA is required for basic database operations

Q11. What is the general purpose of an append query in Microsoft Access?
A. Selects and displays records in a datasheet view
B. Deletes specific records from a table
C. Copies records from one table or query and adds them to another table
D. Updates field values for existing records

Q12. When setting up an append query to populate the attendance table, from where is the data being sourced?
A. The attendance table itself
B. The main form only
C. The StudentQ query containing the list of students
D. An external text file

Q13. What happens if you try to append students for a date that already has attendance records for those students?
A. Access creates duplicate student records automatically
B. Access overwrites the existing records
C. Nothing unless additional logic is implemented to check for duplicates
D. Access displays an error and stops working

Q14. Why did the instructor emphasize designing buttons to have a consistent width and height?
A. For improved database performance
B. For security reasons
C. For visual consistency and usability
D. For better exportability to Excel

Q15. What did the instructor say about using the query wizard versus writing VBA code for opening forms?
A. The wizard method is always better than VBA
B. Both methods can work, but VBA is simpler and more flexible for advanced users
C. VBA does not allow opening forms
D. The wizard does not allow setting button captions

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