How to Create Query in MS Access Step by Step



Guide

  1. Open the database file where you want to create the query.

  2. Go to the 'Create' tab on the ribbon.

  3. Select 'Query Design'.

  4. Select the table(s) or existing queries you want to base your query on

  5. Click 'Add'.

  6. The added tables appear as small grids with their fields listed. Double-click the fields you want to include in the query.

  7. Click the 'Run' button, the red exclamation mark in the ribbon to execute the query.

  8. Close the query design window. When prompted, give your query a name and click 'OK'.

🚀

Create your first interactive demo in minutes

No credit card required • Start building today

Start free

    This website uses cookies to enhance the user experience.

    AcceptDecline