Lesson 6.2. Understanding the Different Types of Queries Figure 6-3. Each type of query has its own icon so that you can identify it. Table 6-2 describes the different queries. Up until now, when you thought of a query, you were actually probably thinking of a select query a particular type of query. Select queries are by far the most common and useful type of query in Access; however, there are other types of queries that are also important. We will cover most of these query types in this chapter, so here's a quick overview of the different types of queries you'll find in Microsoft Access. Each type of query has its own icon, as shown in Figure 6-3. Table 6-2 describes the different types of queries. Table 6-2. Types of QueriesQuery Type | Description |
|---|
| The most basic and common type of query, select queries find and display the data you want from one or more tables or queries. |
| Prompts the user for specific information every time the query is run. | | Summarizes data in a table format that makes it easy to read and compare information. | While select queries display information that matches your criteria, the following action queries do something to the data that matches your criteriasuch as change or delete it. |
| Creates a new table from all or part of the data in one or more tables. Useful for backing up and exporting information. | Append Query | Appends or adds selected records from one table to another table. Useful for importing information into a table. | Delete Query | Deletes selected records from one or more tables. | Update Query | Updates selected information in a table. For example, you could raise the prices on all trips to Europe by 15 percent. | Union Query | Combines fields from two or more tables or queries into one field and is written directly in SQL. |
|