How to Create Queries in MS-Access?

A query is a condition to extract the information from a data base. This query is a filter through which data is evaluated. You can define filter criteria in the query and only those records which meet the criteria are displayed.

In MS Access, we have following types of queries

1. Select query

2. Action query

3. Update query

4. Cross tab query

Create a Query:-

Open the data base and then select the query tab.
Click on new button.
Select simple query wizard from query dialogue box and click on ok button.
Select the required fields from wizard dialogue box.
Click on next button when you are ready to continue.
Select the open query to view information.
Click on the finish button. Then the query result will be displayed on the screen by running the   query.


MS Access 760966021464930817

Post a Comment