Microsoft Access Query Design Articles and Tutorials | Database Solutions for Microsoft Access

Microsoft Access Query Design Articles, Topics and Tutorials

Here you will find articles and tutorials relating to Microsoft Access query designs, from planning what tables and fields will be used to selecting criteria to be applied. There is also information on query optimization and using calculations within the query.

Hopefully you will find something of interest, whether you need to limit results of the query by applying simple criteria to designing expressions to calculate data on the fly.

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.

Microsoft Access Queries

Topic	Date Submitted	Downloadable File
Query Basics All Versions	07/06/2002	N/A
Creating a Progress Meter Tested on Access 2000	13/07/2002	N/A
How to return all records when a parameter is left blank Tested on Access 2000	16/10/2002	N/A
Planning for Null responses in your parameter queries Tested on Access 2000	22/10/2002	N/A
Selecting birthdays in the next 30 days Tested on Access 2000	28/10/2002	N/A
Using an Append Query to set the initial value of an AutoNumber Field All versions	04/11/2002	N/A
Filtering the results of a query using a Drop-Down combo box Tested on Access 2000 and 2002	20/08/2003	[27 KB]
Optimizing Query Performance All Versions	27/08/2003	N/A
A handy tip on Concatenation Tested on Access 2000 and 2002	05/11/2003	N/A
Using a Microsoft Access Listbox to pass criteria to a query Tested on Access 2000 and 2002	16/02/2004	[28 KB]
Easily retrieve data for the Current Month or Year Tested on Access 97, 2000 and 2002	10/03/2004	N/A
Splitting a Single Field into Multiple Fields Tested on Access 97, 2000 and 2002	07/04/2004	N/A
Suppress Microsoft Access Action Query Warning Messages Tested on Access 97, 2000 and 2002 (XP)	21/04/2004	N/A
Query Day from Date All Versions	18/06/2004	N/A
Query a Date Field to Return all records within a month period All Versions	05/07/2004	N/A
Show only records from the last 'x' months All Versions	06/07/2004	N/A
Using the MAX() function in Microsoft Access Tested in Microsoft Access 2000, XP and 2003	08/09/2004	N/A
Calculating future Dates using the DateAdd function Tested in Microsoft Access 2000, XP and 2003	04/10/2004	N/A
IIF Function use in Microsoft Access Tested in Microsoft Access 2000, XP and 2003	09/10/2004	N/A
Creating a Self-Join Query to relate data within a table in Microsoft Access All versions	29/10/2004	N/A
Multiple Table Queries All versions	20/01/2005	N/A
Query Joins - Inner & Outer Joins All versions	25/01/2005	N/A
Creating Action Queries - Update, Append and Delete Queries All versions	08/03/2005	N/A
Creating an Append Query in Microsoft Access All versions	08/03/2005	N/A
Creating a Delete Query in Microsoft Access All versions	08/03/2005	N/A
Creating Crosstab Queries in Microsoft Access Microsoft Access 2000 & XP	31/03/2005	N/A
How to create a Microsoft Access Append query with criteria Microsoft Access 2000, XP & 2003	26/07/2005	N/A
Microsoft Access and Boolean Operators	05/09/2005	N/A
Microsoft Access Query Types: Select, Action, Parameter and Aggregate	07/11/2005	N/A
Aggregate Functions in SQL and Microsoft Access	24/11/2005	N/A
Using an Update Query to Convert Text to Proper Case Microsoft Access 2000, XP & 2003	16/12/2005	N/A
Creating Microsoft Access Parameter Queries	24/03/2006	N/A
Use of the Where Clause in Microsoft Access	12/05/2006	N/A
Microsoft Access Query to display Birthdays for the Current Month Microsoft Access 2000, XP & 2003	04/07/2006	N/A
Find Duplicates Query Wizard	03/08/2006	N/A
Create a New Table using a Make-Table Query Microsoft Access 2000, XP & 2003	17/08/2006	N/A
Updating Records in Microsoft Access with an Update Query Tested in Microsoft Access 2000, XP & 2003	22/08/2006	N/A
Sorting database entries beginning with 'The' Tested in Microsoft Access 2000, XP & 2003	25/10/2006	N/A
Creating Microsoft Access Queries using the Query Wizards	01/11/2006	N/A
Using a Query to display Random Records Tested in Microsoft Access 2000, XP & 2003	26/03/2007	N/A
Using the DatePart Function in a Microsoft Access Query Tested in Microsoft Access 2000, XP & 2003	15/06/2007	N/A
Creating Queries using QueryDef	12/11/2007	N/A
Comparing Records In Microsoft Access	20/12/2010	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:

Do not use user-defined functions (VBA code).
Use nested queries and sub-queries sparingly.
Introduce as many Access's built-in functions as possible.
Go outside the box and exclude run-of-the mill type of queries.
Use parameters wherever appropriate.
Cover as many types of query as possible.

Download: 111 Power Access Query/SQL Examples

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

Microsoft Access Articles

GUI Design

Resources

Online Shop

Info

Microsoft Access Query Design Articles, Topics and Tutorials

Microsoft Access Queries