Understanding Access Query Types


10 Minute Guide to Microsoft Access 2002
By Joe Habraken
Table of Contents
Lesson 17.  Creating a Simple Query

Understanding Access Query Types

Before this lesson ends, you should spend a little time learning about the different types of queries that Access offers. In this lesson, you created a select query that "selects" data from a table or tables based on your query criteria. You can also build other types of queries. The different query types are

  • Make Table Query ?A NAME ="d1e22880">This type of query is similar to a select query, but it takes the data pulled together by the criteria and creates a new table for the database.

  • Update Query ?A NAME="d1e22905">This query updates field information in a record. For example, you might have placed a certain credit limit for customers and want to update it in all the records. You would use an Update query.

  • Append Query ?A NAME="d1e22937">This type of query is used to copy records from one table and place them (append them) into another table. For example, you might want to append employee records from an Active Employee table to a Former Employee table.

  • Delete Query ?A NAME="d1e22969">This type of query is used to delete records from a table. For example, you might want to delete old records from a table based on particular criteria.

Now, you might be thinking that all these query types are a little too much to handle. However, you create different query types just as you would a select query.

As a matter of fact, you actually design each of these different query types as a select table (using a wizard, Query Design view, or a combination of both), and then you change the query type in the Query Design view. It's just a matter of selecting the query type from the Query menu.

In this lesson, you learned how to create a simple query and how to save, edit, and print query results. You also learned about the different query wizards and the different types of queries. In the next lesson you work in the Query Design view.


10 Minute Guide to Microsoft Access 2002
10 Minute Guide to Microsoft Access 2002
ISBN: 0789726319
EAN: 2147483647
Year: 2000
Pages: 160
Authors: Joe Habraken

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net