databasedev.co.uk - database solutions and downloads 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:

  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