Total Access Statistics is the most powerful data analysis program for Microsoft Access. It runs as an Access add-in and offers a wide range of statistical functions to analyze your data.
How can I perform analysis in Total Access Statistics without cluttering up my database with output tables?
Since Total Access Statistics creates output tables in the current database, you may clutter your database with unnecessary tables.
Using a Separate Database
If you are performing a lot of ad hoc analysis and want to keep it separate from your main data tables, create a new database and link to your data tables. This keeps the results of Total Access Statistics separate from your main database. If you are not familiar with using linked tables, consult your Microsoft Access manual or help file.