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

By eHow Computers Editor

Rate: (25 Ratings)

You can use a Make-Table action query in Microsoft Access to create a new table from all or part of the data in one or many tables. For example, you may want to use records from various tables to create a new table that will be exported to a different database. These instructions apply to MS Access 97.

Instructions

Difficulty: Moderate

Things You’ll Need:

Step1
Open the database window (use the F11 key), then click on the Query tab.
Step2
Click New, then Design View.
Step3
Click OK.
Step4
Create a query with the tables or queries you want to use to create the new table. Select Make Table from the Query menu.
Step5
Use the Table Name box to name the table you want to create.
Step6
Use Current Database or Another Database to indicate where you want to put the new table.
Step7
Click OK.
Step8
Drag the fields you want to use from the field list into the design grid.
Step9
Type your criteria (all dates after 1/1/00, for example) in the Criteria cell.
Step10
Preview the new table by switching to Datasheet view.
Step11
Return to Design view and create the new table by clicking Run on the toolbar.

Post a Comment

POST A COMMENT

Request a New How-To Article

Looking for more How To information? Chances are there’s an eHow member who knows how to do what you’re looking to do. Submit an article request now!

eHow Article: How to Create a Make-Table Action Query in Microsoft Access

eHow Computers Editor

eHow Computers Editor

Category: Computers

Articles: See my other articles

Related Ads