Query in MS Access

Query

A query is a method of getting answers to questions about the data. The query can involve a single table or multiple tables to answer a question about the data. Some of the examples are:

• The list of students who got greater than 80 percentage.
• The list of students who have submitted the March month fee.

You can create queries in two ways: Query Wizard and Query Design

Steps to create query using Query Wizard

• Click on Create Tab
• Click on Query Wizard option in the Queries group.
• A New Query dialog box appears. Select Simple Query Wizard and click on the OK button.
• The Simple Query Wizard screen appears. Select the table that contains your data in the Tables/ Queries box.
• Now add the fields you want in the query results. Make use of arrows to add or remove the fields. Then click on Next button.
• Now select Detail or Summary option from the dialog box. Click Next.
• Type a query name in the text box, and select Open the query to view information option. Then click on Finish button.

Steps to create query using Query Design

• Click on Create Tab
• Click on Query Design option in the Queries group. The Show Table dialog box appears.
• Select the table on which you want to base your query and click on the Add button to add the table and then click on Close.
• Add the fields in the Design Grid by Double clicking on the field names or by Drag and Drop method from the small table window .
• Type the search condition in the Criteria row of the field, Clear the Show checkbox for fields that should not appear in the Query Result.
• Click on Ascending or Descending order from the Sort box under that field, if you want to show query in sorted way.
• Click on Save option under Quick Access Toolbar, give the name of your query and click on OK button. Now click on Run option in the Results group to execute the query.