Product Reviews

Total Access Statistics

Crunch numbers like a statistics expert.

Another useful Access add-in from the folks at FMS. This one is focused on helping you perform statistical analyses of data stored in Microsoft Access databases (it doesn't work in Access projects, but since it can analyze linked tables from an Access database, that's not a significant limitation). As with other FMS products, TA Statistics simple to use. A wizard walks you through the steps of choosing an analysis type, selecting a table or query to analyze, and specifying an output table. You then tell TA statistics to run the scenario and off it goes to look at your data.

The results come back as an Access table containing the information you've requested. The product supports almost 20 different statistical analyses, from simple things like percentiles and data description to more advanced techniques such as ANOVA and Chi-square correlations. A nice touch is that the details of each scenario are automatically saved, making it easy to calculate new results when data is added or changed.

For the developer, there's a progammatic interface that lets you call the statistical engine directly, with or without showing the user interface. The price includes a runtime license so that you can add statistics functionality to your own applications.

If you're doing any sort of scientific or engineering number-crunching and your data is available to Access (either as native Jet data or as linked tables), TA Statistics can save you a bunch of work.

About the Author

Mike Gunderloy, MCSE, MCSD, MCDBA, is a former MCP columnist and the author of numerous development books.

Featured

  • Performing a Storage Refresh on Windows Server 2016, Part 1

    To spruce up some aging lab hardware, Brien decided to make the jump to all-flash storage. Here's a walk-through of the first half of the process.

  • Vendors Issue Patches for Linux Container Runtime Flaw Enabling Host Attacks

    This week, the National Institute of Standards and Technology (NIST) described a high-risk security vulnerability (CVE-2019-5736) for organizations using containers that could lead to compromised host systems.

  • Windows 10 Version 1809 Users May Get Visual Studio Crashes

    Microsoft on Friday issued an advisory for Windows 10 version 1809 users about possible Visual Studio crashes.

  • Standardizing the Look of Outlook's Outbound Messages

    Microsoft typically gives users a blank canvas to compose new e-mails in Outlook. In some corporate environments, however, a blank canvas isn't a good thing.

comments powered by Disqus

Office 365 Watch

Sign up for our newsletter.

Terms and Privacy Policy consent

I agree to this site's Privacy Policy.