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.

  1. Your Microsoft Access Backup Plan Might Be Missing This Critical Step - Quick Queries #84

    20 MAR

    Your Microsoft Access Backup Plan Might Be Missing This Critical Step - Quick Queries #84

    In this episode, we will discuss the importance of testing backup restores in addition to making backups, address handling reminders in Access across different time zones, explore data normalization to avoid duplicate information, and cover strategies for importing exported data without creating duplicates. I will also show you techniques for drawing straight lines in Access, explain how Access saves data, answer questions about triggering automatic alerts, and discuss whether running 32-bit Office on 64-bit Windows causes issues. Throughout, we will review practical solutions and troubleshooting tips for common Microsoft Access scenarios.

    24 min
  2. How to Create a Report in Microsoft Access (Step-by-Step Beginner Tutorial)

    19 MAR

    How to Create a Report in Microsoft Access (Step-by-Step Beginner Tutorial)

    In this episode, we will walk through how to create reports in Microsoft Access step by step, using the report wizard to generate basic reports from a table, make modifications in design view, and organize data through sorting and grouping. We will discuss report sections, exporting and printing options, and clarify the differences between forms and reports. Additional resources and related videos are mentioned for those who want to learn more.

    16 min
  3. How To Use The Count Function In Microsoft Access

    19 MAR

    How To Use The Count Function In Microsoft Access

    In this episode, we will walk through how to properly use the count function in Microsoft Access queries. I will explain common mistakes, demonstrate how to create aggregate queries using the count function, and show how to troubleshoot issues that often occur, such as calculation errors and working with multiple tables. We will also discuss the importance of using aggregate queries and how aliases can help with naming counts in your results. This lesson is aimed at helping you get accurate counts and better understand how Access processes aggregate functions.

    14 min
  4. Microsoft Access Corrupt Database Recovery: Try These Fixes Before You Buy Recovery Software

    18 MAR

    Microsoft Access Corrupt Database Recovery: Try These Fixes Before You Buy Recovery Software

    In this episode, we look at what to do when your Microsoft Access database becomes corrupted and shows errors like "Unrecognized database format" or inconsistent state messages. We will discuss how to recognize signs of corruption, steps to take before attempting repairs, quick fixes such as compact and repair, using decompile, importing objects into a new database, and methods for salvaging data at the table or record level. We will also talk about using third-party recovery tools and professional recovery services, and review best practices for preventing future corruption, including proper backups and avoiding risky environments.

    29 min
  5. How to Use Comments & Notes in Microsoft Excel - Why Excel Has Two Comment Systems

    16 MAR

    How to Use Comments & Notes in Microsoft Excel - Why Excel Has Two Comment Systems

    In this episode, we discuss the differences between comments and notes in Excel, including their history, how to identify them, and when to use each feature. I show you how to add and manage both, highlight their visual indicators, and explain collaboration tools like threaded replies, resolution features, and where to find these options in the Review tab. We'll also discuss limitations such as not being able to use both in the same cell, print behavior, and converting notes to comments. Finally, I provide a summary of best practices for choosing between comments and notes in your spreadsheets.

    13 min
  6. Why vbNewLine Doesn't Work in Microsoft Access Rich Text Fields (And the Simple Fix) - QQ #83

    14 MAR

    Why vbNewLine Doesn't Work in Microsoft Access Rich Text Fields (And the Simple Fix) - QQ #83

    In today's Quick Queries, we discuss why inserting line breaks using VB New Line in Access VBA may not work in rich text boxes and explain how to fix it by using HTML tags. We also cover issues with parsing driver's license barcodes, sorting months in modern Access charts, the two-gigabyte database file size limit, differences between refresh and repaint in Access, limitations with rich text box line counts, legacy 32-bit ActiveX dependencies, and answer various viewer questions on filtering subforms, many-to-many relationships, and other Access tips.

    39 min
  7. Ready to Move Your Microsoft Access Database Up to the Big Leagues?

    13 MAR

    Ready to Move Your Microsoft Access Database Up to the Big Leagues?

    This episode introduces the SQL Server for Microsoft Access Users course, outlining how Access developers can enhance their databases by using SQL Server as a backend to improve performance, security, and scalability. It explains the intended audience, necessary prerequisites, and what software will be used, and then provides an overview of each lesson, covering topics such as installing SQL Server, database design differences, data migration, connecting Access to SQL Server, and addressing practical questions about integrating the two platforms.

    14 min
  8. How to Filter a Microsoft Access Subform With a Combo Box

    12 MAR

    How to Filter a Microsoft Access Subform With a Combo Box

    In this episode, I will show you how to set up a form in Microsoft Access where you can filter a subform displaying contact history simply by selecting a customer from a combo box. We will walk through building an unbound parent form with a combo box, embedding a contact subform, and using both non-VBA and simple VBA methods to filter the displayed contacts based on the selected customer. We also discuss some limitations of each method and how you can achieve more flexibility with a small amount of VBA.

    18 min
See All (46)

About

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.

Information

  • Creator
    Richard Rost
  • Years Active
    2k
  • Episodes
    46
  • Rating
    Clean
  • Copyright
    © Richard Rost
  • Show Website
    Computer Learning Zone