Nutritionist Customer DB

Access - based DB. Based on Nutrition Planner template found in Microsoft templates. Main idea: Ability to add new patients with all their details (like going to the doctor for the first time). View patients and when they visit log various measurements. Display graphs for various measurements over visit dates. For each patient log the payments received as well as the membership type, alert for overdue payments. Add new foods and recipes. Recipes made from foods in the food table or by user. Recipes have total for calories, fats, etc. Creating a weekly diet. Calendar week and ability to add: Breakfast, Snack, Lunch, Snack, Dinner, Snack. Ability to add extra meals. For each meal ability to add a recipe or food. Automatic calculation of calories/exchange list. Printout of diet/ability to export to word for further editing and saved under the patients name. Main screen: PATIENT MENU: Add new patient, View/Edit patients. FOOD MENU: New food, New recipe, View/edit foods/recipes. PAYMENTS: Various Reports, total payments for a given period of time, overdue payments, etc. New food same as the one in Nutrition Planner. Add new patient: Name, Age, Sex, Height, Medical information etc... Ability when a patient comes for a visit to select the patient and add new measurements: Weight, Waist, Hip and other mesurements, BMI calculated automatically, date the current date. Graph as in nutrition planner for each patient. Tabs for each patient, Details, Weight Log, Graphs for each: Weight, Hip, Waist etc, PAYMENTS Payments: keeps log of all payments from customers; ability to print a simple invoice. Membership type (monthly etc) More details if price is good