Total Access Statistics

Total Access Statistics Manual
Microsoft Access 2016 Version
is Shipping!

New 14.1 Version for
MS Access 2010!

New X.9 Versions for
Access 2007 and 2003!

Versions X.8 for
Access 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

Awards, Reviews, References, and Testimonials of Total Access Statistics

From the world leader in Access productivity tools, Total Access Statistics is our award-winning statistical analysis program designed exclusively for Microsoft Access users and developers.

1998 Readers' Choice Gold Award
Best Business Product
1996 Readers' Choice Award
Best Access-Based
Business Product

"Total Access Statistics...performs a wide range of data analysis right inside Access. The product includes a Statistics Wizard to perform parametric, group, and non-parametric analysis and more. The results are placed in Access tables that you can integrate into your forms and reports."
Alison Balter, Author of Mastering Access Desktop Development (excerpt)

"If you need to run statistical analysis on your databases (and these days, a lot of people do), you no longer have to worry about getting your data into Excel first, or writing lots of complex code-based reports. Total Access Statistics does a good job of making the most of your data. Couple that with a royalty free runtime distribution license and you have a tool worth buying."
Craig M. Bobchin, Access/VB/SQL Advisor

"With an intuitive, easy-to-use Wizard interface and VBA interface, Total Access Statistics makes it easy for users or programmers to perform statistical analysis. It generates the analysis you need with output in a useful format: tables. If you need to perform advanced numerical analysis, consider Total Access Statistics."
Pam Hazelrigg, Access Advisor Product Review

References in Scientific Journals

Total Access Statistics is often used in scientific research. Here are a few published articles that are available online and reference Total Access Statistics:

  • Agilent Technologies
    Hybridization of In-Situ Synthesized DNA Microarrays Using a Multiple Microarray Format
  • Blackwell Synergy Transfusion
    Pharmacokinetic study of FFP photochemically treated with amotosalen (S-59) and UV light compared to FFP in healthy volunteers anticoagulated with warfarin
  • International Journal of Epidemiology
    Cervical cancer mortality in Australia: contrasting risk by Aboriginality, age and rurality
  • Neoplasia
    ONCOMINE: A Cancer Microarray Database and Integrated Data-Mining Platform
  • Proceedings of the National Academy of Sciences
    Large-scale meta-analysis of cancer microarray data identifies common transcriptional profiles of neoplastic transformation and progression
  • Science Direct
    Developing biological indicators from diverse data: The Potomac Basin-wide Index of Benthic Integrity (B-IBI)

Additional Testimonials

"The most incredible software find I have made in 10 years!"
R. Slimmon, Nesteggs, Inc.

"FMS’ Total Access Statistics has been invaluable in my analysis of stream biological monitoring data contained in a custom Access database. Statistical methods are commonly used in the field of water quality monitoring to relate changes in the biological community to measures of human disturbance or ecological condition. For similar projects, I previously used Excel or software packages like SAS and JMP for statistical analyses. But after hearing good things about FMS’ products through various Access newsgroups, I decided to download the Total Access Statistics demo and give it a try. I could see its capabilities at once. Instead of having to export data from my Access database to “external” statistical applications, Total Access Statistics enabled me to easily calculate descriptive statistics and run more sophisticated analyses from within the Access environment. Total Access Statistics’ statistical scenarios combined with Access’ ability to select and group data on certain criteria – e.g. by ecoregion, watershed, stream size, etc. - made it possible to use Access as an analytical tool as well as a data management application. For example, I could query tables for specific groups of records, create a Total Access Statistics scenario to calculate certain statistics for each group, and then use fields in the output table to set criteria in additional queries – e.g. “WHERE CoeffOfVariation<=0.50” etc. And because I was already accustomed to working with Access, there was virtually no learning curve. I was able to begin using Total Access Statistics almost immediately. I convinced my supervisors to order the product and now use it almost every day."
LeAnne Astin, Aquatic Ecologist, Maryland