Computer Learning Zone

In Quick Queries episode #90, we address several practical Microsoft Access topics including why Access Reports might run slow and ways to speed them up, password and pass phrase strategies, considerations for 32-bit versus 64-bit Access, best practices for importing Excel data, handling date formatting, the importance of table normalization, and moving Access queries to SQL Server. We will also discuss the benefits of select case ...

In this lesson, we will walk through how to create multiple report columns in Microsoft Access, making your Access Reports look more like a newspaper layout instead of a single long list. I will show you how to adjust column settings, set up text wrapping, and manage properties like Can Grow, Can Shrink, Keep Together, and Force New Page to create cleaner, more professional reports. We will also discuss using backups and how column...

In this episode, we will discuss common Microsoft Access terminology to help you understand key concepts like tables, queries, forms, and reports. You will learn what each term means, how tables serve as the foundation for storing data, the role of primary keys, and how queries, forms, and reports help you manage and present your data. We will also briefly touch on macros and modules for automating tasks and adding custom functiona...

In today's lesson, we will discuss how to join the Microsoft Access Beta channel to access the newest features before they are officially released. I will show you step-by-step how to enable the Beta channel, including the required registry change, and walk through the process of signing up within Access. We will also talk about important precautions, such as not installing beta software on your production machine, and highligh...

In Quick Queries #89, we address troubleshooting the ODBC insert error with linked SQL Server tables in Microsoft Access, especially involving long text fields and the recent Office Build 2604 bug. We discuss practical workarounds, differences between chained and nested queries, common issues with copy and paste in Access, using and adapting web APIs when services change, and adjusting list box column widths. We also touch on datab...

In this lesson, we begin building a dynamic, data-driven menu system in Microsoft Access using a list box, eliminating the need to manually add or rearrange menu buttons when changes are made to the database. I demonstrate how to create a menu table with hierarchical relationships, set up the form with a list box, and write basic VBA code to open forms based on menu selections. We discuss how to structure the menu for main items an...

In this Quick Queries episode, we discuss the pitfalls of Microsoft Access's Name AutoCorrect feature and why it often causes more problems than it solves. We will talk about launching global search forms with keyboard shortcuts in Access, inventory database design with movement tracking versus totals, issues with Excel notes, password management strategies and considerations for using Access, some challenges with VBA and modul...

In this episode, we discuss how to create a data-driven survey or questionnaire system in Microsoft Access, where all survey questions and answers are stored in tables rather than being hard-coded into forms or reports. I explain the database structure, including tables for surveys, questions, sessions, and answers, and show step-by-step how to set up these tables and link them. We walk through building the necessary queries and fo...

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 tr...

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 t...

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 yo...

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 le...

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...

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 A...

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, dat...

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 me...

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 slo...

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 s...

In this episode, we address common issues in Microsoft Access, such as why totals sometimes do not calculate in form footers and the reasons behind error messages. We discuss solutions for summing calculated fields, combining records from multiple tables using union queries, and troubleshooting differences between database behavior on different computers. Additional topics include handling file paths in VBA, managing rolling date c...