Testing the sql statement in Access 2007

1. Create a table in access2007, and click on the “Create” tab, then you can see the following information, and then you can click the “Query Design” to create a query in access2007.

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.

PS：我的同事开发了一个MSDN论坛的小工具，有兴趣的朋友可以试试，此工具已开始在国内推行：