1-866-245-5224 sales@keystonelearning.com

Access 2003: Using the Query Wizard

Access 2003: Using the Query Wizard

A Select Query is simply a type of filter that you can save and display the matching recordsets in Datasheet view. One of the nice things about queries is that they can display matching records from one or more tables or other queries. This means, queries give you a great deal more flexibility when compared to Filters.

And, because queries can be saved, you never have to re-create one once it’s been created. Each time a query is opened, or run; Access looks at the underlying tables or queries to display the most recent information.

Creating a Query Using the Query Wizard

     
  1. Display the Query objects in the Database window
     
  2.  
  3. Click the New button on the toolbar
     

Figure 25. New Query Dialog Box – Simply Query Wizard

          3.     Select Simple Query Wizard and then click OK

Figure 26. Query Wizard - Select Tables & Fields

 

     4.      Select a Table or Query

     5.      Move fields from Available Fields to Selected Fields

     6.      Repeat steps 4 and 5 for additional tables for queries

     7.      Click Next

 

Figure 27. Query Wizard - Query Title

    

           8.     If desired, change the Query Title

           9.     Click Finish