How to Create Views MS Access

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

1. Open your Access database and ensure the tables you need are present.
2. Click on the Create tab in the ribbon.
3. Click Query Design to open the query builder.
4. Select your preferred table and click Add Selected Tables.
5. Drag the fields you want to include into the design grid at the bottom of the Query Design window.
6. To sort the data, choose Ascending or Descending in the Sort row.
7. To filter the data, specify conditions in the Criteria row of the design grid.
8. Click Save to save your query configuration.
9. Give your query a descriptive name and click OK.
10. The saved query can now be used like a reusable view across your database.