Skip to content
Artwork for Computer Learning Zone

Computer Learning Zone

Richard Rost

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.

Play
  • 60 episodes
  • Avg 14 min
  • English
Counted on this page — what you have heard stays on this device, so it is not something the list can be paged by.
  • Yesterday · 13 min

    Before the Web: The World of Dial-Up BBSes

    Before websites, social media, and always-on internet access, people connected by dialing one computer directly from another. This episode looks back at bulletin board systems, or BBSes, where users traded messages and files, played text-based games, and found communities built around shared interests.

  • Yesterday · 3 min

    Microsoft Access Report Detail Sections and Full-Sheet Labels Quiz

    Test your Microsoft Access report knowledge with five quick questions about what controls Detail section printing, using open-form references, and generating full sheets of mailing labels. Learn why a report's Record Source determines how often the Detail section prints, why a form must stay open when a report reads its controls, and how a simple 30-record table can act as a label-position generator. The episode also covers a common limitation of repeating labels from a single customer form. It works well when every label needs the same text, but it is not the right approach when individual labels need different values.

  • Tuesday · 9 min

    Can Your Microsoft Access Database Run Without You?

    What happens when the person who built the database is unavailable for a week? Can employees still enter data, run reports, recover from common mistakes, and keep routine processes moving without calling the developer for help?

  • Monday · 3 min

    Microsoft Access Form Totals and Inventory Value Quiz

    Test your Microsoft Access form calculation skills with a quick expert-level quiz on totals, aggregate functions, and inventory value. This episode covers where footer totals belong in continuous forms and subforms, along with the practical differences between Sum, Count, and Max.

  • Sunday · 11 min

    Fixing Wrong Combo Box Selections in Microsoft Access UNION Queries

    When a Microsoft Access combo box is populated by a UNION query, it can appear to work perfectly until selecting one item suddenly displays another. The usual culprit is a duplicate numeric ID coming from different tables, such as Employee ID 15 and Customer ID 15. This episode explains why AutoNumber values are unique only within their own tables, not across a combined query result. When a combo box binds to the shared number alone, Access cannot tell which source record was actually selected. Learn how a simple prefixed selector value, such as E15 and C15, prevents these ID collisions without changing the underlying tables. The discussion also covers a real example involving foods and meals, plus what to consider when VBA code needs to determine which source table the selected item belongs to.

  • Saturday · 3 min

    Why Microsoft Access Warns You About Downloaded Database Files

    Downloaded Access databases can trigger security warnings for a good reason: they may contain active content such as macros, code, or other features that should not run automatically until you trust the source. This quick beginner quiz explains what those warnings mean and why they matter. It also covers a few practical Access habits that save headaches, including extracting database files from ZIP folders, using trusted locations appropriately, creating desktop shortcuts instead of duplicate files, and not worrying about gaps in AutoNumber values. Test your Access basics and see whether you are ready to keep your database vault secure.

  • November 6 · 24 min

    Microsoft Access Inventory Relationships, Search Queries, and Nested Subforms

    In part two of this Microsoft Access inventory database series, learn how to connect locations, areas, subdivisions, and items with proper one-to-many relationships and referential integrity. The focus is on keeping inventory data organized so items cannot be assigned to locations that do not exist, while avoiding the risks of cascade deletes.

  • November 5 · 50 min

    VB, VBA, VB.NET, VBScript, and VB6: What Is the Difference?

    VB, VBA, VB.NET, VBScript, and VB6 share a family resemblance, but they are not interchangeable. The key question is not which version sounds newest, but where the code runs and which objects, libraries, and runtime it depends on. For Microsoft Access developers, the answer is VBA, or Visual Basic for Applications. Learn why Access VBA examples differ from Excel VBA, why old VB6 projects are different from modern Visual Basic on .NET, and why similar syntax can still lead you toward the wrong help or code samples. This episode also covers VBScript's aging role in Windows automation, Microsoft's plans to phase it out, and why inherited VBS files need a different maintenance plan. Whether you are writing code behind an Access form, maintaining a VB6 application, or working in Visual Studio, knowing the branch of Visual Basic you are using matters.

  • November 2 · 3 min

    Microsoft Access Password Prompts and Hidden Input Options

    Can Microsoft Access hide password characters typed into a standard InputBox? This quick quiz explores why the built-in InputBox cannot display asterisks and why a custom form with a password-masked text box is the better choice when users need a more polished password prompt. Along the way, it covers practical Access macro design: keeping shared passwords in a settings table, using DLookup criteria to retrieve the correct value, and making sure OpenForm runs only after the entered password matches the expected one. It also includes an important security reality check. A password prompt can protect a menu path, but it does not secure every route into a database, especially when a plain-text password remains accessible in a table or the database design.

  • October 28 · 8 min

    Getting the New AutoNumber ID in Microsoft Access VBA

    When VBA adds a new record in Microsoft Access, you often need the AutoNumber ID immediately afterward. That ID lets you open the exact order, customer, or log entry your code created instead of guessing based on the highest number or the newest-looking row. In this episode, Richard explains why relying on Max(ID), sort order, or the last record in a form can fail in a multi-user database. Someone else may add a record at nearly the same time, leaving your code pointed at the wrong row without producing an obvious error. The discussion uses a recordset and AddNew example from a food log database, showing the basic idea of returning the newly assigned ID from a function. With that key in hand, your calling code can reliably find the new record, move the form to it, or use it to create related records after the save succeeds.

  • October 25 · 8 min

    Why Tiller Was Not a Good Fit for My Microsoft Access Workflow

    Richard Rost shares his eight-month experience trying to use Tiller as a bridge between financial accounts, Excel, and a Microsoft Access database. The goal was simple: reduce the daily time spent checking balances and recent transactions across multiple accounts. Instead, the workflow required repeated logins, account reconnections, authentication prompts, unreliable add-in behavior, and too many stale balances. Importing Excel data into Access was never the problem. The real issue was getting consistently fresh data into the spreadsheet without manual intervention. This is a practical look at the difference between automation that sounds convenient and automation that actually saves time. Richard also explains why a supported API would better fit an Access-based workflow, and why he ultimately returned to gathering data directly from the financial sites he already checks.

  • October 22 · 6 min

    When Security Measures Cost You Customers

    What happens when fraud prevention is so strict that legitimate customers cannot complete a purchase? Richard shares his frustrating attempt to buy concert tickets, complete with valid credit cards, matching billing details, repeated authorization holds, and front-row seats that disappeared while the checkout system rejected him. The bigger lesson applies far beyond ticket websites. Overly aggressive validation, endless confirmations, and rigid permissions can make software feel secure while driving away the people it is supposed to serve. Good security should match the actual risk, provide clear feedback, and give legitimate users a practical way to recover from ordinary mistakes. A system that blocks everything may be safe, but it is not very useful.

  • October 21 · 19 min

    Getting Started with the Microsoft Access Expression Builder

    The Expression Builder can look intimidating at first, especially when Access presents a long list of functions, fields, operators, and database objects. This episode explains what an expression is, what the Builder is designed to do, and when it is helpful to use instead of typing everything by hand. Learn how expressions can calculate values such as an order line total, and how the Builder can help locate the correct name and syntax when referencing a control on an open form. It is especially useful when you know what result you need but cannot remember the exact function, form name, or control name. Richard also covers common expression basics, including fields, operators, functions, brackets, quotes, and parentheses. The main takeaway is simple: start with small expressions you can verify, check the results carefully, and use the Builder as a guide while the syntax becomes familiar.

Showing 1–20 of 60 episodes