Chapter 10 - Using Action Queries

3 4

Select queries (discussed in Chapter 9, "Using Queries to Select Data") retrieve data from tables, possibly filtering the data using expressions to evaluate data in some fields. But when your task is to modify data, you need an action query. In this chapter, you’ll learn how to design queries to change the data in a table, including editing records, adding new records, deleting existing records, or creating a brand-new table filled with data.

There are four types of action queries, as follows:

Update query. Replaces existing data.

Append query. Adds new records to an existing table.

Delete query. Removes records from an existing table.

Make-table query. Creates a new table.

The query icon in the Database window identifies the query type.



Microsoft Access Version 2002 Inside Out
Microsoft Access Version 2002 Inside Out (Inside Out (Microsoft))
ISBN: 0735612838
EAN: 2147483647
Year: 2005
Pages: 172
Authors: Helen Feddema

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