Finding, Filtering, Sorting  «Prev  Next»

Complex Access Criteria

The correct matching pairs:
  1. Find your one client in Casa Grande: Use the Find and Replace dialog box.
  2. Find the earliest start date in the Projects table: Sort the table in ascending order
  3. Find projects for Lizard Web, Inc.: Use Filter by Selection
  4. Find projects for Network Consultants that are not complete: Use Filter by Form
  5. Find projects due in 2000 that have a start date in 1999: Use Advanced Filter/Sort
Queries draw various data sources together and present the combined information in useful views. They enable you to synthesize the raw data in your Access tables into meaningful analysis.
Queries are an essential part of any database application and are the tools that enable you and your users to extract data from multiple tables, combine it in useful ways, and present it to the user as a datasheet, on a form, or as a printed report.
"Queries convert data to information." To a certain extent, this statement is true. The data contained within tables is not particularly useful because, for the most part, the data in tables appears in no particular order. Also, in a properly normalized database, important information is spread out among a number of different tables. Queries are what draw these various data sources together and present the combined information in such a way that users can actually work with the data.

The word query comes from the Latin word quaerere, which means "to ask or inquire." Over the years, the word query has become synonymous with quiz, challenge, inquire, or question. An Access query is a question that you ask about the information stored in Access tables. You build queries with the Access query tools. Your query can be a simple question about data in a single table, or it can be a more complex question about information stored in several tables. For example, you might ask your database to show you only trucks that were sold in the year 2013. After you submit the question in the form of a query, Access returns only the information you requested.