databasedev.co.uk - database solutions and downloads for microsoft access

Microsoft Access SQL and SQL Query Design Articles and Topics

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.

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

Dashboard 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

Database Recovery
SQL & Microsoft Access Database Recovery. Disaster recovery for inaccessible and/or lost database files

Microsoft Access SQL and Queries

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 Subqueries 02/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
SQL Recovery Tool: Testing Its Functionality 07/07/2015 N/A

111 Power Access Queries/SQL Examples

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:

  1. Do not use user-defined functions (VBA code).
  2. Use nested queries and sub-queries sparingly.
  3. Introduce as many Access's built-in functions as possible.
  4. Go outside the box and exclude run-of-the mill type of queries.
  5. Use parameters wherever appropriate.
  6. Cover as many types of query as possible.
Download: 111 Power Access Query/SQL Examples