How to Create Query in MS Access Step by Step

Quick summary

Creating a query in MS Access lets you filter, sort, and retrieve specific data from your database tables using the built-in Query Design tool. This step-by-step walkthrough covers everything from opening the Create tab to saving and running your finished query.

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 to open the query builder.
4. Select the tables or existing queries you want to base your query on.
5. Click Add to include the selected table in the query design grid.
6. The added tables appear as small grids — 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, give your query a name when prompted, and click OK to save it.