Home > Sample chapters > Microsoft Office > Access

Creating Queries in Access 2010

Writing Query Results to a New Table

When you run a query, Access writes the records the query finds into a dynaset, or dynamic record set. While Access remembers the results of queries you run, the results aren’t actually written to a table, limiting what you can do with the data. You can, however, modify a select query so the results are written to a new table.

Create a Make-Table Query

  1. Open a query in Design view.

  2. Click Make Table.

  3. Type a name for the new table.

  4. Click OK.

  5. Click Run.

    httpatomoreillycomsourcemspimages613760.jpg
  6. Click Yes to create a new table that contains the selected records.