Creating a SQL Query in Access 2007


1.	Click the Create tab on the Ribbon.

2.	Click the Query Design button on the Other group.

3.	In the Show Table dialog box, click the Close button.

4.	Click the arrow on the View button and then click SQL View.

5.	Type your SQL commands to create the query.

6.	Click the Run button on the Ribbon to execute the query.