Is it possible to replace data in a column in ms-access ?

Question

In ms-access database, is it possible to write an sql query to replace the number in a column with a number obtained by adding 2 to this original number. ie, all numbers in a column should be replaced by the original number plus 2

Answer 1

UPDATE myTable SET myColumn = myColumn + 2

Answer 2

UPDATE YourTable 
SET 
    NUMBER = NUMBER + 2

If you don't do a where your going to do the whole lot. So if you are doing this from a form you need something like

WHERE id = ' & me.ID