SQL in Access
If you're familiar with SQL, you may want to work directly with
a query's underlying SQL statement.
- Create a query or open an existing query.
- Click the arrow next to View on the toolbar, and then click SQL View.
- Microsoft Access displays the SQL statement that is equivalent to what you created in Design view.
- If you want to make changes, type your changes in the SQL statement.
- To see the changes in the design grid, click the arrow next to the View button on the toolbar, and then click Design View.