Computer Learning Zone

In this Quick Queries video, we discuss an Access form optimization that can speed up read-only forms by setting the Recordset Type to Snapshot. We also talk about automating billing statement emails, RAM recommendations for Access and SQL Server, setting custom database icons, combo box design for linking tables, handling VAT rates, why you should not run Access databases from Google Drive, datab...

In this episode, we will walk through the steps to connect to SQL Server from another machine on your network. I will show you how to configure SQL Server Express for remote connections, enable the necessary protocols and services, check your Windows Network Profile, and set up both Windows and SQL Server Authentication logins. We also discuss how to open the correct firewall ports and troubleshoo...

How can I stop one of my long processes with the keyboard? I watched your video about using a checkbox to cancel it, but it feels clunky, and most of my users are older and prefer the keyboard. Is there a way to just press the ESC key to cancel something while it's running instead of clicking a button? See the video: https://599cd.com/EscapeKey

In this Quick Queries episode, we tackle several Microsoft Access topics, including why queries sometimes stop showing all your records due to the TOP VALUES setting and how to fix it, working with SharePoint as a backend and its common challenges, displaying multiple query results in a single report or dashboard, managing Access security with trusted locations, techniques for reusable controls, V...

Let's talk about vibe coding, where developers use AI tools to generate code by describing what they want rather than writing it themselves. We'll discuss the benefits and risks of relying on AI for coding, the importance of understanding programming fundamentals, and why it's crucial not to skip the learning process, especially for business-critical applications. You'll also hear...

In this lesson, we walk through the SQL Server Management Studio interface and cover the essential sections you need to know to get started, especially if you're coming from Microsoft Access. You'll learn about Object Explorer, how to see which server you're connected to, and the main server-level folders like Databases and Security. We focus on creating your first database, explain wh...

In lesson 2, we will walk through downloading and installing Microsoft SQL Server Express and SQL Server Management Studio (SSMS) step by step, taking the time to explain important options and terminology along the way. I will show you how to choose the right components, set up your local instance, select authentication methods, and connect with SSMS so you have a fully working SQL Server setup re...

I just launched a brand-new course: SQL Server for Microsoft Access Users, and just like my other training, the entire Beginner Level 1 series will be posted FREE on YouTube and my website . Multiple lessons, full Level 1 foundation, NOT a teaser. Lesson 1 is live now and the rest of Beginner 1 will be rolling out soon, so watch the full video now. Lesson 1 is an "explainer" only, so you...

Today we discuss some of the most common Microsoft Access questions from viewers, focusing on why tracking monthly payments with one field per month is a classic database mistake and how adding a second related table can solve reporting headaches. We also talk about working with tabbed documents vs. overlapping windows, Power Query merge performance in Excel vs. Access joins, locking fields in edi...

I run a Windows machine as a “server” to handle backups and automation, but if I don’t reboot it regularly, Access starts throwing weird errors (like out-of-stack space). Here’s the simple trick I’ve been using: automatically killing Access after my nightly backup a few nights per week so it starts fresh. Learn more at 599cd.com/KillAccess

Every October, the same debate resurfaces here in the US. Columbus Day or Indigenous Peoples Day? It's one of those holidays that means very different things depending on who you ask. Some celebrate exploration and discovery. Others remember conquest and loss. The truth is... both are right. History isn't clean. It's messy, complicated, and filled with people who did terrible things fo...

Download Microsoft Access for Free? Don't Fall for the Illegal Scams! #msaccess #microsoftaccess https://599cd.com/DownloadAccess?key=Spotify

Today's TechHelp tutorial from Access Learning Zone is all about managing field names when importing data into Microsoft Access from Excel or a text file. I am your instructor, Richard Rost. Often, the field names in imported data can cause issues, such as errors indicating that an item is not found in a collection. Today, we'll discuss how to handle these situations. A member recently enc...

Today's TechHelp tutorial from Access Learning Zone focuses on tracking employee training and certifications using Microsoft Access. I'm your instructor, Richard Rost, and in response to frequent questions about this topic, I've decided to guide you through creating a comprehensive database system from scratch. This will allow you to effectively monitor which courses employees should t...

Today's TechHelp tutorial from Access Learning Zone is about automating the import process of data from Excel into Microsoft Access, specifically when dealing with spreadsheets that contain extraneous information. I'm your instructor, Richard Rost. We'll address situations where Excel sheets might have unnecessary rows at the top or bottom, which can complicate the import process. This...

Today is Martin Luther King Jr. Day, and it's a time to honor one of the most inspiring leaders in history. Dr. King's work for civil rights changed the course of our country forever. He fought tirelessly for equality and justice, using nonviolence to bring people together and challenge unfair laws. Most of us know his famous "I Have a Dream" speech, where he spoke about his visi...

Today's TechHelp tutorial from Access Learning Zone will focus on using nested if functions in Microsoft Access. I'll explain how to use them to categorize customer spending into three levels: high, medium, and low. A single standard if function can only handle two conditions, so we'll use nested if functions to manage three. Imagine you're working to categorize customers based on...

Today's TechHelp tutorial from Access Learning Zone focuses on enhancing the speed of loading forms in Microsoft Access, a common issue when you have a form bogged down by extensive data or complex queries and functions. This particular lesson arose from a question posed by a member who encountered sluggishness in a form used to view quarterly sales summaries. The main culprit seemed to be the int...

Today's TechHelp tutorial from Access Learning Zone will guide you through the process of importing a specific range of cells from an Excel sheet into your Microsoft Access database. This lesson addresses a common question from users: how can I import a specific range of cells from an Excel workbook into Access? We'll tackle this with a two-part lesson. First, we'll explore the expert method, whic...

Today's TechHelp tutorial from Access Learning Zone explores a significant advancement in Chat GPT and AI technology. The introduction of the Canvas feature is a breakthrough for tasks like document editing and code writing. If you're accustomed to creating code, especially VBA programming in Microsoft Access, this feature could significantly enhance your workflow. In previous experiences with Cha...

Today's TechHelp tutorial from Access Learning Zone focuses on navigating forms and subforms in Microsoft Access. If you're working with forms, you may have experienced issues with tabbing through different sections such as headers and footers. The tab order might not always be intuitive, especially if a subform is involved. Our discussion today will cover how to effectively navigate these section...

Today's TechHelp tutorial from Access Learning Zone will address a common question I receive frequently, despite having covered it in past lessons. People often ask how to copy the billing address to the shipping address in Microsoft Access. We'll be creating a button to facilitate this action. It's relatively simple, and I'll demonstrate two approaches. The first is what I call the "expert" metho...

Today's TechHelp tutorial from Access Learning Zone addresses a common request from users: how to enable a button to perform an alternate action when the shift key is held down during a click. Imagine having an invoice button. Normally, clicking it shows a print preview, but if you hold the shift key and click, it sends the document directly to the printer. This dual functionality is what we'll ex...

Today's TechHelp tutorial from Access Learning Zone focuses on how to trap form error messages in Microsoft Access to provide more user-friendly notifications. Imagine your users encountering a message like, "The changes you requested to the table were not successful because they would create duplicate values in the index primary key relationship." That's confusing, right? Or sometimes, they might...

Today's TechHelp tutorial from Access Learning Zone covers editing linked Excel data. Imagine you have an Excel spreadsheet linked to your Access database, but you can't edit it. We'll explore a workaround to make it editable. Keith from Germantown, one of my platinum members, uses Excel for data entry and managing spreadsheets at his office. He handles reporting and financial statements, frequent...