Access supports many different types of queries, grouped into six basic categories:

• Select: These are the most common types of queries. As its name implies, the select query selects information from one or more tables, creating a recordset. Generally speaking, the data returned by a select query is updatable and is often used to populate forms and reports.
• Total: These are special type of select queries. Total queries provide sums or other calculations (such as count) from the records returned by a select query. Selecting this type of query adds a Total row in the QBE (Query by Example) grid.
• Action: These queries enable you to create new tables (Make Tables) or change data (delete, update, and append) in existing tables. Action queries affect many records as a single operation.
• Crosstab: These queries can display summary data in cross-tabular form like a spreadsheet, with row and column headings based on fields in the table. The individual cells of the recordset are computed or calculated from data in the underlying tables.
• SQL: There are three SQL (Structured Query Language) query types—Union, Pass-Through, and Data Definition. These queries are used for advanced database manipulation, such as working with client/server SQL databases like SQL Server or Oracle. You create these queries by writing specific SQL statements.
• Top(n): Top(n) queries enable you to specify a number or percentage of records you want returned from any type (select, total, and so on) of query.

• Save Time, Money and Space in Over 80 Ways If you're looking for handy gadgets, tools and various items that can save you time, money or space (or all...
• How to Do Table Repairs There are many different ways that a table can get damaged, and when it is something so little it can...
• Import Prosper.com Listing, Loan, Group, Member Data into Microsoft Sql Server 2000 Prosper.com makes all publicly available data accessible via a data export.  They also provide tools for importing that data into...
• 10 Websites to Compare Google vs Bing Results Side By Side 10 Websites to Compare Google vs Bing Results Side By Side Thankfully, the web doesn’t make us take sides. We...
• Beginning the Art of Collecting Wine The purpose of this article is simply to provide you with some tips for the art of collecting wine. If...