Query 1 The unit was ml After my

  • Slides: 6
Download presentation
Query 1 The unit was ml. After my query I was left with 19

Query 1 The unit was ml. After my query I was left with 19 results narrowed down from the entire database. The quantity was 100 or 250.

Query 1 design This is the design view of my query, I created this

Query 1 design This is the design view of my query, I created this as a criteria for the search of my database. Everything in the database that fit the criteria was shown. I refined the search by allowing only dairy products to be shown. I refined the search by only allowing products measured in mililetres to show. I refined the search by only using quantities of 100 and 250.

Query 2 After I ran my query 2, this is what I was left

Query 2 After I ran my query 2, this is what I was left with 30 results from the database. All the results met my criteria from my query design in relation to my survey results.

Query 2 design The groups asked for in my criteria was meats and vegetables.

Query 2 design The groups asked for in my criteria was meats and vegetables. I refined my search by only allowing foods measured in grams to show. I further refined my search by only allowing foods with quantities less than 71 (grams).

Query 3 My query 3 was the most refined of my queries. It only

Query 3 My query 3 was the most refined of my queries. It only had 15 results from the entire database. The query was related to my survey results

Query 3 design Only products with over 27 carbs fitted the criteria. Only dairy

Query 3 design Only products with over 27 carbs fitted the criteria. Only dairy products fit my criteria. I used grams and mililetres as my unit criteria. For both the products measured in grams and the products measured in mililetres, only products with 100 of said units will show.