« When I go into contacts and select several people to email and compose I get back to a email with no names?
SQL Server 2008 T-SQL Debugger »

Microsoft Access Update Query

How to create an UPDATE QUERY in Microsoft Access. Go to www.599CD.com/Access/YouTube for more free tutorials.

Duration : 0:5:0


[youtube --PVVLIcbjE]

This entry was posted on Wednesday, August 5th, 2009 at 9:50 pm and is filed under query. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

5 Responses to “Microsoft Access Update Query”

  1. thanks for your …
    thanks for your answer. by the way, if you don’t mind me saying…i am an award winnning instructor (that is a fancy way of saying students really really like my training). Not that it matters but from one instructor to another, i really like your style, its clear, its slow enough to ‘get it’, its explained in a very understandable manner and i just want to give you complete ‘thanks’ for making great videos. i don’t know everything (yet) and your videos really helped ALOT. thanks a ton. :)

  2. John, you are …
    John, you are correct. Find and replace works fine for simple replacements. However, to make calculated changes, or have the ability to AUTOMATE changes (so people who know nothing about Access can do it with the click of a button) you really need to know update queries.

  3. can’t this be done …
    can’t this be done with the CTRL+H feature.

    CTRL+H is the find and replace technique.

    find northeast
    replace with north.
    so???
    i will answer my own question: yes…the CTRL+H feature can be used. HOWEVER….the update query is also used for “updated all products that are currently $49.95 by 15%”
    …by the way…this instructor of these videos does a great job.

  4. Thank you!! Very …
    Thank you!! Very useful, finally found something worth looking at.

  5. Great, thanks!
    Great, thanks!

Leave a Reply