DATABASE |
 |
|---|
The PORTIONS database stores data about sensible food portions for breakfast foods.
Open the database and make sure that you understand what each field is for. Use this list to help you.
Find details of three breakfast items which are not already in the database. These should be in different food groups.
Add a new record for each item.
Update your sources table.
Save a screenshot of your new records in your EVIDENCE folder.
Design and run three searches to produce useful information:
Purpose of search |
|
| 1 | To find portion sizes for foods in the Meat/Fish group |
| 2 | To find portion sizes and calories for foods in Callum's favourite food group with less than 150 calories |
| 3 | To find portion sizes for foods suitable for Anya who is a vegetarian, listed in descending order of fat content |
Save screenshots of your search criteria in your EVIDENCE folder.
Make sure your ongoing plan is up-to-date. Have you remembered to add comments?
Print this page