How to Create a Table From an Access Query
If you've created a database file with the Microsoft Access database management application, then you can add tables to your database using the Make Table feature. The table you create contains the fields and data you specify from an external file. For example, the table created from a query can contain combined fields from two different spreadsheet files. Once the query table has been run, it will be added to the Access database.
Other People Are Reading
Instructions
-
-
1
Open Microsoft Access and then select the "Microsoft Office" button from the top menu. Click the "Open" option.
-
2
Click the database file you want to create a table in and then click the "Open" button. The file will then launch in the application.
-
-
3
Click the "Design" tab and then click the "Make Table" option from the "Query Type" group. The Make Table dialogue box will appear.
-
4
Enter a name for your table into the "Table Name" text box and then click the "Current Database" option. Click the "OK" button and then click the "Run" button.
-
5
Click the file containing the fields you want to add to the table and then click the "Add" button. Click and drag each field into the new table that you want to add.
-
6
Click the "Yes" button to confirm the creation of the query table. The table query will then be fully created.
-
1
