Photo by Melody

Article: Maintaining an Organized Garden: Access Database

Communities > Forums > Article: Maintaining an Organized Garden
bookmark
Forum: Article: Maintaining an Organized GardenReplies: 4, Views: 36
Add to Bookmarks
-
AuthorContent
Oberon46
(Mary) Anchorage, AK
(Zone 5b)

January 3, 2011
10:54 AM

Post #8290191

I also realized that as my garden grew there was much I wanted to record for the next year. Usually to prevent mistakes or disappointments in expectations, like bloom time. I have used Access for years as an accountant so it was a pretty natural end result. But it started with an excel sheet. I didn't have time to develop Access while I was still working but knew that I could import all my data into Access when I had the time. Voila! I retired and now it is huge. Well, huge for me. About 400 entries, each with a possible 30 data pieces, including pictures. The things I find most useful are the dates. After 5 months of winter and a month on each end of that that isn't too great, I am antsy to see who survived the winter, and who will bloom first. I have gathered dates for first green to appear, first bloom, last bloom. Have missed many but this will be year three and I can now print a report, put it on a clip board each time I go to the garden and it assures not regathering old info, correcting for year (I have a field where I can record sequential bloom dates by year as this may vary), and making sure I get pay attention to plants for which I have NO dates. Great fun.
TexasTam
Plano, TX
(Zone 8a)

January 3, 2011
11:02 AM

Post #8290200

Great info! I would love to learn Access - have twiddled with dbs for some time but never hunkered down and really learned. I wondered if I could export Excel to Access, so that's good to know!
nurealam
El Cerrito, CA
(Zone 9b)

January 3, 2011
1:37 PM

Post #8290455

I've used Filemaker Pro (and its predecessors) for 20 years to keep track of gardening chores (by month).
Not perhaps as useful for things like planting seeds and other one time events. I keep info by plant, by month and then fertilizing, spraying, pruning and notes printing out the lists at the beginning of the month (of all those plants within
each category that have something entered in the db for that category for that month).
I'm also very data oriented like mstella and I find this to work very well for me.

One downside perhaps to being so data oriented is that I do not revisit my entries as often (every few years?) as I think I should. Obviously if a plant doesn't work out or what I planned for June really should have been done in April, of course I revise the database. It works for me and might for others who do not or cannot devote huge amounts of time to thinking about the garden.
Oberon46
(Mary) Anchorage, AK
(Zone 5b)

January 4, 2011
2:11 PM

Post #8292354

Texas Tam, if you would like a plain instruction (written out with pictures) on how to export from excel to access, I would be happy to provide. Writing documentation is also a second love. Had to write tons of it when I was working to develop books for my accounts who were somewhat technologically challenged. Or simply had never performed a particular function. Quite often involved combining excel with whatever our accounting application was. Loads of fun --- seriously.

Mary
TexasTam
Plano, TX
(Zone 8a)

January 5, 2011
8:02 AM

Post #8293445

Thanks Mary! I think I'll take you up on that...you can send to tamara.galbraith@gmail.com. Thanks again!

You cannot post until you register and login.


Other Article: Maintaining an Organized Garden Threads you might be interested in:

SubjectThread StarterRepliesLast Post
Great! jazzy1okc 1 Jan 4, 2011 8:39 PM
seeds from discount stores billsue 6 Jan 7, 2011 7:26 PM
A good new year's resolution! NLaw 0 Jan 3, 2011 6:27 AM
Check out this ready to use Journal hollys_hints 3 Jan 5, 2011 5:30 AM
Recording DianeEG 0 Jan 5, 2011 6:54 AM


We recommend Firefox
Overwhelmed? There's a lot to see here. Try starting at our homepage.

[ Home | About | Advertise | Media Kit | Mission | Featured Companies | Submit an Article | Terms of Use | Tour | Rules | Privacy Policy | Contact Us ]

Back to the top

Copyright © 2000-2014 Dave's Garden, an Internet Brands company. All Rights Reserved.
 

Hope for America