Guide

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.