Mar 22

Total Access Statistics User Manual for Microsoft Access

Statistlcal analysis for Microsoft Access with Total Access StatisticsTotal Access Statistics user manual Total Access Statistics is the most advanced and popular data analysis program for Microsoft Access. Total Access Statistics makes it easy to calculate percentiles, regressions, confidence intervals, correlations, t-tests, probabilities, ANOVA, Chi-Square, etc. You can even normalize tables, rank records, and select random records, plus much more without any programming.

To maximize your use of Total Access Statistics for analyzing the data in your Microsoft Access databases, a professionally written and printed user manual is included. The user manual is 176 pages and fully indexed to make it easy to learn about Total Access Statistics, how to use it, definitions of its calculations, its programmatic interface, and tips for optimal use.

The Total Access Statistics user manual is now available for your review. Check it out to see how Total Access Statistics extends the power of Microsoft Access queries so you can analyze your data better than ever. To see it action with your own data, download the trial version.

Jan 25

New Video: An Introduction to Social Network Analysis

Link Analysis, Social Network Analysis, Geospatial, and Timeline SoftwareThe FMS Advanced Systems Group has a new video for its Sentinel Visualizer program: An Introduction to Social Network Analysis (SNA). If you are trying to find hidden relationships among people, places, and events, Social Network Analysis can help.

Social Network Analysis is a subset of network theory that finds important relationships and centrality in complex networks. Learn how organizations in the law enforcement, intelligence, defense, finance, and other data intensive fields are using Sentinel Visualizer in their missions.

Here's more information on Sentinel Visualizer and its Link Analysis features.

Dec 12

Microsoft Access/SQL Server Query Tip: Finding Records in One Table but Not Another with “Not In” Queries

Here's another resource in our ongoing coverage of query techniques:

Learn how to create queries to find all the records in one table that don't have corresponding records in another table. If you're not familiar with the difference between INNER JOIN, OUTER JOIN, LEFT JOIN and RIGHT JOIN, check out this new paper on these important query feature. It'll save you tons of time trying to code this yourself and will surely give you new ideas on how to better retrieve and analyze your data. The techniques apply to both Microsoft Access and SQL Server queries.

Dec 04

Microsoft Access Delete Query SQL Syntax

Delete Query in Microsoft Access Could not delete from the specified tables.JPG

Here's an additional paper related to our ongoing coverage of queries. This time we're covering DELETE query syntax in Microsoft Access. In addition to the basics of deleting data and the SQL for DELETE queries, we also cover an interesting situation when DELETE queries fail during multi-table links on non-keyed fields.

If your query fails to delete any records with this message: "Could not delete from the specified tables", learn why and how to fix it with the DISTINCTROW syntax or setting the Unique Records property to Yes.

For more information on queries in general, read our paper on Microsoft Access Query Tips and Techniques.


Oct 23

Update Query and SQL Syntax in Microsoft Access

Related to our detailed paper on Query Tips and Techniques, we added extra information on the basics and syntax of an Update Query in Microsoft Access.

We also have a related article on dealing with non-updatable queries: Error 3073: Operation must use an updatable query: Dealing with Non-Updateable Queries and the Use of Temporary Tables in Microsoft Access