GCFLearnFree.org

Every day I fall a little more in love with your site.”

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 multiple-table query

Queries are not confined to just a single table. You can create a query that runs against multiple fields in multiple tables. This query is created in an identical manner to the single-table query defined on the previous page. The only difference when creating a multiple-table query is that after selecting the fields in one table, as we saw in the last example, you then select the next table and choose additional fields.

In this query, we will ask for the Name, Contact Type, and Phone Number of all records in the Contacts table. When we create the query, we will select fields from two tables: Contacts table (Last Name, First Name, and Work Phone fields) and Contacts Type table (Contact Type field).

To create a multiple-table 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 options, and click the Open button.
  • The Simple Query Wizard opens.
  • From the Tables/Queries drop-down list, choose the first table where you would like to perform the query (e.g., Contacts).

    Tables/Queries Dropdown in Simple Query Wizard
  • From the Available Fields, select the fields to be included from this table (e.g., Last Name, First Name, and Work Phone).

    Select Fields to be Included in 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.