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.

Learn how Data Transformation Services (DTS) can help you import, export, and/or transform data from various sources to single or multiple locations in Microsoft SQL Server 2000.

I've been asked at work to create a small/simple database application for a week using Access 2003. So I need to learn basic MS Access and VBA to accomplish the task. I've currently ran into a ...