Queries

In Access 2000 queries may seem confusing at first. This free lesson offers step-by-step instructions on how to run them.

Creating a simple query

To create a simple query:

  • Open the Great Lake Elementary School database.
  • In the database window, choose the Queries tab from the Objects palette.
  • Select Create Query by using Wizard and click the Open button, Open button double-click it, or right-click it and choose Open from the shortcut menu.
  • The Simple Query Wizard opens.
  • From the Tables/Queries drop-down list, choose the table or query containing the fields you want to include in the query.
  • In the Available Fields text box, select the fields you want to include and click the right arrow or double-click the field to move the fields into the Selected Fields text box.
  • Select any additional tables and queries from the Tables/Queries drop-down list and repeat. Click Next when all fields have been selected.
  • If the fields you selected include a number field, you'll be asked to select a summary or detail query. To see each record, choose Detail. To see sums, averages, etc., choose Summary and set the summary options. Click Next.
  • Provide a name for the query. Click Finish to run the query.

Simple Query Wizard