By Richard Rost 4 years ago
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?
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.
Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the database template from class plus get access to the Code Vault. If you signed up on YouTube you have to register on my YouTube Find User page so I can set up your account here on my web site. If you're not a member, Join Today!
Update Queries are covered in more detail in Access Expert 13.
Subscribe to Update Queries
Get notifications when this page is updated
|Keywords: TechHelp Access update query update queries access ms access update query ms access update query from another table access update query with join access update query multiple criteria access update query add to existing value access update field in table PermaLink Update Queries in Microsoft Access