How to Create a Make-Table Action Query in Access 2003

When you create a make-table action query in Access 2003, you can copy the entries from one or more tables in the database to a new table. You can pick fields to include for each entry, and organize the entries as they appear in the new table. The make-table action query also lets you search source tables for entries that fit criteria you define. Take advantage of this resource by following these steps.

Things You'll Need

• Computer
• Access 2003

Instructions

1. Open the Access 2003 database in which you want to create a make-table query. Pull up the "Task Pane" and click on the database name. This will pull up the database window.

2. Click "Queries" and open the "New Query" window. Scan down the list of options. Choose "Design Stored Procedure." The "Add Table" box will appear.

3. Select the table or tables that you want to use as sources for the make-table action query. Click the "Close" button.

4. Click "Make-Table Query." Type the name of the table you will create using the action query.

5. Choose the columns that you want included in the new table. Choose a sort order if you wish.

6. Create your search conditions. The Access application will hunt through the source tables and pull up entries that fit your search criteria.

7. Save your work before exiting.

Tips & Warnings

• If you do not specify any search conditions when you create a make-table action query, every row from the source table or tables will appear in the new table.

• You may not be able to create a new table in a database if you lack the requisite privileges. Contact your system administrator if you have a question regarding your Access 2003 privileges.