Change Criteria for Queries

1
ACCESS HOW TO...
Change Criteria for Queries
2
Once again, when you get to the point where you
are going to select the items that are going to
be involved in your query, the window will look
basically like this
Double click on each item you want in your
querythis will place the item at the top of each
column.
To actually use your query, you CLICK on the RUN
button in the toolbar BUT, what if theres other
information or criteria that needs to be set for
the manipulation of your data???
3
In the design view of your query, look down the
column along the left-hand side.
It actually has the word CRITERIA printed there.
That row under each of your field headings is the
place where you can enter specific criteria to
each individual field.
EXAMPLE If you were ask to provide a list of the
Clients with balances greater than 25, HOW would
you do it????
4
First you would type in the criteria parameter
for the balances 253
With this entered in the Criteria row under the
Balance field, Click the RUN button on the
toolbar.
5
This is the final sheet that ACCESS showsnotice
that the balance amounts are all greater than 253.
This is what the original Client table looked
like only 7 of the 10 had balances greater than
253.
6
REFERENCES
Joyce, Jerry Marianne Moon. 2004. Microsoft
Office System 2003 Edition, Plain Simple.
Microsoft Press. Redmond, Washington.
Shelly, Cashman Vermaat. 2006. Microsoft Office
2003, Introductory Concepts Techniques. Thomson
Course Technology. Boston, MA.
7
Thanks for viewing this Tutorial. Any questions,
comments or complaints can be registered at the
next class meeting, via email or drop by my
office.
Email rstrube_at_mail.accd.edu