You use Microsoft Access query 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?
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:
- Calculated Queries
- Group & Totals Queries (Summary Queries)
- Join Queries (Table Relationships)
- Query Wizards – Simple, Crosstab, Find Duplicates and Find Unmatched
- Parameter Queries
- Top-Value Queries
- Make-Table Queries
- Append Queries
- Update Queries
- Delete Queries
- Distinct Queries
- Auto-Lookup Queries
- Union Queries
- Pass-Through Queries
- 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.