Steps to using SQL in Microsoft Access. 1. Launch Microsoft Access and open an existing database or create a new one. 2. Click on the Create tab in the ribbon at the top.

The ODBC driver allows programmers to create PHP scripts that can log in to and manipulate Access just as they would an SQL database like MySQL or SQL Server. Advertisement.

SQL lets you use one command to quickly create a new table containing a subset of records from a larger table while working in Access. Sound complicated? It's not, as Mary Ann Richardson shows us.

If there’s any chance that your Access database will grow out of its skin, consider splitting the database. It’s easier to upsize a split database to SQL Server ...

Take that recordset and use it to create a new table (a temporary one) in the local Access database.<BR>3. Close the recordset.<BR>4. Run my report off the new temporary table<BR>5.