|
Action
Queries
|
|
OBJECTIVES |
|
-
To become familiar with the four different types of
action queries including:
1. Delete Query
2. Append Query
3. Update Query
4. Make Table Query
- To become familiar with implementing
action queries
|
|
| Objective
# 1 |
Review:
Action Query types and uses |
|
|
|
Delete
Query: Used
to remove one more records from data tables
|
nAppend
Query: Used
to connect tables by adding information from one
table to the end of another
|
| Update
Query: Used
to update multiple amounts of information in
the specified table with one command
|
| Make Table
Query: Used to make new tables
from information stored in previous tables
|
|
| Objective
# 2 |
Creating
the Query |
 |
|
|
| Before
you can begin working you must make your new query |
| To do this,
press the "Queries" button,
located within the "Objects" tab
of the database menu box
|
|
Once the "Queries" button is
depressed, a new screen will appear giving you the
option to "Create Query in Design View"
|
| Double click
"Create Query in Design View" |
|
|
| Objective
# 3 |
Selecting
the Table you will work with |
 |
|
After you have clicked the "Create Query
in Design View" button, you will be
taken to the screen seen to the left
|
| In this screen, you will see a list
of possible Tables you can work within the
'Show Table' box. |
|
Click the table you wish to work with, then
click the "Add" button located
at the upper right corner of the 'Show Table'
box.
|
|
| |
|
|
| Objective
# 4 |
Selecting
the fields of Data you will be working with |
 |
Once you have added the table you will
be working with, you will need to select what fields
of data within that table you will be
working with.
|
| In the new "Query
1" screen you will see, you will notice a
grid toward the middle of that box |
| To
the top left of row 1 of the grid, you will see
the "Field" label. |
| Click the box to the
right of the "Field" label, and
select what field of data from your table you will
work with. Move to Column 2 and do
the same for multiple amounts of data
In the example to the left you will notice that
I am working with the "GDP" field
of data |
|
| Objective
# 5 |
Selecting
the Action Query you will work with, and adding
additional needed information |
  |
| Once you have
selected what "Fields" from your
table you will be working with, you will need to
select which Query you will be running |
| Depress the "Query"
button located within the top toolbar at the top
of the screen, and scroll your mouse down until
you have highlighted the Query you will be
working with
Depending on which Query you select, new Headings
will appear the the left of each row, including a
"Criteria" heading.
Fill in these new areas as needed
Example:
To the left, I have chosen to run an Update
Query, the new headings available include
"criteria" and "update to"
for which I have entered >"2"
and "High Growth"
respectively. This means that when I run the
query, all entries in the given field that have a
value > 2, will be updated to say "High
Growth" rather than the number that was there
before. |
|
| Objective
# 5 |
Running
the Action Query |
 |
nOnce
you have filled in all required fields,
the only step left is to Run you Action
Query
|
nTo
Run your action query, press the "Run
Query" button which appears as a maroon
exclamation point within the top toolbar
of your screen
|
| After you have
pressed the "Run Query" button, a
screen will appear informing you that you are
about to update "X amount of rows" |
nIf
you are certain that you entered in the
correct information, click the "Yes"
button to continue
|
| View your new
updated table |
|
|
|
Lesson Review |
You learned how
to....
- 1. Distinguish between the various types of action
queries including:
-
Delete
- Append
- Make Table
- Update
- 2. Run all types of Action
Queries
|
|
back to lesson #4
|
Exercise
#1  |
|
Back to
Lessons |
: Chapter 3, Lesson 5