but Microsoft's Transact-SQL extension includes this handy feature. Creating a new table from query results can help you build a database of your clients, employees, expenses and other business ...

Use SQL to quickly create a new table from existing records in Access ... For example, suppose in Access you want to create a phone list for all employees in the Fort Myers region.