How to Convert an Access Query to a Table

By Mercedes T. Green

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 1

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

Step 2

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

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.

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.

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.

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.