Programs: Microsoft Access:  Chapter 3, Lesson 5


Lesson 5

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  
l
Objective # 2 Creating the Query
n 
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
n
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 


Programs: Microsoft Access: Lesson # 5