GCFLearnFree.org

You people are utterly amazing. I use and recommend you all the time!”

Online Learner

GCFGlobal.org
Creating Opportunities For A Better Life.®
  • All Topics
  • Access 2003
  • Running Database Queries

Access 2003

Single page view print copy

Running Database Queries

Creating a single-table query

  • The Available Fields text box displays all fields contained in the table selected in the Tables/Queries field. Here, you can select the fields to be used in the new query. You can choose one or more, or even all fields in the query.

    Select Fields To Be Used In The Query

    Click to highlight the first field to be included in the query—Last Name, for example—then click the right arrow button. Repeat until you have selected all fields to be used (First Name, Address, City, State/Province, and Postal Code).

    Fields Included In The Query
  • If the fields you selected include a number field, you are 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 the Next button.
  • Type a name for the query (e.g., Contacts Mailing Address) in the What title do you want for your query? field.

    (Leave the Open the query to view information radio button turned on.)

    Assign a Name to the Query

  • Click Finish to run the query.
previous next
previous 1 2 3 4 5 6 7 8 next
Terms Of Use

©1998-2014 Goodwill Community Foundation, Inc. All rights reserved.