Access 2003
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.
- The Simple Query Wizard opens.
- From the Tables/Queries drop-down list, choose the table/query containing the fields you want to include in the query.
