How does MS Access address the issue of stored procedures?

Question

How does MS Access address the issue of stored procedures?

Answer 1

Hi,

When u open a Database in MS-Access, then there is a pan on the left hand side. The very first item on the pan is Table, next is Query and so on.

In the same list is Module.

U click on module then it will allow u to add a module to ur database.

When u open a module it will allow u to add a Procedure. Using "Insert" in Main Menu.

Then u can write ur code in the procedure and manipulate ur data in MS-Access tables.

U can add many procedures in a module. All these procedures are saved with the same database.



When u click an object (e.g., Text Box or Check Box etc.) on a form then a code window opens u can type ur code over there also for the particular event of the object.

This code is also stored with the database.

Answer 2

in addition to storing queries you can write macros, which can run a sequence of procedures such as running queries, importing or exporting data and so forth. also you can create modules which i believe can either be functions called by queries or programs that call queries.

Answer 3

the first answer is robust, they gave you a fish. Now i will teach you a thanks to fish so that you're fed for a life-time. in the question section decide on New question, Use the wizards to create a go-tab question. Presto! you'll see another astounding wizards there that i'm positive will are available accessible some day.

Answer 4

You create queries and those are you stored procedures..



here's a site that will help you:

http://www.stardeveloper.com/articles/display.html?article=2001050101&page=1