How to Create Update Queries in Microsoft Access

In this video, I will show you how to create Update Queries. You will learn how to fix the values in one table, and I will show you how to update values based on records in a different table. 

Bruce in Jacksonville FL (a Gold Member) asks: My customer table is all a mess. I didn't properly design it from the beginning, and now I've got all kinds of crazy data in it that I need to fix. For example, in the State field people have typed: New York, NY, N.Y., and so on. How can I fix this quickly and easily?

Members

I'll show you how to update product pricing in your database based on information given to you by your vendor. You will see how to review products with different prices, see discontinued items, and add new items with an append query.

•  Extended Cut Video - Silver

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today!

Links

• Multi-Table Update Queries: https://599cd.com/MultiTableUpdate

Course Link

Update Queries are covered in more detail in Access Expert 13.

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Diamond Sponsors - Information on our Sponsors Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.