Create a query from scratch

If you are planning to use a query to request data from more than one table, those tables must be joined by a relationship.
  1. From the queries list, click the New button.
  2. Select Design View and click OK.
  3. From the Show Table dialog box, click a table you want to work with in your query and click Add. Repeat this step for other tables that will be utilized by the query.
    • If you make a mistake, don’t worry—you will be able to delete a table you added.
  4. Click Close when you have finished adding tables.
  5. Use the skills in the section Modifying queries to create the query.
  6. When you are finished, close the query. You will be asked to enter a name for the query.
Hide comments


  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.