As you gain experience with Microsoft Access, you can explore its advanced features to further enhance your database: SQL View: Write queries directly in SQL code for greater flexibility and ...

There is a section of the MS Access help called the JET SQL Reference (or similar) that gives a brief overview of the SQL syntax Access uses.