大家看到这个标题第一个反应是什么，估计是“Access有存储过程吗？”不过我告诉大家，还真的有，下面就是我
从Access的帮助文件里摘录。不过明显看得出来，他的功能还是很弱的，过程体，只能是简单的Select/Insert/Update/Create
Table|View的单条语句。

PROCEDURE Clause

Defines a name and optional parameters for a query.

Note  The
PROCEDURE clause has been superseded by the PROCEDURE statement.
Although the PROCEDURE clause is still supported, the PROCEDURE
statement provides a superset of the capability of the PROCEDURE clause
and is the recommended syntax.

PROCEDURE name [param1 datatype[, param2 datatype[, …]]

The PROCEDURE clause has these parts:

PROCEDURE Sales_By_Country [Beginning Date] DateTime, [Ending Date] DateTime;

Code language: Javascript (Javascript)

An
SQL procedure consists of a PROCEDURE clause (which specifies the name
of the procedure), an optional list of parameter definitions, and a
single SQL statement. For example, the procedure Get_Part_Number might run a query that retrieves a specified part number.

Notes

If the clause includes more than one field definition (that is, param-datatype pairs), separate them with commas.

The PROCEDURE clause must be followed by an SQL statement (for example, a SELECT or UPDATE statement).