Microsoft Access: How to Use the Update Query

If you have been following my blog since the beginning of this week you will have seen that I have been looking at action queries in Microsoft Access. These are queries that are using for changing the data sets such as adding data to them, deleting data and also archiving data.

Here is the last one of these which is the update query. Update queries in a way are a bit like find and replace but can do so much more. For a start you can get it to make changes to data based on specific criteria and allows you to do more than find and replace. It can also be used to update values, for example, a particular manufacturer may be increasing their prices by 10%, using an update query you could easily do this. Another example I have used before is when area codes changed for phone numbers, I used the update query to make that change to just part of the text.

About garysch

A bit of a techno nut who likes sharing what I know about technology, especially with those who struggle with it. Also through my podcast www.jargonfreehelp.com
This entry was posted in Microsoft Access, Microsoft Office, Office 2010 and tagged , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s