Posted: 1/30/2004 9:02:48 PM EDT
| I have no clue how to use that microsoft access program. Anyone got a database for it? I got stuff written down in a notebook with meals, exercise, sleep habits, daily activity but am trying to figure out how to make it a nice yearly package with MS access. |
|
It shouldn't be to tough to make that sort of thing in access. Maybe make a table of food items where you store the nutrition information on things you commonly eat. (one item per line). Then make another table that is your daily log where you can just put in the date and the item (either a name or a description). Join the two tables together in a query and you can summarize your food by day, month, week, etc. Make similar tables for exercizes too. I don't have access at home or I'd make an example for you. It's pretty easy to get going on if you just play around with it. The wizards and design view modes make it pretty easy to play around with things. If you start messing around and want some help, just let me know. Once I'm at work I'll have access and could make an example database to get you started. |
|
With Access (and most DB management systems) you enter/store data in tables. Tables are similar to Excel worksheets. Queries are used to lookup and organize (sort, sum, correlate, etc.) data. Use reports to format the data for viewing or printing. Access reports are like Excel reports only way more powerful. Access is limited compared to the big guns but it's great for single user applications. It's also one of the easiest ones to get up and running. What are you looking to do? If you're after an electronic journal it shouldn't be too hard. |