Making Queries


MAKING QUERIES WITH SIR!



1. Firstly I opened a table, from which I had to conduct my queries.

2. Then I clicked on the QUERY ICON in order to obviously conduct my query.

3. Then I doubled clicked on the supplier option and closed this bar.

4. Then I clicked the company name, the country and their phone number. In addition to this in the criteria field I typed in USA , as this is the specific country I was looking for.


5. After this I clicked run in order to attain the results I was looking for.

6. Sucessfully these are the results I found !


MAKING SOME OTHER QUERIES

1. This is the next query I made, notice  the wild card button inserted depicting that I want to know products that start with the letter M . Heres the query I made:



2. Here is the reuslt of this query:

3. Another Query!

4. So whats the result ?

5. Another query!


6. Trying something different!

7. Heres my query criteria and I was  looking for a unit price that is less than 10.


8. Here is the result!