It is very useful when using SQL query statement to check SQL syntax in ACCESS.
The steps are as follows:
[Create]->[Query Design]
Directly Close the pop-up [Show Table]
Find the [SQL View]:
Enter the command in the query command window, and then execute the run command.
Prompt statement:
SQL command added record successfully!
http://jingyan.baidu.com/article/624e7459b17ff134e8ba5ae7.html