Microsoft Access Queries are among the most powerful features of MS Access. We have created a new resource center to make it easy to review all our papers related to Microsoft Access Queries. These original works offer tips and techniques aren’t found anywhere else. They will help you maximize your use of Microsoft Access queries to better analyze and understand your data.

In the Microsoft Access Query Help Center you will find papers covering:

Retrieving Records

• Microsoft Access Query Tips and Techniques (SQL and VBA)
• Microsoft Access and SQL Server Database Normalization Tips
• Using a Microsoft Access Crosstab Query to Create Monthly SUmmery Reports without Code and modifing data
• Difference Between “Unique Values” (SELECT DISTINCT) and “Unique Records” (SELECT DISTINTROW) in Microsoft Access Queries
• Finding Records in One Table but Not Another with “Not In” Queries

Modifying Data

• Microsoft Access Update Query, SQL Syntax, Examples and Errors
• Microsoft Access Delete Query, SQL Syntax, Examples and Errors
• This Recordset is not updateable: Dealing with Non-Updateable Microsoft Access Queries
• Suppress Warning Messages When Running Microsoft Access Action Queries Programmatically in VBA
• Returning the Number of Records or Rows Affected by an Action Query in Microsoft Access with VB6/VBA

Let us know what additional related topics you’d like us to add in the future.