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.
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.
We 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.