Total Access Statistics 2003 and Version X.5 Enhancements

This is no longer the latest version of Total Access Statistics 2003, 2002, 2000 and 97.
Existing X.5 customers can upgrade for a nominal fee. For more information
on the new features, visit Version X.9 for Total Access Statistics 2003
and Version X.8 for Total Access Statistics 2002, 2000 and 97.

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.

With the release of Total Access Statistics for Microsoft Access 2003 (version 11), we added many new features. We also enhanced Total Access Statistics versions for:

  • Access 2002, version 10.5
  • Access 2000, version 9.5
  • Access 97, version 8.5

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.

Version X.5 Features and Enhancements

  • Support for multi-selection of fields during field assignments.
  • Code Generator that automatically creates code for running a scenario.
  • Deletion of Total Access Statistics temporary tables when exiting, if the current database doesn't contain saved scenarios.
  • New user manual and online help file.
  • Option to use Crosstab queries as data sources (previously only supported Select queries).

New Record Analysis Category

Three new analysis types are available:

When analyzing data, you may need to create a subset of records for further analysis or testing. The Random feature generates or flags a subset of your records based on the options you select such as every nth record, a specific number of records, a % of records, or a random % of records across your entire table or for each group.

The Ranking feature assigns a numeric rank to each record while handling for ties with options for how numbers after ties should be calculated (cumulative or consecutive).

Having normalized data is a fundamental part of relational databases. The Normalize feature allows you to quickly convert non-normalized data into a new table with data in multiple fields normalized into one label field and one data field.

Enhanced Describe Analysis

New percentile options calculates Quintiles, Octiles, and every 5th percentile in addition to the original median, quartile, decile, and percentile values.

Enhanced Percentile Analysis

New options for calculating Quintiles, Octiles, every 5th percentile, every X.5 percentile, plus an option to update each record in your data source with its percentile value.

Here's additional information on Calculating Percentiles in Microsoft Access

Enhanced Crosstab Analysis

A new option to show percentage results in fields rather than rows.

  • A new code generator creates the code you need to add statistical analysis and probability calculations directly into your applications.
  • New optional parameters allow you to override the scenario's data source and output table names when running scenarios programmatically.
  • New optional parameter allows you to specify the text or use the scenario description in the title bar of the progress form as scenarios are run.

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.


"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