How to Create a Table From a Query in Access 2003

You can create a table from a query in Access 2003 by using the Access action queries. Action queries let you perform actions on your database, including the following table actions: make, append, delete, and update table data. The action query requires you to specify the action in the query design view. The database prompts you to confirm the action query before performing the action. Once the action is performed, the database is updated.

• 1

  Open Access 2003. Click the "File" option on the menu bar. Click "Open." Click on your database name and select "Open." The database opens.

• 2

  Click the "Query" object in the database. Select the "Create a query in design view" option. The Show Table dialog box appears. Add a table to the query by clicking the "Add" button. Close the Show Table dialog box by clicking the "Close" button.

• 3

  Add fields to the query by double-clicking the field names from the table list. Click the "Query Type" icon on the menu bar. A drop-down list appears. Select "Make Table." Type a name for your query in the "Query Name" box. Click "OK."

• 4

  Run the query by clicking the "Run" icon on the menu bar. Access prompts you to confirm the pasting of new records into a new table. Click "Yes." Access creates a new table based on the make table query.