Creating a Select Query in Design View


You don't have to use the Simple Query Wizard to create select queries; you can create a new select query in Design view.



To create a select query in Design view:

  1. In the Queries window, double-click Create query in Design view.
  2. Click the name of each table you want to include. Click the Add button (or double-click the name of the table). Click the Close button when you are ready to continue.
  3. To add fields to your query, double-click the name in the field list. You can also click the name and drag it to the design grid.
  4. When you have added all the fields you want, run the query by clicking the Run button (or select Run from the Query menu).


If you want to include all the fields from a table in your query, click and drag the asterisk (*) to the field row. Notice that rather than listing each field from the table separately, there is only one field called table.* (where \"table\" is the name of the table). The * character represents a wildcard. Rather than look for specific field names, the query will look for all the fields in that table. So, if you later add or delete fields, you won't need to change the query design.

You can add tables to the field list by clicking the Show Table toolbar button or selecting Show Table from the Query menu.

You can create a select query in Design View by:

  1. Double-click Create query in Design view.
  2. Click the New button. Click Design View. Click OK.
  3. Select Query from the Insert menu. Click Design View. Click OK.