Create a Query

If you have chosen to use one of the templates provides on the Access 2007 Getting Started page, a number of queries, reports, tables, and forms have already been built for you. However, they may not meet your needs or you may be working with a database you have built yourself. In that case you may need to build a query using the steps below.

Say you want to build a query on a table you built called Contacts. You want to find the sales representatives that work for the company named Lizzie, Ltd.

1. On the Create tab, in the Other group, click Query Wizard.
2. In the New Query dialog box, click Simple Query Wizard, and then click OK.
3. Under Tables/Queries, click the table that has the data that you want to use. In this case, click Table: Contacts. Note that a query can also use another query as a source.
4. Under Available Fields, double-click the Last Name, First Name, Company, Business Phone, and Mobile Phone fields. This adds them to the Selected Fields list. When you have added all four fields, click Next.
   
5. Name the query Lizzie Ltd. Contact, click Modify the query design and then click Finish.
   
6. The Design View is displayed. Under Criteria for Company, type =Lizzie, Ltd.
   
7. Click Run in the Results Group.
   
8. The results show all of the contacts that work for Lizzie, Ltd and only show the four fields that you specified in the query wizard not the entire record of those individuals.