Pass-Through Query in Microsoft Access

If you would like to use a SQL query that does not have to be formatted to be used for Microsoft Access, then you can use a Pass-through query.  Go to SQL view of the query and click on the option of Pass-through query.  There you can build your query for an ODBC connected database (i.e. MySQL, SQL Server, Oracle) directly to the database rather than using a linked table in the Microsoft Access database.

This works well if you don't want to change your apostrophes to quotes for string values or apostrophes to pound signs for dates.  And you can use the specific SQL language of the database you are querying.