---

MS Access 2007: Create a query

This MSAccess tutorial explains how to create a query in Access 2007 (with screenshots and step-by-step instructions).

Question: In Microsoft Access 2007, how do I create a query?

Answer:Select the Create tab in the toolbar at the top of the screen. Then click on the Query Design button under the Other group.

Next, highlight the tables that you wish to use in the query. In this example, we've selected the Employees table and clicked on the Add button. When you are done selecting the tables, click on the Close button.

Add the fields to the query. You can do this by double-clicking on the field name. In this example, we've added the LastName, FirstName, and Address fields.

Then click on the Save button at the top left of the window (this is the button with the picture of the disk).

The Save As window should appear. Enter the name that you'd like to assign to the query and click on the OK button. In this example, we've saved the query as Query1.

You should now see the query appear in the left window.