You can download this sample database to practice with here (140Kb).
Applying Queries in Access 2000
A "query" is a search condition you apply to your data.
For the following examples, the database below will be used:
You can download this sample database to
practice with here (140Kb).
STEP 1 Go to Create query in Design view from the Objects list.
STEP 2 Select the Table to be used from the Show Table window
The Fields List appears. (Close the Show Table window.)
STEP 3 Drag each of the Fields you want to include in your query and drop them into the top cell in each column. At this point you could use the alternate approach of selecting the fields using the Drop-down menu.
STEP 4 Click the Run button to apply your query to the data ...
Since no selection "Criteria" were defined, this query displays all records under the selected fields...
In the following case the selection criteria was set to: FirstName is "mary"
This time, only records containing the FirstName "mary" are selected.
STEP 5 Experiment with other search criteria including the use of the "or" condition. You should be able to use greater than (">") and less than ("<") criteria to extract different age groups and people from different States. eg Age < 35, Postcode > 6000, etc