# How to Create Stored Procedures MS Access

> To create stored procedures in the database, open the Access database, click the Create tab, and select Query Design. Next, click the View button to switch to SQL View, write your SQL query with parameters, and click Run. Finally, enter the parameter value and click OK.

Canonical: https://livedemo.ai/tutorials/how-to-create-stored-procedures-ms-access/
Updated: 2026-10-05
Interactive demo: https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a3a40ab56e05a00fe12f9/preview?step=1

## Steps

1. Open the Access database.
2. Click the 'Create' tab.
3. Select 'Query Design'.
4. Click the 'View' button.
5. Switch to 'SQL View' from the query design window.
6. Write your SQL query with parameters.
7. Click 'Run' to see the results.
8. Enter the parameter value and click 'OK'.
9. That's it! You have successfully created stored procedures on MS Access.