Computer Learning Zone

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.

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.

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.

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.

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.

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.

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.

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.

In this episode, we hold a Q&A session to address a wide variety of questions submitted by students so far in Beginner Level One. Topics discussed include using passwords and connection strings, differences between SQL Server editions, the role of SQL Server versus Access, handling date and time fields, combo box performance, SQL Server setup considerations, hardware recommendations, authentication methods, issues with form slowdowns, migrating tables from Access to SQL Server, permission management with groups, and several other practical concerns Access developers face when working with SQL Server. Further questions and feedback are encouraged for future lessons.

In this episode, we talk about how to handle split transactions in Microsoft Access when a single transaction needs to be assigned to multiple categories. We discuss why using a single category field is limiting, explain the use of a split table to resolve these issues, and cover how to set up the one-to-many relationship between the transaction and split tables. We also look at form design considerations for managing and editing split transactions and why this approach makes databases more flexible and scalable.