Perform statistical analysis on Microsoft Access data

Numerical Analysis for Microsoft Access data

Numerical Analysis for Microsoft Access: Download the Trial Version of Total Access Statistics

Why Choose Total Access Statistics?

Microsoft Access has Limited Number Crunching Power

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.

The Total Access Statistics Solution

Designed Specifically for Microsoft Access

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.

Wide Range of Statistical Functions

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.

Award Winning Solution

Multiple winner of the Access Advisor Reader’s Choice Award for “Best Business Product”, Total Access Statistics is the most powerful data analysis tool for Access and is simply the best solution for generating complex statistical analysis in Access.

Interactive Wizard Requires No Programming

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.

Programmatic Interface

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.