Access 2013

My OS is win 10 pro and I use Access 2013.  I am trying to create a small database to keep track of my food intake, the date and time, and also the readings; so that I will know what made the readings to spike before the previous snack or food intake.
I am trying to design where for a given date + time + reading,  the amount of  food intake may be more than 1.  i.e. i could have rice, coffee, orange, curry chicken, etc etc.
Is there any sample databases where I can observe how this done and use the same idea.  Thank u.
jegajothyretiredAsked:
Who is Participating?
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:
You will have to clearly define: "Food Intake"
...as this can be expressed in terms of Weight or Calories, Sugars, ...etc

When you say "Readings", ...are you referring to "Blood Sugar"?
...that would imply "sugar Intake", ...not really by weight or calories.

The tricky part of any "food" database is how you define each "food".
Meal
Entree
Ingredient
Snack
Items
...etc
...can all be used, somewhat, interchangeably.

So, again, you will have to define "Food Intake"
And also state what type of Readings you are gathering
Then define how you are categorizing your "Foods"

Ultimately we also need an example of the type of output you are expecting.

JeffCoachman
0
EirmanChief Operations ManagerCommented:
The Diabetes log book database here should be useful
http://www.witstoronto.ca/databases.html
https://www.youtube.com/watch?v=Hv61V-k44mw

You can download it (and other DBs) for free and make a donation if you like.
0

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:
Dear Eirman, with one stroke u have also solved my other 2 other pending projects that i am working for an NGO, i.e. the volunteer database, a contact database, and also the solution my present question.  I wish I could give u 500 x 3 points?  Thank u again.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

EirmanChief Operations ManagerCommented:
Thanks jegajothy.
I just watched the full video .... it's a well thought out database.
I'm going to donate to the Salvation Army myself as I want the chart feature.
The volunteer database also looks great.

I'm sure you can get better contact databases (CRM) if you look around.
0
jegajothyretiredAuthor Commented:
thank u Eirman.  I am going to use the diabetics program and just installed the Access runtime and also the program itself since my pc is 64bit.  But the screen and fonts seem to awefully small and do not occupy the whole screen.  I have still not finished poking around so I may be missing something.
on CRM, i used Act for Sage but they did not catch up with technology and the latest versions did not keep up with the latest Microsoft OS.  I will revisit this and take a peep again as I like the software.
but in the meanwhile, the volunteers database looks great, I will take a look after I am done with the diabetics program.  Thank u.
0
EirmanChief Operations ManagerCommented:
The runtime version of Access has some limitations - I suggest you use the full 32 bit version of Access.
The diabetic DB will work fine with 64 bit Windows and Office 32 bit.
Most people use the 32 version of MS Office.

You only need the 64 bit version of Office for things like really massive spreadsheets.
https://support.office.com/en-us/article/Choose-the-32-bit-or-64-bit-version-of-Office-2dee7807-8f95-4d0c-b5fe-6c6f49b8d261
0
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
Windows 10

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.