Computer Learning Zone

In this lesson, we will walk through how to customize the ribbon in Microsoft Access to better suit your workflow. I will show you how to add your own tabs and groups, rename them, select and organize commands for quick access, and hide tabs you do not use. We will discuss the difference between main, tool, and all tabs, importing and exporting ribbon settings, and important considerations about h...

In this episode, we will address the common issue of Access not opening by explaining why Microsoft Access sometimes hangs when you try to open multiple databases in the same session. I will show you how to set up shortcuts that open each database in its own separate Access instance for greater stability, and we will discuss why this approach helps prevent one frozen database from affecting the ot...

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Alright, it's that magical time of year again when we all pretend the Earth suddenly decided to spin faster and we have to adjust our lives accordingly. Twice a year we do this weird national ritual where millions of adults run around their houses pressing tiny buttons on appliances like we're trying to defuse a bomb in an action movie. Somewhere in my house right now there's a clock b...

In this episode, we discuss how to use the MkDir command in Microsoft Access with VBA to automatically create folders for each customer, allowing invoice PDFs to be organized by customer rather than stored in a single directory. I show how to add VBA code that will generate the necessary folder structure when exporting invoices, handle basic error situations like folders already existing, and stru...

In this episode, we build our first queries and views in SQL Server using the graphical query designer, noting key differences from Access in sorting, filtering, and saving queries. I demonstrate how to construct, execute, and modify queries, discuss the importance of using fields intentionally, and explain the distinction between saving queries locally and as views on the server. We walk through...

In this episode, we connect Microsoft Access to SQL Server by setting up linked tables rather than importing, so your Access front end works with live server data. I show you the step-by-step connection process, discuss choosing the right ODBC driver, explain the difference between file and machine data sources, and clarify how to handle the DateTime2 data type. You will also learn about managing...