Help on designing landscaping database

[monroe]

What I need to do is track what landscaping work is done at different
properties, like mulching edging, pruning fertilizing and also contains
information regarding the contract prices and hours there is also work done
on fountains, ponds, weeding, flowers, trees, and aeration - any of the usual
landscaping duties. As of now the tracking is done on entirely excel- each
property having it’s own worksheet, which is VERY slow. As of now I have
nothing started for access, I am still in the brainstorming part. I seem to
be stuck on how I need to set this up correctly. I want to be able to simply
type in how much the contract price is, the total hours and how many
occurrences are included in the contract price and for the it calculate how
much $ for each occur and how many hrs for each occur. Occurrences vary for
each type of service done. I also need a form to print out that my guys can
write on out in the field and I can enter the actual work done.

I’m thinking to have 1 table for just the property information like phone #,
add, etc, a second table with the contract information like price, total
hours, things to be done (there is a lot so should I make this field a drop
down?). Those two tables being linked together by the property name. That’s
is where I’m stuck a; as far I have gotten. If I didn’t explain right or
enough, just mention it and I’ll add more info. I have had a brainfreeze
trying to just design it for over a week~~ If you would like to contact me
directly reguarding this-its kittykatkarin at yahoo~ Thanks so much for some
advice!!

 

[Guest]

Hi monroe,

Sounds like you want a service database... I'm pretty sure Access has a
sample Service database, try this:

Open Access 2003, click new database, Online Templates... there is one
called Service Call Management... see if this gets you started.

Damian.

 

[monroe via AccessMonster.com]

Got it, I'm trying out now, will have to make some adjustments but I think
its what I've needed
Thanks v. much Damian,
>-

Hi monroe,

Sounds like you want a service database... I'm pretty sure Access has a
sample Service database, try this:

Open Access 2003, click new database, Online Templates... there is one
called Service Call Management... see if this gets you started.

Damian.

What I need to do is track what landscaping work is done at different
properties, like mulching edging, pruning fertilizing and also contains

[quoted text clipped - 19 lines]

directly reguarding this-its kittykatkarin at yahoo~ Thanks so much for some
advice!!