Microsoft Access Queries – How Many Types Do You Know And Use In Your Access Database?

Microsoft Access Queries – How Many Types Do You Know And Use In Your Access Database?

You use Microsoft Access queries to view, change, and analyse data in different ways. You can also use them as a source of records for your forms, reports, and other output views.

So, how many do you know? How many have actually used?

microsoft access queries - types

Get Microsoft Access queries to ask questions of your database. The more you ask the more answers you get!

To me, it’s the heart of any database application and without them there’s no life so take the time to master you queries and become the master of an Access database

Microsoft Access Queries – How Many Types Do You Know And Use In Your Access Database?

I could list at least a dozen; actually, here are 15 different types that may typically be combined to churn out the more sophisticated result set (which is an extract from one of my eBooks; A Guide to More Access Database Queries – Releasing the Power of Access)…

Different Types of Access Queries

I have listed the following different type of queries that will make it easier to follow their beneficial use and how to design them and therefore they have been separately shown in this document:

  1. Calculated Queries
  2. Group & Totals Queries (Summary Queries)
  3. Join Queries (Table Relationships)
  4. Query Wizards – Simple, Crosstab, Find Duplicates and Find Unmatched
  5. Parameter Queries
  6. Top-Value Queries
  7. Make-Table Queries
  8. Append Queries
  9. Update Queries
  10. Delete Queries
  11. Distinct Queries
  12. Auto-Lookup Queries
  13. Union Queries
  14. Pass-Through Queries
  15. Data-Definition Queries

In the ‘real world’, you tend to mix the above types together to provide more power when reporting in an Access database and in some cases, nest queries too (which is another type of query).

You may also want to be clear that the last three listed above cannot be created using the standard QBE (query by example) grid but forced to work via the SQL view interface where users need to know and use the SQL language.

Be careful there are some ACTION queries which are potential dangerous – do you know which one? Post your responses in the comments below.

This entry was posted in MS Access, Queries and tagged , , , , . Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

Confirm you are human.