How to use SQL statements for acess Databases

Acess database is a very simple database management software. It is window-oriented or dialog box-oriented. It seems that SQL statements are useless.

The following article describes how to use SQL statements on acess.

From: http://www.dzwebs.net/2620.html

Key point: when creating a query, right-click the query and select "SQL View!

Although I do not like the ACCESS database very much, I recently had to use the ACCESS database because of my work needs. During this period, I encountered a problem,How to directly enter an SQL statement in the ACCESS database and use it to query data?

It is not easy to find this function because there is no menu prompt or tooltip. After a long time, I found the method to directly use SQL statements. Now, I will share it with you, hope to help you.

First, to directly use SQL statements in an Access database,You must first create a query.

For example, SELECT query in the Database "object" and click "design "!

 

A dialog box such as is displayed!

To add a data source to the query object. In this example, the "Student renewal table" is displayed. Then, the "display table" dialog box is closed! Returned result!

, In the query operation interfaceRight-clickIn the left-side Navigation Pane. For example, select"SQL View". Finally, the SQL statement code input window appears, as shown in!

In this case, we can enter the correct SQL statement.