Queries are flexible. They provide the capability of looking at your data in virtually any way you can imagine. Most database systems are continually evolving and changing over time. Very often, the original purpose of a database is very different from its current use.

Here is a sampling of what you can do with Access queries:

• Choose tables: Obtain information from a single table or from many tables that are related by some common data. Suppose you’re interested in seeing the customer name along with the items purchased by each type of customer. When using several tables, Access returns the data as a combined single datasheet.
• Choose fields: Specify which fields from each table you want to see in the recordset. For example, you can select the customer name, zip code, sales date, and invoice number from tblContacts and tblSales.
• Choose records: Select records based on selection criteria. For example, you may want to see records for only sellers in tblContacts.
• Sort records: You may want to sort records in a specific order. For example, you may need to see customers sorted by last name and first name.
• Perform calculations: Use queries to perform calculations on data. Perform calculations such as averaging, totaling, or counting fields and records.
• Create tables: Create a new table based on data returned by a query.
• Base forms and reports on queries: The recordset you create from a query may have just the right fields and data needed for a report or form. Basing a form or report on a query means that every time you print the report or open the form, you will see the most current information in the tables.
• Create graphs based on queries: Create graphs from data returned by a query.
• Use a query as a source of data for other queries (subquery): Create additional queries based on records returned by another query. This is very useful for performing ad hoc queries, where you may repeatedly make small changes to the criteria. In this case, the second query is used to change the criteria while the first query and its data remain intact.
• Make changes to tables: Access queries can obtain information from a wide range of sources. You can retrieve data stored in dBASE, Paradox, Btrieve, and Microsoft SQL Server databases, as well as Excel spreadsheets, text files, and other data sources.

• Baby Boomer and Genealogy Records I've been interested in family history and genealogy for about ten years. With some gaps in between, I've been reviewing...
• 45 Records Collectables -> Radio, Phonograph, TV, Phone -> Phonographs, Accessories Many of us remember, and many of us still own, 45...
• Is Pay Per Click The Right Choice For You? Most people suppose that the Web is barely nice for big businesses all over the world. In any case, if...
• The Steps To Creating An Online Business There are many completely different ways in which you can work at creating online trade Net pc marketing. If you...
• Google Sitemaps :: Are They Or Aren't They Lucrative SEO Tools? Google has had a feature out for some time which allows webmasters to create a sitemap file to help Google's...