ACCESS

Dynamic, Linked Tables

One to another

Link Access and Excel tables and create reports.

"Microsoft Access provides some powerful (not to mention easy-to-use) reporting features. One of those features is the Report Wizard, which lets you create attractive reports from data stored in a variety of sources, including Microsoft Excel worksheets and text files. Another such feature is the ability to create linked tables, which provide a way to synchronize your reports with your source data. When you create a report by using linked tables, the data in the report changes automatically whenever the source data changes.

You can use the techniques described here to create nearly any kind of report. The following steps use data from the Northwind Traders sample database supplied with Access. Northwind Traders is a fictitious grocery wholesaler, and you can use the data to create and change a product report."