Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   Index   Templates   Seminars   TechHelp   Forums   Help   Contact   Join   Order   Logon  
 
Home > TechHelp > Directory > Access > Big Button Form 5 < Big Button Form 4 | Big Button Form 6 >
Back to Big Button Form 5    Comments List
Pinned    Upload Images   Link   Email  
Quiz
Richard Rost 
            
5 months ago
Q1. In the tutorial, what is used to store the return value when a button is clicked?
A. A global variable
B. A message box
C. A temp var
D. A form property

Q2. How is the return value typecast when storing it in the temp var?
A. As a string (CStr)
B. As a double (CDbl)
C. As a long (CLng)
D. As a Boolean (CBool)

Q3. What is the purpose of setting the temp var in the code?
A. To display the clicked button's caption
B. To store the ID value for use by the calling form
C. To save the user's preference
D. To debug the button click event

Q4. After storing the return value, what action is taken next in the code?
A. The form is minimized
B. The form is closed
C. A message box is displayed
D. The form is refreshed

Q5. What is the eventual goal mentioned in the tutorial regarding selecting multiple options?
A. To allow batch processing
B. To create dynamic reports
C. To potentially handle multiple selections in a future series
D. To improve the user interface design

Q6. How does the customer form use the temp var?
A. It updates the database directly
B. It displays the returned ID in a text box
C. It shows the returned ID in a message box
D. It logs the ID to a file

Q7. Which variables are declared to store the information needed from the button clicks?
A. VMakeID, VModelID, VYearID
B. VarMake, VarModel, VarYear
C. VMakeCode, VModelCode, VYearCode
D. TempMake, TempModel, TempYear

Q8. What SQL modification is necessary to display models based on the selected make?
A. Adding an ORDER BY clause
B. Creating a new table
C. Adding a WHERE condition for vMakeID
D. Converting model IDs to strings

Q9. What common mistake is highlighted when adjusting the SQL statement?
A. Forgetting to alias the table names
B. Forgetting to add spaces around keywords
C. Incorrectly using JOIN clauses
D. Using reserved SQL keywords as column names

Q10. What is the ultimate purpose of the cascading combo boxes?
A. To dynamically filter and display options based on prior selections
B. To provide predefined static lists for user selections
C. To update database records in real-time
D. To simplify the user interface by reducing the number of forms

Q11. What is the pet peeve of the instructor regarding the wizard in Microsoft Access?
A. The wizard does not automatically save forms
B. The wizard adds unnecessary fields to forms
C. The wizard does not ask for control names
D. The wizard is not user-friendly

Q12. What additional feature is planned to address when a user cancels mid-selection?
A. Implementing an undo function
B. Adding a cancel button to reset values
C. Adding an auto-save functionality
D. Redirecting to a different form

Q13. What issue arises when a new make is added but no models are available?
A. The form crashes
B. An incorrect ID is stored
C. A 'no current record' error is displayed
D. The combo box does not update

Q14. What is the final outcome demonstrated in this part of the tutorial?
A. The form displays error messages successfully
B. The user can pick make, model, and year in a cascading manner
C. The user can add new records directly
D. The user can select multiple options at once

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

 
 
 

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

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

LinkedIn
Copyright 2024 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 12/14/2024 8:41:43 AM. PLT: 1s