Getting Started with ASP (18)-Accessing databases in Access

Northwind Database

This is a practice database provided by Microsoft for software users, and it simulates some of the data needed for a business-to-trade company's daily work processes.

And most of the SQL statements on the network are explained in this database as an example.

Our explanation is also based on this database as an example.

Click I download the Northwind database

Where to execute SQL statements

We do not explain the use of SQL statements in the ASP, we first in the Access environment to learn the simple SQL statement.

1, we use Access2013 here to explain, we open the Northwind database, and then select the " query " function in the following object interface, such as:

2. At this point, you will find that there are several queries in our sample database, such as:

3, we can also create a new query, and then save here, select the "creating | Query design ", such as:

4, will pop up a "Show table" dialog box, we choose "Close".

5, we can switch to "SQL view" mode in two ways, as shown in:

6. Enter the SQL statement you want to run in the Query 1 window and choose Save As Query 1.

7. Double-click " Query 1" in the query object to display our results.

Getting Started with ASP (18)-Accessing databases in Access