Gardening database help?

[chaz]

My hobby is gardening and i want a database for my seeds...........

I am trying to create a database that would allow me to link a photo of my
plants. I would like to be able to enter a seed name, scinetific name, bla
bla, and a photo of the plant.

The report would reflect a page with the information input and a picture.

Any advice in the right direction would be appreciated.

 

[Guest]

Hi, Chaz.

I believe there are a number of commercial database applications for
gardening already out there. Check at Best Buy or another software vendor.
Could be there's a robust application already available that suits your
needs. You might also check advertisers in gardening magazines or online
gardening clubs/forums for information and feedback on whatever you might
find.

If you're looking to create what you want in Access, what you've described
doesn't sound too difficult. It's the "bla bla..." portion that concerns me,
i.e., what you've left undefined. Depending on what it is, you might have
many different solutions. But if what you've left out are merely additional
attributes of a plant, it sounds like you would need only a single table:

Plants
-------------------
PlantID AutoNumber (Primary Key)
GenericName Text
ScientificName Text
Picture Hyperlink (to a filename on disk)
Keywords Text or Memo
etc..

I think you could simply use the Report Wizard for a basic report, inserting
a Page Break on each record if you like.

Hope that helps. If you have any more specifics on what you'd like to
store, feel free to post.

Sprinks

 

[Larry Linson]

If you feel compelled to ask the same question in multiple newsgroups,
please do so by cross-posting, rather than entering identical, but separate
messages. I have responded to your question in comp.databases.ms-access.
Please look there for the answer.

Please also read the FAQ at http://www.mvps.org/access/netiquette.htm for
good suggestions on effective use of newsgroups.

Larry Linson
Microsoft Access MVP