GCFLearnFree.org

All this was FREE!! The GCF team rocks!”

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

In this example, we will create a new query and run it against that very same Contacts table. We will type the following command in the table: Show me the mailing address of all records in the Contacts table. When we create the query, we need to select the following fields in the Contacts table: Last Name, First Name, Address, City, State/Province, and Postal Code.

To create a simple query:

  • Open the Contacts Management database.
  • In the database window, choose the Queries tab from the Objects palette.
  • Select the Create query by using wizard option, and click the Open button.

    Create Query Selection Under the Queries Palette
  • The Simple Query Wizard opens.

    Simple Query Wizard
  • From the Tables/Queries drop-down list, choose the table/query containing the fields you want to include in the query.

    Tables/Queries Dropdown in Simple Query Wizard
previous next
previous 1 2 3 4 5 6 7 8 next
Terms Of Use

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