5 hours ago: Our file storage provider is running maintenance today. If any videos don't load, wait a minute, refresh the page, and try again. Sorry for any inconvenience.  Dismiss
Free Lessons
Fast Tips
Topic Index
Home   Courses   Index   Templates   Seminars   TechHelp   Forums   Help   Contact   Join   Order   Logon  
Home > TechHelp > Directory > Access > Relational Combo < Vehicle Maintenance | Intro to VBA >
Back to Relational Combo    Comments List
Quiz Pinned    Upload Images   Link   Email  
Richard Rost             
2 months ago
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.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Relational Combo.


The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.

Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
My Account
My Courses
Lost Password
Student Databases
Change Email
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Customer Support
Web Site Tour
Consulting Services
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Video Tutorials
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Terms of Sale
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

Copyright 2024 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 7/14/2024 11:01:14 AM. PLT: 1s