You Can Do ItDatabase, Queries and Reports 
Database, Reports and Queries
The database is a collection of food items gathered onto one sheet. Beside each item of food there is brief description about the nutrition. Using the database I then made queries and reports on low calorie food items. I've also created short PowerPoints explaining how I made the: database, the queries and reports. I designed a database in order to store all the data and ensured that each field had a suitable name, data type, format and length. I also then validated the group field. I also imported the data and if any of the records were rejected it was because I had validated the database to do so using validation rules. Then I found the details of three items in different food groups and inserted their nutritional information. I also made PowerPoints which displayed how I made the database, queries and reports.
  
graphic
graphic
graphic
graphic
graphic
graphic








Making my eat well database.pptx
Making my queries and reports.pptx
Breakfast Report.pdf
Healthy Fruit Snack Report.pdf
Low Calorie Dairy Report.pdf