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

Open in

22 episodes
Avg 20 min
English

Episodes 22

Newest Oldest Longest

All20 Unplayed20 In progress0 Played0

Counted on this page — what you have heard stays on this device, so it is not something the list can be paged by.

Monday · 23 min
Understanding BOF and EOF in Microsoft Access Recordsets
BOF and EOF are easy to memorize in Access VBA, but understanding what they mean can save you from some very confusing recordset behavior. This episode explains why EOF alone does not prove a query returned no records, especially after code has moved past the last row. Learn how DAO recordsets track a current record, what happens when you use MoveNext or MovePrevious, and why BOF and EOF are boundary positions rather than actual records. The key empty-recordset test, rs.BOF And rs.EOF, makes much more sense once you can visualize what is happening. We also cover practical details such as where a normal recordset starts after OpenRecordset, why RecordCount can be misleading, and why navigation and deletions can affect what those flags tell you.
August 19 · 31 min
Microsoft Office Installation Problems: Common Causes and Safe Fixes
Microsoft Office installation failures can be frustrating, especially when the error message offers little more than "something went wrong." This episode covers the common reasons Word, Excel, Access, and Microsoft 365 may refuse to install. Learn why leftover files from older Office versions, pending Windows updates, antivirus interference, low disk space, installer issues, and 32-bit versus 64-bit conflicts can stop an installation in its tracks. Access users in particular can run into trouble when Office components and runtimes do not match. The focus is on starting with simple, Microsoft-supported troubleshooting instead of jumping straight into registry edits, mystery repair tools, or risky downloads. Sometimes the real fix is less dramatic than expected, but it can save a lot of time and prevent making the problem worse.
August 5 · 23 min
Calculating Overlapping Date Ranges in Microsoft Access
Need to know how many calendar days two date ranges have in common? This episode covers a simple, reusable VBA approach for Microsoft Access that works whether ranges partially overlap, one contains the other, or they do not overlap at all. The key is to identify the later start date and earlier end date, then handle the important no-overlap check before calculating the result. Richard also discusses the often-missed difference between inclusive dates and date ranges where the ending day is not counted. Along the way, hear about a real copy-and-paste bug involving the comparison operator, why date math can be simpler than DateDiff for day counts, and practical uses for reservations, rentals, payroll periods, warranties, subscriptions, and utility bill splitting.
August 4 · 23 min
How to Check Whether Your Microsoft Access Back End Is Still in Use
Before compacting a shared Microsoft Access back end, restoring a backup, or changing table designs, it helps to know whether anyone is still connected. A small Access lock file can provide a quick warning that the database may be in use. Richard Rost explains what LACCDB and LDB lock files do, why they are useful in split databases, and why their presence is not always proof that someone is actively working. A crash, lost network connection, or powered-off workstation can leave behind a stale lock file. You'll also hear about a simple VBA approach for checking whether a back-end lock file exists, along with an important caveat for unbound startup forms that may not touch linked tables immediately. It is a practical way to avoid turning routine maintenance into a very interesting Tuesday.
August 2 · 30 min
Microsoft Access Help: Finding Reliable Answers, Community Support, and Expert Help
Getting stuck in Microsoft Access can lead to a flood of conflicting search results, outdated advice, and more questions than answers. This episode looks at where to find dependable help, from Microsoft's documentation and built-in F1 support to active Access forums, technical communities, news sites, and professional consultants. Richard Rost explains how to match the kind of problem you have with the right source of support. A simple feature question, a tricky SQL or VBA error, a database design issue, and a large business project may each call for a different kind of help. You'll also hear practical advice for asking better questions, including sharing the goal, exact error message, relevant code, screenshots without private data, and what you have already tried. Better questions lead to faster answers and make life easier for the volunteers helping you. Finally, the episode covers when training, tutoring, or hiring an Access consultant makes sense, plus why learning the language of databases can make you a more confident user and a better customer.
August 2 · 30 min
Pulling Data in Microsoft Access: Queries, Imports, and Copies
"What does it mean to pull data in Access?" It sounds simple, but the answer depends entirely on where the data lives, where it needs to go, and whether you want a live view or a permanent copy. This episode clears up the most common meanings behind the phrase. Learn when to use a relational query to display customer details alongside orders, when copying values is appropriate for historical records such as shipping addresses and prices, and when imports, linked tables, staging tables, or VBA may be the better fit. We also cover single-value lookups, retrieving sets of records with select queries, exporting data to other programs, and why it matters which application is doing the "pulling." The key is asking the right questions before choosing an Access tool.
July 31 · 25 min
Microsoft Access Forms and Queries: Why Your Data Is Read-Only
Can you see your records in Microsoft Access but suddenly cannot edit them? A form that beeps, a locked field, or a query that opens read-only can be frustrating, especially when the database worked fine yesterday. This episode explains why the form is often just the messenger. The real issue may be the underlying table, a linked data source, network permissions, record locks, form properties, control settings, or a query Access cannot safely update. We also look at common troublemakers like totals queries, DISTINCT, calculated fields, joins, missing primary keys, outer joins, and overly complicated multi-table recordsets. Plus, a few developer-level causes involving VBA, SQL Server permissions, trusted locations, and the occasional Access bad hair day. The key is to isolate the problem instead of staring at a giant query and hoping for inspiration. Start simple, test the table, query, and form independently, then find the feature that turns editable data into a read-only recordset.
July 31 · 31 min
Understanding Microsoft Access VBA Class Modules
Class modules can seem intimidating in Microsoft Access VBA, especially if most of your code lives in standard modules and form events. This episode explains what class modules actually are, how they differ from tables, forms, reports, and standard modules, and why they are not something every Access developer needs to use. Learn the basic object-oriented ideas behind classes, including blueprints, objects, instances, properties, methods, encapsulation, and the difference between Property Get, Property Let, and Property Set. A simple employee class example shows how separate objects can each retain their own data and behavior. We also cover when class modules can be useful, such as modeling customers, employees, invoices, shopping carts, or reusable form behavior. Just as importantly, we discuss when a plain standard module is the clearer and better choice. Classes are a useful advanced tool, but they do not replace good relational table design or make a database better simply because they sound fancy.
July 28 · 2 min
Microsoft Access Basics Quiz: Tables, Orders, Forms, and Reports
Test your Microsoft Access fundamentals with five beginner-friendly questions covering the building blocks of a well-designed database. Learn why tables store data, why customer orders belong in a separate orders table, and why splitting first and last names can make sorting, filtering, and personalized letters much easier. The quiz also clears up the practical difference between forms for on-screen data entry and reports for printed output like invoices and labels. A quick, useful refresher for new Access users who want to avoid common database design mistakes.
July 22 · 11 min
Windows Two-Digit Year Cutoff: Why Dates Become 2040 and How to Change It
Why does entering a date like 11/40 in Excel or Microsoft Access turn into 2040 instead of 1940? The answer is Windows' two-digit year cutoff, a system setting that decides which century a two-digit year belongs to. This episode explains why the cutoff exists, why Excel and Access can interpret dates the same way, and why the default behavior may be a problem for medical offices, genealogy work, museums, cemetery records, and other historical data entry. Learn when changing the Windows cutoff may make sense, why relying on two-digit years can create inconsistent data between computers, and why entering a full four-digit year in ISO format is still the safest habit.
July 21 · 26 min
Going Online: Migrating Microsoft Access Databases to SQL Server
Ready to take your Microsoft Access database from your office desktop to a fully online solution? In this episode, we explore one of the most practical challenges for Access users: connecting your Access data to SQL Server and making it accessible from anywhere with an internet connection. Your host, Richard Rost from Access Learning Zone, walks you through the whole process, highlighting the tools you will need, common pitfalls, and tips for smooth sailing. You will learn what SQL Server Management Studio actually does, why ODBC connections matter, and how to think about security and performance as you transition. With clear explanations, seasoned advice, and some honest opinions about Microsoft tools (like the Migration Assistant), this episode strips away the confusion and shows what actually matters along the way. Whether you are a business owner trying to enable remote work, an Access veteran ready to scale up, or just curious about bringing legacy databases into the cloud era, this episode is a friendly and realistic guide to making your move. Get insights into linking tables, optimizing for speed, and keeping your data secure as you bring Access and SQL Server together.
July 20 · 2 min
Microsoft Access Relational Database Quiz 2: Tables, Relationships, and Junction Tables
Put your Microsoft Access relational database knowledge to the test with five questions covering the building blocks of a well-designed database. This quiz explores how related tables work together, why a vehicle record should store a CustomerID instead of repeating customer details, and how one-to-many relationships handle customers with multiple orders or vehicles. It also covers the many-to-many relationship and the role of junction tables when both sides of a relationship can have multiple related records. A quick, practical review for Access users who want to avoid duplicate data and design cleaner databases.
July 17 · 19 min
Why Your Microsoft Access Database Is Read Only and How to Fix It
Have you ever opened your Microsoft Access database and found you suddenly cannot make changes because it is locked in read only mode? You are not alone. In this episode, Richard Rost from Access Learning Zone breaks down why this happens, what "read only" actually means in Access, and the most common (and easily overlooked) reasons this frustrating problem occurs. From simple slip-ups like accidentally opening your database in read only mode, to Windows security settings, network folder permissions, stale lock files, and the special nuances of ACCDE files, Richard highlights the practical issues you are most likely to face. You will also hear about sneaky culprits like file sync services and antivirus programs that can put your Access files into lockdown without you realizing. If you deal with Microsoft Access in your work or studies, understanding how to get your database back into normal working mode is a must. Listen in for a clear, conversational breakdown that will leave you feeling confident the next time Access locks you out. Stay tuned for some laughs, real-world anecdotes, and expert advice to avoid future headaches.
July 15 · 2 min
Getting Started With Microsoft Access: Key Objects and Common Questions
If you are new to Microsoft Access, this episode is a fun and informative way to brush up on the basics. Join us for a lighthearted quiz covering essential Access terms, like which object actually stores your data and what types of objects are used for different tasks in the database. Whether you are confused by terms like table, field, and record or just want to make sure you are using the right tool for printing reports, this episode has you covered. We cover common beginner pitfalls and help you understand not just what these objects are called, but why it matters. By the end, you will have a clearer sense of how Access organizes information and what makes it a relational database system. Perfect for first-time learners or anyone looking for a quick knowledge refresher. Keep track of your score or just play along and see how many you get right. And remember, mastering the basics is where all Access pros begin.
July 13 · 33 min
How to Fix the Automation Error Catastrophic Failure in Microsoft Access
Ever opened your Access database to see the dreaded "Automation Error Catastrophic Failure" and wondered if all is lost? You are not alone. On this episode, we demystify one of the most alarming errors in the Microsoft Access world and explain why - despite its over-the-top name - it is rarely as disastrous as it sounds. Join instructor Richard Rost as he breaks down what typically causes this error, from corrupted compiled VBA code to missing references or problematic ActiveX controls. Learn why Access sometimes throws its hands up after a crash or update, and discover practical, real-world troubleshooting advice to get your database back on its feet. You will also hear about the importance of backups, how to use decompile and compact and repair features, and ways to avoid common pitfalls that trip up Access users. Whether you are a database pro or you just inherited a mission-critical Access file, this episode offers the clarity and confidence you need to tackle catastrophic failure - and keep your database running smoothly.
July 10 · 23 min
Getting Your Microsoft Access Data Online with SQL Server and WinHost
Thinking about moving your Microsoft Access database online so it is easier to share with remote employees or access from anywhere? In this episode, Richard Rost from Access Learning Zone guides you through everything you need to know to set up a SQL Server online hosting account with WinHost. Learn why hosting your database in the cloud is more accessible and affordable than ever, and get a behind-the-scenes look at choosing a hosting provider, selecting the right plan, handling domains, and making sense of the jargon. Richard shares his hands-on experience, plus practical tips about domain setup, SSL certificates for security, getting your connection strings right, and pitfalls to avoid. If you have ever been frustrated with unreliable web hosts or worried about setting up online infrastructure, this conversation will set your mind at ease and get you ready to connect Access to a SQL Server in no time. Whether you are setting up a new company database or just want to make your tools more modern and mobile, this episode is the perfect place to start. Grab your notepad and let Richard break it all down in plain English with a few nerdy stories along the way.
July 9 · 13 min
Tracking How Long an Access Form Was Open Without Timers
Ever wished you could see how much time you spend working in different parts of your Microsoft Access database, but hate the idea of a constant ticking timer? In this episode, host Richard Rost from Access Learning Zone tackles a practical challenge: measuring the time a form stays open in Access, all without using a distracting or potentially problematic timer event. Learn how to use simple VBA and TempVars to log when a form opens, calculate the elapsed time once it closes, and display the results in a user-friendly way. Richard also explains why TempVars are a smart, reliable choice for this job, and shares tips for making your message display more polished for your users. Whether you are curious about your own productivity or want to spot bottlenecks in your workflow, this technique can help you monitor and improve your everyday Access tasks. Along the way, enjoy practical insights, relatable examples, and some candid developer humor, as you pick up ideas that can make your Access databases more informative and user friendly - without any heavy-handed monitoring. If you want to dig deeper, hear about building a reusable framework to track multiple forms and log results for reporting.
July 8 · 15 min
Access Databases Online with SQL Server: Work Remotely and Collaborate Anywhere
Wish you could access your Microsoft Access database from anywhere, not just the office? In this episode, Richard Rost explains how to host your Access database online using SQL Server, making it easy for remote employees, travelers, and multi-location teams to work together seamlessly. You will hear about the pros and cons of moving your data online, essential tips for security, performance, and backups, and the real-world challenges when transitioning from a traditional Access backend. Richard also shares his personal experiences managing database servers, what goes wrong when you skip security, and why using an online SQL Server can actually make your data safer and more accessible. Whether you want to build an online web portal or simply connect multiple Access users over the internet, this episode is packed with practical advice for anyone looking to modernize their database workflow. No more being tied to one computer get your data online and work from anywhere!
July 6 · 24 min
Why Microsoft Access Never Came to Mac and What Mac Users Can Do
Ever wondered why Microsoft Access is missing from the suite of Office apps available for Mac? In this episode, we dive into the history and reasons behind Microsoft's decision to keep Access Windows-only. Learn about the technical challenges that make porting Access to macOS far more complicated than Word or Excel, from its reliance on Windows-specific technologies like the Jet database engine and VBA integration, to business considerations around market demand and established Mac alternatives like FileMaker Pro. We also cover the current best options for Mac users who need Access, including virtualization solutions like Parallels Desktop, VMware Fusion, and remote desktop access. If you work in a mixed Mac and Windows environment, or are just curious about where Microsoft is focusing its future database efforts, this conversation will help you understand why Access remains a Windows exclusive and what practical alternatives exist. Perfect for anyone working across platforms or considering their options for Access on a Mac.
July 4 · 5 min
Celebrating America at 250: Fun Facts, Reflections, and a Bit of Humor
Join Richard Rost from Computer Learning Zone as he marks America's 250th Independence Day with a blend of humor, thoughtful reflection, and quirky trivia. Discover the story behind the term "semi-quincentennial," find out why air conditioning and internet arguments are underappreciated American achievements, and laugh along as Richard shares tales of fireworks, anxious pups, and the perils of overzealous patriotism. This episode explores what makes Independence Day meaningful, highlights the freedoms at the heart of the United States, and challenges us to be considerate neighbors while celebrating. Whether you are a history buff, a lover of bad puns, or just want a new perspective on July 4th, this lighthearted yet sincere episode is for you. So grab your hot dogs, keep your pets calm, and tune in for a thoughtful and entertaining look at America's 250th birthday.

Showing 1–20 of 22 episodes