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
Display the Query objects in the Database window
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