As the most popular database program, Microsoft Access databases store more and more data every day increasing the need to analyze it statistically. Unfortunately, the built-in tools available within Access are limited in their ability to perform advanced data analysis. To generate statistical analysis beyond the rudimentary features of Access queries requires a great deal of programming.
There are many statistical programs on the market, but they are not designed specifically for MS Access databases and usually require learning a different programming language and terms. Additionally, they require exporting data into those programs, performing the analysis there, and then importing the data back into Access. In some cases, the results are provided as text files that need to be parsed in order to integrate back into Access. This approach is not only time-consuming, but error-prone and usually cannot be automated.
The statistical analysis programs that are available also tend to be large stand-alone programs licensed on a per user basis.
Total Access Statistics was designed specifically for Access and works directly in Access as an add-in.
Simply open the database containing the data to analyze, then invoke Total Access Statistics from the add-ins menu.
Total Access Statistics solves these problems by giving users a wide range of statistical analysis functions with the features and options database users and developers expect.
Calculations such as percentiles, correlations, confidence intervals, regressions, t-Tests, group analysis, non-parametric analysis, rankings, financial cash flow analysis, record normalization, and probability calculations can be easily generated.
The interactive Statistics Wizard makes it easy to select the data, fields, and statistical options to perform. All settings are automatically saved for re-use. Any Microsoft Access table, linked table (including SQL Server, Oracle, dBase, Paradox, FoxPro, etc.), or SELECT/CROSSTAB query can be analyzed.
Total Access Statistics also supports ADPs with direct use of SQL Server tables, views, stored procedures, and user defined functions.
An unlimited number of records and multiple fields can be analyzed at once. Best of all, the results are in tables that can be viewed, sorted, queried, or analyzed further. They can also be merged with other data, and added to forms and reports. Eliminate the need to export data or import results.
Total Access Statistics can also be added to Microsoft Access applications using VBA.
Developers who want statistical analysis in their databases can bypass the Add-in Wizard and include all the statistical features directly into applications with a simple VBA procedure call.
Your users don’t even need to know that Total Access Statistics is running in the background.
A royalty-free runtime distribution license is included to allow you to distribute such applications to non-Total Access Statistics owners.
Only one library file (under 3 MB) needs to be distributed.
Version 14.1 for
Microsoft Access 2010
Version X.9 for
Microsoft Access 2007 and 2003
Version X.8 for
Microsoft Access 2002, 2000, and 97
"Total Access Statistics performs a wide range of data analysis right inside Access. The product includes a Statistics Wizard to perform parametric, group, non-parametric, record analysis and more. The results are placed in Access tables that you can integrate into your forms and reports."
Alison Balter, Author