# How to Create Query in MS Access Step by Step

> To create a query in Microsoft Access, open your database file, go to the Create tab, and select Query Design. Choose your tables, click Add, and double-click the desired fields. Finally, click the Run button to execute the query, close the design window, and save it with a name.

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

## Steps

1. Open the database file where you want to create the query.
2. Go to the 'Create' tab on the ribbon.
3. Select 'Query Design'.
4. Select the table(s) or existing queries you want to base your query on
5. Click 'Add'.
6. The added tables appear as small grids with their fields listed. Double-click the fields you want to include in the query.
7. Click the 'Run' button, the red exclamation mark in the ribbon to execute the query.
8. Close the query design window. When prompted, give your query a name and click 'OK'.