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.

Create a Form for a Query or Table, Edit & Delete Data, Navigate through Records, Add & delete Rows and Records in a Form in Access.

Microsoft Access software lets you create a small database you can use on your website. You must first create a new database, then create the tables that store the website information.

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.

Take that recordset and use it to create a new table (a temporary one) in the local Access database.<BR>3. Close the recordset.<BR>4. Run my report off the new temporary table<BR>5.