Total Access Statistics for Microsoft Access 2007


This is no longer the latest version of Total Access Statistics 2007.
Existing 12.X customers can upgrade to the latest version for a nominal fee.
For more information on the new features, visit Total Access Statistics 2007, Version 12.9.


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.

Supports Microsoft Access 2007

  • Runs as an add-in within Access 2007. Launches from the Database Tools, Add-ins ribbon.
  • Supports the new Access 2007 database format (*.ACCDB), in addition to MDB and ADP databases.
  • Ships with a new 182 page user manual.
  • Includes a new online, context sensitive help file.

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.

Supports Microsoft Access 2007

  • A cleaner, more modern user interface with support for Vista and Office/Access 2007 styles, fonts, color schemes, transparent buttons with icons, datasheets with alternating colors, etc.
  • Support for Tabbed Documents windows options including resizable forms
  • Enlarged screens show more options and fields to select.
  • Field data type names are now localized in non-English versions of Access.

Statistics Wizard
Main Menu of Total Access Statistics in the Access 2007 Tabbed Interface

Access Data Projects (ADP) Support

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.

Use Parameterized Data Sources

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:

Parameterized Data Sources

New Running Totals Calculations

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.

Running Totals in Microsoft Access
Example of Calculating 5 Different Types of Running Totals on the Sales Field

Enhanced Regression Analysis

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.

Enhanced Percentile Analysis

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 Analysis

Date fields can now be used to perform percentile calculations and frequency distributions.

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.

A new option is available in the Statistics Function to let you specify the table containing parameters for parameterized data sources.


Pricing and Access Versions

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
Licenses Price 2016 2013 2010 2007 2003 2002 2000 97
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

Update 14.1 12.9 11.9 10.8 9.8  
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

Single $299


More Information

5 Seat $999

Also available as part of

Total Access Ultimate Suite

Runtime/Redistributable Version

Total Access Statistics includes a runtime library with royalty-free redistribution rights.
Use is subject to the terms of the License Agreement.

Licensing Information

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.

Reviews

"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

More Awards Reviews and References in Scientific Papers

Statistics Info

Additional Info

 

 

Free Product Catalog from FMS