Ms Access Tutorial

Lesson 7

Query allows you to work with a specific set of records that meet the criteria you have specified from a table in the database.

Query Window Elements

* Field – this is where you select a field to be part of the query

* Table- indicates the filename of thee table you are working on

* Sort – allows you to sort the results of the query

* Show - the show checkbox determines if the field is to be disp;ayed in the query results

* Criteria – this is where you will enter the search conditions for the fields you want to search.

Using queries with simple query wizard

1. On the create tab click the query wizard

2. On the new quert dialog box, click the simple query wizard and click ok

3. When the simple query wizard opens, click the down arrow to select the table or other query from which you want to select fields

4. Click a field and click the right arrow to move the field to the selkescted field list click the double arrow to move all the fields at nce.

5. You can pull as many fields as you want

6. Click next

7. Type the name for the query and click finish

Creating Queries Using the Query Design View

1. On the create tab, click query design

2. On the query design window, a show table dialog box appears

3. Click the table that you would like to include in the query

4. Click add

5. Repeat the steps if you want to add more tables, then click close

6. The upper part of the query window displays the available tables and fields. The lower part is the query grid that allows you to specify the information needed to create a query

7. Drag as many fields as you need into the first empty column in the query grid.

8. Click view to check the query results in the datasheet view

9. The results will appear in the datasheet

10. Click the save button and on the save as dialog box type the name of your query

11. Click ok

Editing the Query

To insert a field 1. On the...