Here you will find articles relating to SQL (Structured Query Language) and SQL use and implementation in Microsoft Access. You will find articles and topics relating to SQL query designs, from planning what tables and fields will be used to selecting criteria to be used in the SQL Statements. There are articles on SQL basics, SQL Select, Insert, Update and Delete Statements and topics on why use SQL.
Hopefully you will find something of interest, whether you need to create simple SQL Select Queries, to inserting and updating information using the SQL language in Microsoft Access.
Query Tree Editor for Microsoft Access
An indispensable MS Access add-in for developers who use queries as the core of their applications. Create queries using SQL templates, edit your SQL queries in a superior query editor. Keep track of the dependency relations between queries. Free trial.
Builder for Microsoft Access
Need to see key data from your Access database in a single dashboard? Tired of creating query after query to really understand your Access data? Dashboard Builder for Microsoft Access is an easy to use tool to create powerful dashboards in minutes…without being a SQL wizard. Free trial available
SQL & Microsoft Access Database Recovery. Disaster recovery for inaccessible and/or lost database files
|Topic||Date Submitted||Downloadable File|
|What is SQL?||10/05/2005||N/A|
|The Basics of SQL - Structured Query Language||10/05/2005||N/A|
|The SQL Select Statement||17/06/2005||N/A|
|Why Use SQL?||18/07/2005||N/A|
|Aggregate Functions of SQL For Beginners||25/08/2005||N/A|
|Data Manipulation Language Commands - INSERTing Data using SQL||30/08/2005||N/A|
|Data Manipulation Language Commands - DELETE and UPDATE Data using SQL||01/09/2005||N/A|
|Creating Union Queries||29/11/2005||N/A|
|Eliminating Duplicates with SQL SELECT DISTINCT||10/01/2006||N/A|
|Using the WHERE clause with the SQL SELECT Statement||26/01/2006||N/A|
|Multiple Conditions using the SQL AND and OR conditions||02/02/2006||N/A|
|Using SQL in Access: Changes in Data Groups||08/02/2006||N/A|
|Logical Operators in Access SQL||13/02/2006||N/A|
|The DELETE Operand in SQL for MS ACCESS||10/04/2006||N/A|
|SQL GROUP BY Clause||25/04/2006||N/A|
|SQL IN/BETWEEN Condition||30/04/2006||N/A|
|Using the WHERE clause in SQL||01/05/2006||N/A|
|SQL Count Function||24/05/2006||N/A|
|SQL Queries in Microsoft Access||02/08/2006||N/A|
|SQL - Using GROUP BY with HAVING||12/12/2006||N/A|
|Using String Functions in your Access SQL Queries||06/08/2007||N/A|
|Conditional Concatenation with the iif() function||17/11/2009||N/A|
Are you mining all the nuggets out of your goldmine? Are you asking your database questions tough enough to extract all the pertinent information for your business? Do you want to push the envelope and create some esoteric yet powerful queries? Here are 70+ challenging query examples all employing advanced techniques based mostly on the tables in the Northwind database which comes with Microsoft Access.
Built-in Access functions, query parameters, derived tables, self-joins, unequal joins, cross joins and correlated subqueries can make synergistic combinations, enabling you to build compact, powerful, and reusable queries.
Take your query building skills to the next level and impress your boss and/or colleagues. You will also find the query examples suitable to use as teaching material for an advanced Access class. Profit from these expert query techniques now. This product requires Microsoft Access 2000 or higher.
Guidelines followed in constructing the query examples: