Total Access Statistics

Total Access Statistics Manual
Microsoft Access 2016 Version
is Shipping!


New 14.1 Version for
MS Access 2010!

New X.8 Versions for
Access 2007, 2003, 2002, 2000, and 97!


View all FMS products for Microsoft AccessAll Our Microsoft Access Products

Statistics Info:

Why Statistics?

"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 Reviews

Additional Info:

 

 

Perform statistical analysis on Microsoft Access dataPerform statistical analysis on Microsoft Access dataNumerical Analysis for Microsoft Access data Numerical Analysis for Microsoft Access: Download the Trial Version of Total Access Statistics

Microsoft Access 2010Total Access Statistics for Microsoft Access 2010, Version 14.1 Enhancements

With the debut of Total Access Statistics for Access 2016, version 14.1 was released for Total Access Statistics for Access 2010. This is an upgrade from its original release of version 14.0 in September 2010. Version 14.1 brings parity with the latest 2016 version and includes these features from 14.0:

Supports Windows 8 and 10

The current operating systems are supported and the installation program enhanced to install differently in the Windows 8 and 10 environment versus Windows 7 and earlier.

Supports Microsoft Access 32 and 64 bit Versions

Total Access Statistics includes 32 and 64-bit versions to support either installation of Office/Access 2010. It also includes a 64-bit ACCDE runtime library that supports all database formats supported by that Access version including ACCDBs, MDBs, and ADPs in Access 2010.

Runtime Libraries Now Support MS Access 2016 and 2013

The Runtime libraries let you generate Total Access Statistics results programmatically using VBA from your application rather than the add-in. You can then distribute your Access database to other users with the Total Access Statistics functions, even if they don't own Total Access Statistics.

The VBA runtime libraries in version 14.1 support Access 2016 and 2013. The libraries are also backward compatible to support distribution to people using Access 2007 and 2003.

Additional Percentile Types Can Be Assigned to a Field in Your Table

In addition to generating a new table with percentile values or assign a percentile value to a field in your table, you can now specify calculations such as quartiles, quintiles, octiles, deciles, etc. rather than just percentile with the new "Fill with.." option:

New Percentile Type Record Assignment Option

Data Formatting Enhanced

  • Field format is set to Percent for percentage fields in the Frequency, Crosstab (when percentages are in columns), and Chi-Square details tables. Previously, they were formatted as General Number.
  • When tables are generated from the add-in, the field column widths are resized to show the entire field name and data.

Performance Improvements

Improved performance when analyzing large data sets.

Improved Financial Calculations

The Cash Flow Analysis features are enhanced to better handle edge cases of irregular and limited transactions when calculating IRR, XIRR, and related functions.

Updated User Manual and Help File

Updated user manual and help file


Comparison to Older Versions

If you are on an older version of Total Access Statistics, there were many releases over the years that added new features. Here's a list of past enhancements for your review:

For more information, visit our entire History of Total Access Statistics Releases and Updates


Download the Trial Version

A functional demo version is available for you to try Total Access Statistics on your data. Download a trial version

If you want to look at how it works without installing the program and review the calculations it generates, get the help file for more details of these and other Total Access Statistics features (included in the trial download).