How to Convert an Access Query to a Table

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.

Access 2007 and Newer Versions

Step

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

Step

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

Step

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

Step

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

Step

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

Step

Click the “Run” icon in the “Results” group. Click “Yes” when prompted.

Access 2003 and Older Versions

Step

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

Step

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

Step

Click “Query” in the main menu. Select “Make Table Query.”

Step

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

Step

Click “Query” and select “Run.” Click “Yes” when prompted.