Creating a Query in MS Access

Creating a query in MS Access

Queries are extracts which are created and saved for future use. You can create a query by taking the steps as follows:

1. Click on Query Wizard option in other group on Create TAB. New Query window will come on the screen.


2. Select Simple Query wizard from New Query window

3. Next, click on OK button. Simple query Wizard window will appear.

4. Click on TABLES/ Queries box to select the first table.

5. When you will click on [>] button, the selected field will be copied to selected fields box from Available Fields.

6. You can add more tables and add more fields if required.

7. If you have selected fields as well as tables to add, click on Next button. Now, you will see the wizard as shown here:

8. Click and select the option open the query to view information and then click on Finish button.

9. Finally, you can specify the query criteria.