Q1. What is the purpose of creating a combo box in Microsoft Access as demonstrated in the video?
A. To store multiple values in a single field
B. To allow selection from a list of values in another table or query
C. To input text data directly into the database
D. To manually enter data into separate fields

Q2. Why is a relational combo box preferred over a value list combo box in multiple forms?
A. It ensures faster processing of form data
B. It lets you store values in text format for better readability
C. It allows automatic updates of values across multiple forms without manual updates
D. It simplifies the process of manual data entry

Q3. Which field is used to relate the combo box values to the customer table?
A. Title name
B. Auto number
C. Primary key
D. Title ID

Q4. In the context of creating the combo box, why is it important to watch the concatenation video?
A. To learn how to set up primary keys and foreign keys
B. To understand how to combine first name and last name into a single field for display
C. To learn how to update multiple forms automatically
D. To understand the principles of database relationships

Q5. What type of data field should be used to store the title ID in the customer table?
A. Text
B. Short text
C. Long integer
D. Auto number

Q6. How do you ensure that the combo box displays both first name and last name in the desired format?
A. By adding multiple fields directly into the combo box
B. By using a query that concatenates the first name and last name into a single field
C. By manually typing both names into the combo box
D. By using a value list combo box

Q7. What is the purpose of the "onNotInList" event in a combo box?
A. To automatically update all forms with new values
B. To prevent users from entering data not present in the list
C. To allow users to add new items to the list dynamically
D. To sort the list of values in alphabetical order

Q8. When setting up the combo box, what is the importance of hiding the key column?
A. It makes the form visually cleaner by hiding unnecessary data
B. It allows for easier manual updates of the combo box values
C. It prevents data entry errors by hiding primary keys from the user
D. It ensures the combo box sorts values correctly

Q9. In the Service Table, why should you avoid using reserved words like "date" and "name"?
A. To simplify data entry and management
B. To prevent potential conflicts and errors within Access
C. Because they take up extra storage space in the database
D. To ensure easy readability of the database schema

Q10. Why is it beneficial to use a relational combo box in multiple forms within the same database?
A. It reduces the number of tables needed in the database
B. It ensures data consistency and reduces redundancy
C. It increases the complexity of database queries
D. It allows for easier manual updates to the database

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