Quick summary
In Microsoft Access, you can create reusable query views using the Query Design tool to filter, sort, and display data from your tables. This step-by-step guide shows you how to build, configure, and save a query so it works like a permanent database view.
Steps
- Open your Access database and ensure the tables you need are present.
- Click on the Create tab in the ribbon.
- Click Query Design to open the query builder.
- Select your preferred table and click Add Selected Tables.
- Drag the fields you want to include into the design grid at the bottom of the Query Design window.
- To sort the data, choose Ascending or Descending in the Sort row.
- To filter the data, specify conditions in the Criteria row of the design grid.
- Click Save to save your query configuration.
- Give your query a descriptive name and click OK.
- The saved query can now be used like a reusable view across your database.
