title: Field types available for use with "CREATE TABLE" in Microsoft Access
body: <p>I have the displeasure of generating table creation scripts for Microsoft Access.  I have not yet found any documentation describing what the syntax is for the various types.  I have <a href="http://msdn.microsoft.com/en-us/library/bb177893.aspx" rel="noreferrer">found the documentation</a> for the Create Table statement in Access but there is little mention of the types that can be used.  For example:</p>
  
  <pre><code>CREATE TABLE Foo (MyIdField *FIELDTYPE*)
  </code></pre>
  
  <p>Where FIELDTYPE is one of...?  Through trial and error I've found a few like INTEGER, BYTE, TEXT, SINGLE but I would really like to find a page that documents all to make sure I'm using the right ones.</p>