Testing the sql statement in Access 2007

2. After you click the “Query Design” you can see the following information. Because of we will write the sql statement manually in access2007 so we close this window (you also can click “Add” button, it doesn’t meter for the following steps).

3. After you close the window, then you can right click on the panel or on the tab head (“Query1”), select the “SQL View”.

4. Then we can open this interface and we can write the sql statement on this window, then click on the “Run” you can execute this sql statement in access2007.

5. This is the result information after you run the above sql statement. And you also can right click on the “Query1” then select the “SQL View” to go back to the sql view and test the next sql statement.