title: Update and Replace numerous Fields in Access
body: <p>I have a table with 30 columns, I need to find and replace fields in all of the columns. I have the following code, which allows me to do it in a single column:</p>
  
  <pre><code>UPDATE Table 
  SET Field1 = REPLACE(Field1,'Test','Word') 
  WHERE ID &lt;= 3 ;
  </code></pre>
  
  <p>Is there any way to be able to replace throughout all of the columns in the whole table? The table data looks something like this:</p>
  
  <pre><code>ID  Field1     Field2     Field3     etc
  1   Test 1     Apple 3    Sun 2    
  2   Apple 2    Sun 3      Test 2
  3   Sun 1      Test 3     Apple 1    
  </code></pre>
  
  <p>I want it to look like this:</p>
  
  <pre><code>ID  Field1     Field2     Field3     etc
  1   Word 1     Apple 3    Sun 2    
  2   Apple 2    Sun 3      Word 2
  3   Sun 1      Word 3     Apple 1    
  </code></pre>
  
  <p>I am using Access 2010</p>