Access 2013 - sample diabetic database

My OS is win 7 prof 64 bit and I use Office 365.  I am trying to create or possibly draw from a sample database, a database for diabetic people.  The data to enter is the food that they ate on a date: day and time; the type of good they ate -will be more than 1 of course.
Then if it was for dinner, then the reading will be taken the next morning to see if that particular food, spiked the sugar readings, or lowered the readings.  
is there any where someone has already done this, that I can use as a guideline either to copy their model or build my own. Thank u.
jegajothyretiredAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jeffrey CoachmanMIS LiasonCommented:
I would first start with a simple db that tracks the blood sugar levels.

Tracking "meals" will be difficult because of the possible ambiguities
What constitute a meal?
What constitutes a "course"
Does it include what they drank?
What about a "snack"?
How are you going to categorize these food types?
What about "ingredients"?
Will you be tracking sugar content of the meals? What about proteins?, Fiber?, Calories, ...Fat?
...all of these play a role in blood sugar levels.

From working on many "Meal" databases here, ...this is not easy unless you will be using the very simplest design....

So I would just stick with a blood sugar monitoring db, ... and get that going good first, ...then worry about integrating "Meal Tracking"
tblPeople
pID
pFName
pLName
pDOB
pHeight
pNotes
...etc

tblTests
tID
t_pID
tDate
tTime
tReading
tNotes
...etc

tblWeights
wID
w_pID
wDate
wWeight

From this simple design you can obviously query for almost anything you like.
But the good thing is that you can create graphs to see the High and low blood sugar level over time, and track the effectiveness of the insulin...etc
...and do the same for their weights.

Other things to consider are A1C tests, and their frequency.
...etc

But as you know, we are limited in the scope of total advice we can give, ...and we cannot provide a full solution, ...as this will depend on some factors that are unknown, ...even to you, at so early a point as this.

But this should get you started...
Lets see what others may contribute...
;-)

JeffCoachman
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
I'd just kick in that I haven't seen anything like this, although that doesn't say there's not something out there already.

Way back their was a recipe sample DB which might get you part of it, but I haven't seen that in a while.

As a suggestion, I'd check for a smart phone app for how to possibly structure or just use.    If your goal is just to get the app, I would think a smart phone app would be best in terms of time, cost, and convince.

If your trying to build something for market, then that's something else, and I would seriously consider looking at Access Web Apps.

Using Access, you can design an app that has basic CRUD (Create, Read, Update, and Delete) operations and would be available to any device through a web browser to any number of people.   Runs through SharePoint (which you can get with Office 365) and data is stored in Azure.  Your app could then be sold in the Windows Store like a phone app.

Jim.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
jegajothyretiredAuthor Commented:
in resonse to Jeffery, u are on the right track.  My meter is able to output into a database the results, with the date and time.  But I think u have the right ideas in mind, and I want to see if there is something out there already done, rather reinventing the wheel.  thank u.
jegajothyretiredAuthor Commented:
thank u.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.