Use the Update command to edit fields on a table, respecting certain conditions.

UPDATE Table1
  SET Table1.Field = '<%NewValue%>'
  WHERE Table1.Field = '<%OldValue%>'