Access: How to Use the Update Query

The Update query is a bit like the find and replace feature except you can use more criteria and also get it do more based on set conditions. It can also be used to do calculations, for example you may want to change some values based on certain criteria.

Here is how you can use the update query.