Overview | Pricing & Licensing | Evals & Downloads | Compatibility | Publisher Details | Reviews | Support Forum | Summary

Summary

Total Access Statistics by FMS

URLs: fms-total-access-statistics, fms total access statistics, fmstotalaccessstatistics, fms

Easily perform a wide variety of calculations on your Access programs. Designed specifically for Access, Total Access Statistics runs as an Access add-in (from the Tools menu), and offers a wide range of statistical functions to analyze your data. Your data can be in Access tables or linked from other sources such as SQL Server. Analyze multiple fields and an unlimited number of records at one time. You can even analyze data from multi-table select queries.

Easily perform a wide variety of calculations including regressions, percentiles, frequency distributions, correlations, t-tests, confidence intervals, crosstabs, ANOVA, group analysis, non-parametrics, Chi-Square, probability, and much more. An interactive Wizard interface guides you through the process with no programming required! All results are generated in the most flexible format: Access tables. Easily display the results in your forms and reports. Your analysis settings are automatically saved so you can modify them later or run them again when your data changes.

General Features

Runs from Microsoft's Access Tools, Add-in menu

Analyze data from any Microsoft Access table or linked table

Analyze data from any select queries including multi-table select queries

Analyze an unlimited number of records and multiple fields at one time

Output results to Microsoft Access tables

Interactive Wizard interface requires no programming

Analysis selections are automatically saved as scenarios which can be run again or edited in the future

Optionally specify fields to group sets of records

Optionally weight records based on the value in a field

Optionally ignore a numeric value or range of values

All calculations in double-precision

Single user and network compatible

Programmatic interface to add statistical analysis to your applications

Royalty-free runtime license

What’s new in Total Access Statistics?

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.

Data Analysis Enhancements - 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.

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.

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

Easily perform a wide variety of calculations on your Access programs.

Pricing: Total Access Statistics - for Access 2010 1 Developer License, Total Access Statistics - for Access 2007 1 Developer License, Total Access Statistics - for Access 2007 1 Developer Upgrade License, Total Access Statistics - for Access 2007 5 Developer License, Total Access Statistics - for Access 2007 5 Developer Upgrade License, Total Access Statistics - for Access 2003 1 Developer License, Total Access Statistics - for Access 2003 1 Developer Upgrade License, Total Access Statistics - for Access 2003 5 Developer License, Total Access Statistics - for Access 2003 5 Developer Upgrade License, Total Access Statistics - for Access 2002 1 Developer License, Total Access Statistics - for Access 2002 1 Developer Upgrade License, Total Access Statistics - for Access 2002 5 Developer License, Total Access Statistics - for Access 2002 5 Developer Upgrade License, Total Access Statistics - for Access 2000 1 Developer License, Total Access Statistics - for Access 2000 1 Developer Upgrade License, Total Access Statistics - for Access 2000 5 Developer License, Total Access Statistics - for Access 2000 5 Developer Upgrade License, Annual Premium Support Subscription 1 Support License, Annual Premium Support Subscription 1 Support License Renewal, Annual Premium Support Subscription 5 Support License, Annual Premium Support Subscription 5 Support License Renewal

Evals & Downloads: Read the Total Access Statistics help file, Read the FMS License Agreement

Operating System for Deployment: Windows XP, Windows ME, Windows 2000, Windows 98, Windows NT 4.0, Windows 95

Architecture of Product: 32Bit

Product Type: Add-In

Compatible Containers: Microsoft Office 2010, Microsoft Office 2007, Microsoft Office 2003, Microsoft Office XP, Microsoft Office 2000, Microsoft Access 2010, Microsoft Access 2007, Microsoft Access 2003, Microsoft Access 2002, Microsoft Access 2000

Product Class: Business Components

Keywords: FMS

Math Stats Mathematics Mathematical Statistic Statistical

Part numbers: PC-512412-391285 512412-391285 PC-512412-126176 512412-126176 PC-512412-274947 512412-274947 PC-512412-274942 512412-274942 PC-512412-274952 512412-274952 PC-512412-126175 512412-126175 PC-512412-274948 512412-274948 PC-512412-274943 512412-274943 PC-512412-274953 512412-274953 PC-512412-126173 512412-126173 PC-512412-274949 512412-274949 PC-512412-274944 512412-274944 PC-512412-274954 512412-274954 PC-512412-126174 512412-126174 PC-512412-274950 512412-274950 PC-512412-274945 512412-274945 PC-512412-274955 512412-274955 PC-512412-226999 512412-226999 PC-512412-227020 512412-227020 PC-512412-227041 512412-227041 PC-512412-227062 512412-227062

Mfr. Part No: TAST105 TAST11 TAST95