How to Create Simple Query in MS Access

Quick summary

Creating a simple query in MS Access lets you filter and retrieve specific data from your database tables without writing SQL manually. Using the Query Design tool, you can select fields, add tables, and run queries in just a few clicks.

Steps

1. Launch Microsoft Access and open the database you want to query.
2. Click on the Create tab in the ribbon.
3. Select Query Design.
4. In the Show Table dialog box, select the table you want to query.
5. Click Add to add the table to the query design view.
6. In the query design grid, double-click the fields you want to include — they will appear in the lower grid.
7. Click the Run button in the ribbon to see the query results.
8. Close the query design window, give your query a name, and click OK to save it.