Online resource for writing Access SQL statements
Here is Microsoft's page about Access SQL syntax:

http://office.microsoft.com/en-us/access-help/access-sql-basic-concepts-vocabulary-and-syntax-HA010256402.aspx

and here is a tutorial about Access SQL syntax for Access 2000.  A bit dated, but the concept is still there:

http://www.cwnresearch.com/resources/databases/access/tutorials/access2000/SQLQueries/SQLQueries.html