Chat with us, powered by LiveChat

Create a Query

How to Create a Query in Access

Create a Query

Create a Query

  1. Click the Create tab on the ribbon.
  2. Click the Query Design button.

    You can also use the Query Wizard to create a query. Click the Create tab on the ribbon and click the Query Wizard button in the Queries group.

    Create a Query

    The Show Table dialog box appears.

    Follow the onscreen instructions to create the query.

  3. Select the table(s) you want to add to the query and click Add.
  4. Click Close.

    You can also add tables to a query by dragging them from the Navigation Pane to the top half of the Query window.

    Create a Query

    The Query window appears in Design View. Notice that the window is split. The top half contains a box that displays all the fields in the table you added to the query. The bottom half of the screen contains a design grid, which is where you will add the fields you want to appear in your query.

  5. Double-click each field you want to include in the query.

    You can also add fields by dragging the field from the field list onto the design grid.

    Often you will have to use the field list's scroll bar to scroll up or down the list to find a field.

    Now you need to specify any criteria for the query. Enter the criteria in the design grid's Criteria row. For example, you could select to see only records whose City field contains "London", or you could enter K* to return only results that begin with K.

  6. Enter any search criteria for the field in the Criteria box.

    Deselect the Show box for a field if you want to use a field in a query but you don't want it to be displayed.

    Create a Query

Save a Query

Once you have created a query, you'll want to save it to use later.

  1. Click the Save button.
  2. Enter a name for the query.
  3. Click OK.
    Save a Query

The query is saved and now appears in the Navigation Pane.

Run a Query

Your queries run when you open them through the Navigation Pane.

  1. Open the query or click the Run button if you're in Design view.
    Run a Query

Access displays the results of the query.

FREE Quick Reference

Click to Download