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

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.

Things You'll Need

  • Microsoft Access
Show More

Instructions

    • 1

      Open the database window (use the F11 key), then click on the Query tab.

    • 2

      Click New, then Design View.

    • 3

      Click OK.

    • 4

      Create a query with the tables or queries you want to use to create the new table. Select Make Table from the Query menu.

    • 5

      Use the Table Name box to name the table you want to create.

    • 6

      Use Current Database or Another Database to indicate where you want to put the new table.

    • 7

      Click OK.

    • 8

      Drag the fields you want to use from the field list into the design grid.

    • 9

      Type your criteria (all dates after 1/1/00, for example) in the Criteria cell.

    • 10

      Preview the new table by switching to Datasheet view.

    • 11

      Return to Design view and create the new table by clicking Run on the toolbar.

Related Searches:

Comments

  • 15awilson Jan 14, 2011
    ohh, hahaha ^ yeah it did but thankss cause i wouldnt had been able to do my project, hahaahahahahahaha (: :p

You May Also Like

Related Ads

Featured