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.

• 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...
• LAMP + SVN in Ubuntu Quick Ubuntu Server installation for LAMP + SVN First we need a clean installation of Ubuntu Server (works with Debian...
• phpMyDB - Data base class for MySql phpMyDB is not only a class handler for MySql written in PHP, it's also has a query cache built in,...
• The New Technology: Hardware Assisted Virtualization | Intel VT & Microsoft Hyper-V @ work We all know, and some of us even used virtualization software such as VMWare Workstation, VMWare GSX Server, Microsoft Virtual...
• Cache Class for PHP Just another php cache class that you can find in Internet.. The difference? super easy to use ;) Usage: Initialize:...