HeyJaredComputer Learning Zone
Richard Rost is a Microsoft MVP and President/CEO of Computer Learning Zone. He creates video tutorials to teach you how to use your computer, specializing in Microsoft Access.
- Indexed episodes, last 90 days
- 30
- Latest publication
- Sep 26, 2026
- Audience
- Checking…
- Earliest in this view
- Jul 4, 2026
Latest episodes
Microsoft Access Select Queries: Editing Results and More (opens the original)
Read excerpt
Test your Microsoft Access query knowledge with five beginner-friendly questions about select queries. Explore what select queries do, how to filter records without displaying sensitive values, and how sort order works in the query design grid. You'll also learn an important real-world reminder: editing an editable value in a select query changes the underlying table record, not just a temporary result. That can be convenient, but it also means you are working with live data. The quiz also cover
Microsoft Access VBA Quiz: Private Procedures and Control Flow (opens the original)
Read excerpt
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 se
Open the Active Form's VBA Module from the Access Quick Access Toolbar (opens the original)
Read excerpt
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 currently in use. Using Screen.ActiveForm, a public VBA function can identify the active form and open its corresponding Form_ module. A simple RunCode macro provides the bridge needed to place that fun
Microsoft Access Control Text Colors and RGB Quiz (opens the original)
Read excerpt
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 values. It also covers changing FontSize with a macro and a common snag when pasting hexadecimal color-picker codes like #FF0000 into a SetValue action. A useful refresher for anyone building Access forms t
Microsoft Access Relationships Quiz: Deleting Customers and Related Contacts (opens the original)
Read excerpt
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, and when cascade deletes can change the outcome. It is a useful reminder that deleting a parent record without considering its children can create data problems fast. The quiz also covers the requiremen
Publishing over time
Last 90 days. Choose a month to open its work.
Recurring subjects
Named in the text we hold. One piece can cover several.
Not enough subject data for this period yet.
Audience
No verified audience measurement yet.
About this data
Counts cover the work we have indexed. Tone needs enough text and a confident classification. Excerpts and episode notes are not full articles or transcripts.
Identity or attribution wrong? Suggest a correction.