Computer Learning Zone

Richard Rost
  • 0.0 (0)
  • Tecnología
  • Cada semana

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.

  1. Why Experienced Developers Disable Name AutoCorrect in Microsoft Access

    hace 2 días

    Why Experienced Developers Disable Name AutoCorrect in Microsoft Access

    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.

    19 min
  2. How Far Can Microsoft Access Go Practical Limits and Real World Performance

    hace 3 días

    How Far Can Microsoft Access Go Practical Limits and Real World Performance

    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.

    25 min
  3. Building a Secure Password Manager and Generator in Microsoft Access

    26 may

    Building a Secure Password Manager and Generator in Microsoft Access

    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.

    20 min
  4. Should You Base Microsoft Access Forms and Reports on Tables or Queries?

    24 may

    Should You Base Microsoft Access Forms and Reports on Tables or Queries?

    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.

    26 min
  5. The Simple Microsoft Access SQL Mistake Almost Every Developer Makes At Least Once - QQ 93

    22 may

    The Simple Microsoft Access SQL Mistake Almost Every Developer Makes At Least Once - QQ 93

    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.

    29 min
  6. Form Zooming: How To Zoom Forms, Tables, And Queries In Microsoft Access. New Feature!

    21 may

    Form Zooming: How To Zoom Forms, Tables, And Queries In Microsoft Access. New Feature!

    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.

    13 min
  7. Microsoft Access Database Engine x64.exe Install Error. AccessDatabaseEngine_x64.exe Fix

    20 may

    Microsoft Access Database Engine x64.exe Install Error. AccessDatabaseEngine_x64.exe Fix

    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.

    11 min
  8. Is Microsoft Access Still Worth Learning in 2026? - QQ 92

    18 may

    Is Microsoft Access Still Worth Learning in 2026? - QQ 92

    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.

    44 min
Ver todo (64)

Acerca de

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.

Información

  • Creador
    Richard Rost
  • Años de actividad
    2 k
  • Episodios
    64
  • Clasificación
    Apto
  • Copyright
    © Richard Rost
  • Mostrar sitio web
    Computer Learning Zone