Total Access Statistics

Total Access Statistics is a computer program used for statistical analysis in Microsoft Access.
Statistics Program for Microsoft Access
Total Access Statistics is a statistical analysis program designed specifically for Microsoft Access users and developers. It is a Microsoft Access add-in that runs within the Access environment. When a database is opened, Total Access Statistics is available from the add-ins menu.
Total Access Statistics performs numerical analysis on the data in the current database. The data source can be any table or select query, including multi-table queries. Data can be from any Access table, linked table from another Access database, or linked data such Microsoft SQL Server, ODBC, Excel, dBase, FoxPro, Paradox, etc. Total Access Statistics supports Access Jet Engine databases (MDB and ACCDB formats) and Access Data Projects connected directly to SQL Server.
An interactive Statistics Wizard guides the user through the selection of fields and options. Results are placed in Access tables directly in the current database. Like any Access table, they can be viewed or added to queries, forms, and reports.
The analysis settings called 'scenarios' are automatically saved for future use or modification. The Statistics Wizard displays the list of saved scenarios that can be easily selected and run against the current data.
Statistical Analysis
Total Access Statistics extends the built-in capabilities of Access queries with a wide range of statistical functions. An unlimited number of records can be analyzed at one time, and grouping fields specified, similar to a Totals query in Access. An optional weighting field may specified, along with a value or range of values to ignore.
*Field Descriptives
**Count, Missing (blanks), Mean
**Minimum, Maximum, Range, Sum, Sum of Squares
**Variance, Coefficient of Variance, Std. Deviation, Std. Error
**Geometric Mean, Harmonic Mean, Root Mean Square
**Skewness, Kurtosis
**Mode, Mode Count
**t-Test versus Mean (test for null hypothesis)
**Confidence Intervals (t and Normal tests). 95% and user-specified levels
**t-Test vs. Mean
*Percentiles: Median, Quartiles, Quintiles, Deciles, Octiles, 5th percentile, Percentile, 0.5 Percentile
*Frequency Distributions
*Field Comparison
**Mean difference, Standard Deviation of difference
**Covariance, Correlation, R-Square
**Paired t-Test, Probability (1 or 2 tails)
*Regressions: Simple, Multiple, and Polynomial
*Cross-Tabulation and Chi-Square
*Running Totals
**Cumulative or moving totals such as average, sum, count, median, min, max, etc.
*Group Analysis
**Two Sample T-Test
**One Way Analysis of Variance (ANOVA)
**Two Way ANOVA
*Record Analysis
**Random Record Selection
**Rankings
**Data Normalization
*Non-Parametric Analysis
**One Sample Chi-Square
**One Sample Sign Test for Median, Mean, and Custom Value
**Kolmogorov-Smirnov Goodness of Fit Test
**Paired Sign Test, Spearman's Rho Correlation
**Wilcoxon Signed Rank Test for Matched Pairs
**Wald-Wolfowitz Runs Test
**Mann-Whitney U Two Sample (non-matched) Test
**Kruskal-Wallis One Way Analysis of Variance
**Friedman's Two Way Analysis of Variance
*Probability Calculator
**Evaluate probability of test values: Z, t, Chi-Square, and F
**Calculate inverse probability
Programmatic Interface
In addition to the interactive Wizard, a programmatic interface is also available for Access VBA programmers to include Total Access Statistics calculations in their applications. Through the programmatic interface, any saved scenarios can be executed through a simple procedure call. This can be tied to an event or another process without showing the user interface to the end-user. A royalty-free runtime distribution license is included to distribute the Total Access Statistics library to non-owners.
Current Versions
Total Access Statistics has a separate version for each version of Access. Each version can support all database formats supported by its version of Access.
* Version 12.0 for Microsoft Access 2007
* Version 11.7 for Microsoft Access 2003
* Version 10.7 for Microsoft Access 2002
* Version 9.7 for Microsoft Access 2000
* Version 8.5 for Microsoft Access 97
Release History
The current version, 12.0, is the ninth major release of Total Access Statistics:
* Version 1.0 was released in 1995 for Microsoft Access 2.0.
* Version 2.0 and 7.0 were released in 1996 for Access 2.0 and Access 95 (version 7).
* Version 8.0 was released in 1997 for Access 97.
* Version 9.0 was released in 2000 for Access 2000.
* Version 10.0 was released in 2001 for Access 2002
* Version 11.0 was released in 2004 for Access 2003.
** Versions 8.5, 9.5, and 10.5 were also released in 2004 to update Access 97, 2000, and 2002.
* Version 12.0 was released in 2007 for Access 2007 .
** Versions 9.7, 10.7, and 11.7 were also released in 2007 to update Access 2000, 2002, and 2003.

Main Menu

See Also

Main Menu