When you make selections using SQL Select, temporary tables are generated from your source table. When displayed in windows, these tables are named Query1, Query2, and so on. Closing these tables eliminates them but does not affect your source table. However, if you close your source table, all associated query tables will be closed and eliminated.
To save the contents of a query table:
- On the HOME tab, in the File group, click Save Copy As.
You can then close the query table, effectively deleting it, and later open it under the name of the table you created through Save Copy As.