ABOUT THIS EPISODE
Test your Microsoft Access VBA knowledge with five quick questions about private procedures, procedure parameters, Select Case statements, ElseIf chains, and operation-specific validation.
Learn why a Private Sub stays local to its form module, how arguments such as "Add" are passed into a procedure, and why Select Case can make a calculator-style routine easier to read and maintain.
The quiz also covers a common control-flow detail: ElseIf stops checking later conditions after a match, while separate If statements continue evaluating. Plus, see why divide-by-zero validation belongs inside the division case, right before the calculation happens.
English
United States
TRANSCRIPT 🔗
Are you the producer of this podcast?
Add a podcast transcript
Need Audio-to-Text?
Transcribe with Listen411 in Just 60 Seconds
SEARCH PAST EPISODES
Search past episodes of Computer Learning Zone.
OTHER EPISODES IN THIS PODCAST
Test your Microsoft Access control formatting knowledge with a quick quiz on text colors, RGB expressions, and macro-driven property changes.
Learn the difference between ForeColor and BackColor, why RGB(0, 0, 255) produces blue, and how RGB expressions help Access assign usable numeric color valu…
When an Access form is already open, filtered, and positioned on the record you need, switching views just to reach its VBA code can be an annoying interruption. This episode covers a small developer customization that adds a Quick Access Toolbar button for opening the code module behind the form c…
Test your Microsoft Access relationship skills with five expert-level questions about parent and child tables, one-to-many relationships, subdatasheets, orphaned records, and referential integrity.
Find out what happens when you try to delete a customer who still has related contacts, why Access bl…
Test your Microsoft Access relationship knowledge with five questions about parent and child tables, subdatasheets, orphaned records, and referential integrity.
Find out what happens when you try to delete a customer who still has related contact records, why Access normally blocks that deletion, …
Disclaimer: The podcast and artwork embedded on this page are from Richard Rost, which is the property of its owner and not affiliated with or endorsed by Listen Notes, Inc.
EDIT
Thank you for helping to keep the podcast database up to date.
