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

Sep 04

Use Link Analysis to Visualize Your Data

Link AnalysisWe are all used to seeing the 'rows and columns' metaphor when looking at data. In fact it is the primary interface for many of our data analysis tasks.

But rows and columns can hide valuable patterns. What happens when you take data out of a database and visualize it as a network? Now you can see important connections, centrality, trends, movement over time, and many other key indicators.

Check out our article on Link Analysis and Social Network Analysis to see how our Sentinel Visualizer solution provides innovative ways to get more meaning from your data.