How to Convert an Access Query to a Table

Techwalla may earn compensation through affiliate links in this story. Learn more about our affiliate and product review process here.

As your database needs change, you may find that your existing tables contain too many fields. You should normalize poorly designed tables in your database so it will run more efficiently. Use the Make Table Query in Microsoft Access to break your existing tables into smaller tables. You can also use this query to combine the data from one or more tables into a single table, or to send new tables to different Access databases.

Advertisement

Access 2007 and Newer Versions

Video of the Day

Step 1

Open Access. Click "Office" in the upper-left corner of the window.

Video of the Day

Step 2

Select "Open" from the menu. Highlight the database you want to open. Click "Open."

Advertisement

Step 3

Right-click on the query in the "Navigation Pane." Select "Design View."

Step 4

Click on the "Make Table" icon in the "Query Type" group of the "Design" tab.

Advertisement

Step 5

Type a name for the new table in the area beside "Table Name." Click the radial button for "Current Database." Click "OK."

Step 6

Click the "Run" icon in the "Results" group. Click "Yes" when prompted.

Advertisement

Access 2003 and Older Versions

Step 1

Open Access. Click "File" and "Open" in the menu. Find and highlight the database file you want to open. Click "Open."

Step 2

Select "Queries" from the "Objects" pane. Right-click on the query. Select "Design View" from the displayed menu.

Advertisement

Step 3

Click "Query" in the main menu. Select "Make Table Query."

Step 4

Type a name for the new table in the area beside "Table Name." Click the radial button for "Current Database." Click "OK."

Step 5

Click "Query" and select "Run." Click "Yes" when prompted.

Advertisement

Advertisement

references

Report an Issue

screenshot of the current page

Screenshot loading...