Total Access Statistics - Summary
by FMS - Product Type: Add-In
Summary
Total Access Statistics by 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.
PartNumbers: PC-512412-126176 512412-126176 PC-512412-126175 512412-126175 PC-512412-126173 512412-126173 PC-512412-126174 512412-126174
Publisher PartNumbers: TAST105 TAST11 TAST95
PurchaseOptions: Total Access Statistics - for Access 2007 1 Developer License , Total Access Statistics - for Access 2003 1 Developer License , Total Access Statistics - for Access 2002 1 Developer License , Total Access Statistics - for Access 2000 1 Developer License
Resources: Read the Total Access Statistics help file, Download the Total Access Statistics evaluation on to your computer - Limited Functionality
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 2007, Microsoft Office 2003, Microsoft Office XP, Microsoft Office 2000, Microsoft Access 2003, Microsoft Access 2002, Microsoft Access 2000
Product Class: Business Components
Keywords: Math Stats Mathematics Mathematical Statistic Statistical FMS Author
Quick Links
