This is no longer the latest version of Total Access Statistics 2007, 2003, 2002 and 2000.
Existing X.7 customers can upgrade for a nominal fee. For more information
on the new features, visit Version X.9 for Total Access Statistics 2007 and 2003
and Version X.8 for Total Access Statistics 2002 and 2000.
Total Access Statistics offers a wide range of statistical functions for Microsoft Access users and developers. Developed specifically for Microsoft Access, Total Access Statistics eliminates the need to export your data to other programs for statistical analysis.
When we introduced Total Access Statistics for Access 2007 (version 12), we added many of its new features into earlier versions of Access in versions X.7.
New versions of Total Access Statistics are now available:
Existing customers with a current Annual Premium Support Plan will receive the upgrade for free. Customers without a support contract can upgrade for a nominal fee.
Data in Access Data Projects (ADP) can now be analyzed. Perform statistical analysis on your SQL Server data with results stored in SQL Server tables. Data sources can be views, stored procedures, and user defined functions.
Previously, Total Access Statistics only supported Access MDB/Jet databases which could be linked to SQL Server.
All the statistical analyses now support parameterized queries as the data source. For ADPs, data sources may be stored procedures and user defined functions with parameters.
A new screen lets you specify the value for each parameter:
Calculate running averages, sums, counts, etc. for a sorted list of values and placing the values in a field in your table. The running value can be for all records or a moving set of records such as the running average over the last 10 records.
The values are stored directly in your data source in the fields you specify. Up to five fields can be updated at one time.
Example of Calculating 5 Different Types of Running Totals on the Sales Field
Here's additional information on calculating Running Totals and Moving Averages in Microsoft Access.
For Regressions, the estimated Y value can now be added directly into a field in your data source. This is available where thereís only one regression equation calculated at a time such as a multiple regression or a simple or polynomial regression with only one independent (X) field.
For Percentiles, a new option is available to assign percentile values to records. If there are multiple percentile values for the same recordís value, you can choose to assign the low or high percentile to that record. Previously, it always assigned the low value.
Here's additional information on Calculating Percentiles in Microsoft Access
A new option is available in the Statistics Function to let you specify the table containing parameters for parameterized data sources.
If you are on version X.0, there was a previous release of version X.5 with many new enhancements. All of those features are part of version X.7. Here's a list of the X.0 to X.5 improvements.
For more information, visit our entire History of Total Access Statistics Releases and Updates.
Download and try the free trial version of Total Access Statistics on your data.
If you want to look at how it works without installing the program and review the calculations it generates, check out the help file for more details of these and other Total Access Statistics features (included in the trial download).
Total Access Statistics runs as an Access add-in which is dependent on your version of Access. Each version can support all the database types supported by that Access version. For instance, Total Access Statistics 2010 can run on all ACCDB and ADP databases, and MDB database formats since Access 2000. Total Access Statistics 2016 is similar, except it doesn't support ADPs which are not supported since Access 2013.
Total Access Statistics Pricing
by Microsoft Access Version
|Microsoft Access Version|
|Single||$599||Buy Now||Buy Now||Buy Now||Buy Now||Buy Now||Buy Now||Buy Now||Buy Now|
|5-Seat||$1799||Buy Now||Buy Now||Buy Now||Buy Now||Buy Now||Buy Now||Buy Now||Buy Now|
Upgrade Between Access Versions
|Single||$399||Buy Now||Buy Now||Buy Now||Buy Now||Buy Now||Buy Now||Buy Now||Buy Now|
|5-Seat||$1199||Buy Now||Buy Now||Buy Now||Buy Now||Buy Now||Buy Now||Buy Now||Buy Now|
Update to the Latest Version within the Same Version
|Single||$249||Buy Now||Buy Now||Buy Now||Buy Now||Buy Now|
|5-Seat||$749||Buy Now||Buy Now||Buy Now||Buy Now||Buy Now|
Premium Support Subscription
Also available as part of
Total Access Ultimate Suite
|Total Access Statistics includes a runtime library with royalty-free redistribution rights.
Use is subject to the terms of the License Agreement.
|Total Access Statistics is licensed on a per user basis.
Each user who runs the program must have a license.
Read the License Agreement for details.
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