Computer Learning Zone

If you have ever struggled to find specific records in your Microsoft Access database, this episode is for you. Access instructor Richard Rost walks through the basics of building a simple query, showing how queries let you search, filter, and save custom views of your data for repeated use.

We talk about what queries actually are (hint: they do not store data, just instructions), why using them makes working with large tables easier, and some important gotchas new users often overlook. Discover why queries are more powerful than filtering tables manually, and how editing data from a query affects your original tables.

If you want practical tips on making your Microsoft Access experience smoother, smarter, and a bit more professional, tune in and learn why queries are one of Access's most essential tools. Whether you are organizing contacts, tracking orders, or prepping for more advanced database designs, this is a friendly and informative starting point.

Artificial intelligence is everywhere these days, and developers are starting to ask some tough questions. Is AI just the next tool every developer needs to learn, or are there real ethical and environmental reasons to hit pause? In this episode, Richard dives into the practical realities and bigger questions around AI for developers, especially MS Access pros.

You will hear a thoughtful discussion about the true costs and benefits of AI, why environmental impact matters, and why simply shutting down new technology is not a realistic answer. Richard shares how he personally uses AI to boost productivity, addresses concerns about data centers and sustainability, and explains why responsible use is more important than outright rejection.

If you are working in Access or just curious where AI is headed in the world of small business databases, join the conversation about how developers and companies can adapt, learn, and use these tools in a changing world.

If you have ever wondered whether you should keep Name AutoCorrect enabled in your Microsoft Access databases, this episode is for you. Access veteran Richard Rost breaks down why this feature, despite its promising name, often causes confusion and hidden problems - especially as your databases grow more complex.

You will learn how Name AutoCorrect is designed to help by updating dependent fields, forms, and queries when you rename things, but frequently misses crucial bits like VBA code or advanced references. Richard shares real-world scenarios where relying on this feature can lead to broken forms, malfunctioning buttons, and headaches down the line.

We discuss the hidden risks of trusting AutoCorrect, the overhead it adds, and why most experienced Access developers choose to disable it as soon as a new database project begins. Hear about the divided opinions in the Access community, and how even though Name AutoCorrect can be handy for beginners, it often creates more work than it saves.

Whether you are a casual Access user or starting to build larger applications, this episode will help you understand the tradeoffs and save you from frustrating debugging sessions in the future.

Curious if Microsoft Access can truly handle your growing business data? In this episode, Access expert Richard Rost breaks down the official specifications and real-world limitations of Microsoft Access, including database size, user limits, number of tables and fields, and much more. Drawing on over 30 years of experience building Access databases, Richard shares where the published numbers actually matter, common misconceptions, and what starts to break first as your database grows.

Listen in for a realistic, practical look at how far Access can go before you need to think about alternatives like SQL Server, what table design mistakes to avoid, and how to spot when you are outgrowing the platform. You'll also hear why some of Microsoft's published limits might be more flexible than you think, and learn tips on making Access run smoothly even as your data and team expand.

If you have ever wondered whether your Access database will hit a wall, or want to know the best practices for large Access projects, this episode is for you.

Tired of tracking your passwords on sticky notes or spreadsheets? Learn how to design a practical password manager and generator right inside Microsoft Access. Host Richard Rost walks through creating a user-friendly form, using VBA to automate strong password creation, and handling visibility controls to keep your sensitive info safe from prying eyes.

This episode covers the security limitations of Access, why password storage matters, and smart approaches for protecting your data, including leveraging input masks and copying passwords securely to your clipboard. You will also hear tips for integrating username management, notes, and even ideas for tracking password change dates.

If you want a hands-on, fun guide to building your own in-house password organizer and generator, all with a dash of humor and plenty of practical advice, tune in and start taking control of your digital security with Microsoft Access.

Choosing between tables and queries as the data source for your Microsoft Access forms and reports can have a big impact on how flexible and efficient your database becomes. In this episode, we dive into one of the most common questions Access users face: when should you use a simple table, and when is it better to base your forms or reports on a query? We will discuss practical scenarios, clear up misconceptions, and explain why queries are often the better option for calculated fields, totals, and cleaner data entry workflows.

Listen in as Access veteran Richard Rost shares real-life examples from the community, explains the importance of updatable queries, and walks through potential pitfalls with complex queries that could make your forms uneditable. Whether you are building a small business solution or reorganizing your Access database for better performance, this episode will help you make informed decisions and avoid common headaches when designing forms and reports.

In Quick Queries #93, we discuss a common Microsoft Access SQL mistake that can break your queries even when the statement appears correct and walk through why a missing field name in SQL criteria causes unexpected results. We also address questions about opening Access databases in separate memory spaces, quirks in the new Form Zoom feature, usage of API code, issues with inactivity timers and popup forms, split testing YouTube thumbnails, and advice on effective recordset cleanup in VBA. We briefly mention how much API detail you need to understand and upcoming tips for managing multiple open database instances.

In this lesson, we will discuss the new form zooming feature in Microsoft Access, which allows you to zoom in and out on forms, tables, and queries for better readability. I will show you how to use the zoom controls, set default zoom levels, and explain which views and versions support this feature. We will also talk about update rollout issues, what to do if the feature does not appear after updating, and some current limitations like lack of support for Design view and pop-up forms. This lesson covers practical tips for using form zooming and managing Office updates.

In this episode, we address the common "You cannot install the 64-bit version of Microsoft Access Database Engine" error, explain why 32-bit and 64-bit Microsoft Office component mismatches occur, and discuss several approaches to resolve the issue. We talk about options like extracting the database file, trying the 64-bit Access Runtime, updating older VBA code, reinstalling the correct Office version, and ensuring proper network connections to backend data. Suggestions for seeking additional help are also covered if the problem persists.

In Quick Queries 92, we tackle the question: Is Microsoft Access still worth learning in 2026, and does it remain relevant for developers, consultants, and small business owners? I discuss Access's future, Windows' ongoing importance, and address privacy concerns. We will talk about naming confusion between form controls and variables, automating Excel imports, managing check boxes on continuous forms, best practices for storing databases, writing and importing text files, and user permission controls. Additionally, we discuss thumbnail design choices for videos, tips for VBA window management, and recommendations for printing wide reports. Member questions from YouTube and email are also answered throughout.