In Microsoft Access, a Relationship helps you to merge or link data from one table to another. Relationships allow the user to create Queries,Forms, and Reports. When tables are created for each ...

Replace "new_table" with the name of the table to create, and replace "old_table" with the name of the table to select from. The INTO clause behaves the same as CREATE TABLE in other SQL environments.