# How to Create Views MS Access

> To create views in Microsoft Access, open your database, click the 'Create' tab, and select 'Query Design'. Add your desired tables, drag fields to the design grid, set sorting and criteria, then save the query with a descriptive name to use it like a view.

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

## Steps

1. Open your Access database and ensure the tables you need are present.
2. Click on the 'Create' tab button.
3. Click 'Query Design'.
4. Select your preferred table and click 'Add Selected Tables'.
5. Drag the fields you want to include in your query to 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 the changes.
9. Give your query a descriptive name and click 'OK'.
10. The saved query can now be used like a view.