Queries

When working in a database, most users will only need a certain group of records at any one time. Some may want to look at sales transactions for the previous week, while others may only need to look at a list of addresses in downtown Chicago. Whatever the reason, database programs have the ability to search for any record a user needs and manipulate the data in many different ways. These are accomplished by creating a QUERY. Once tables have been established inside of a database, a person can develop a query to select a group of fields from those tables, select only records that adhere to a specific set of criteria, and ready those records for use in a report. The following are different items in a query.

• Setting Up the Query
• Wildcard Characters and Comparison Operators
• AND and OR Criteria
• Sorting Records in a Query
• Multiple-Table Queries