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.

How to Create a Spreadsheet Using Access. Excel and Access are two software applications which belong to the Microsoft Office suite. You can create a data file in a spreadsheet format using Access ...

References Microsoft: Introduction to Importing and Exporting Data Microsoft: Exchange (Copy, Import, Export) Data Between Excel and Access Microsoft: Top 10 Reasons to Use Access With Excel ...

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.