How to Create Query in MS Access Step by Step
In this article
Creating queries in Microsoft Access is essential for extracting specific information from your database tables. Queries allow you to filter records, combine data from multiple tables, and perform calculations without modifying your original data.
This tutorial walks you through the complete process of building a basic query in Access, from selecting your data sources to executing and saving your query for future use.
Here's how to create query in MS Access
- Launch your Access database file that contains the data you want to query.
- Navigate to the 'Create' tab in the ribbon menu at the top of the screen.
- Click on 'Query Design' from the available query options.
- Choose the tables or saved queries that contain the data you need for your query.
- Press the 'Add' button to include your selected data sources in the query design.
- View the table grids that display all available fields from your selected tables.
- Double-click on each field name that you want to appear in your query results.
- Press the 'Run' button (red exclamation point icon) to execute your query and see the results.
- Close the query design window and provide a descriptive name when prompted to save your query.
Your turn to show how it works.
Build a walkthrough of your product with Saltfish, then share it with your customers.
Frequently Asked Questions
Query Design gives you full control over creating queries manually by selecting fields and setting criteria yourself. Query Wizard guides you through the process step-by-step, making it easier for beginners but with less flexibility for advanced customization.
MS Access