The latest version for Access 2007 is 12.9.
This page describes the enhancements for 12.0 when the Access 2007 version was originally released, compared to the prior Access 2003 version.
Total Access Statistics for Microsoft Access 2007 (version 12.0) is its ninth major release. Designed specifically for Microsoft Access, we've added many features to support the new capabilities of Access 2007. Access users and developers can now perform even more numerical analysis within Access.
Since the release of Total Access Statistics 2003 (version 11.5) for Access 2003, we've added many new features. Many of the enhancements are also available in Version x.7 for pre-Access 2007 versions. Existing customers can upgrade for a nominal fee.
Main Menu of Total Access Statistics in the Access 2007 Tabbed Interface
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
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
Date fields can now be used to perform percentile calculations and frequency distributions.
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 11.0 for Access 2003, there was a previous release of version 11.5 with many new enhancements. All of those enhancements are included in the 2007 version. Here's a list of the 11.0 to 11.5 improvements.
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