If your business uses relational databases to store data, it helps to use the SQL SELECT command with the INTO clause to create new tables from ... of your clients, employees, expenses and other ...

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.