Landscape Business

[billgyrotech]

Hello,


I may be starting a Landscaping Business soon. Does anyone know of a good template that will have Invoice reports, Customers table, type of service table, supplies table, etc.?


Basically a service type of database.


Thank you

 

[AccessBlaster]

Hi billgyotech,
Because every database has different uses and goals it will be hard to find an exact match to your specific needs. The Northwind sample database that comes with Access is a make-believe business.

The sample has already been normalized and has its relationships defined. The Northwind sample can help you create a good foundation for a small business database.

In the example below I have removed most of the tables, I left only the meat and potatoes. Import the table(s) you need into a new clean database, analyze the table structure and customize them to your needs. Then build your queries, forms and reports.

This example is not meant to solve your issues, rather give you visual ideas.

 

[billgyrotech]

Thank you so much for your efforts i will start on it in the morning.

 

[jdraw]

Lots of sample data models at Barry Williams' site

Here's one re Landscape Gardening.

Here are the related Business Rules/Facts for the model.

Customers and Invoices

 

[billgyrotech]

Thank you for your thoughtful ideas I will check that also.

 

[CJ_London]

cross posted here
https://www.accessforums.net/showthread.php?t=77774

apparently the responses both here and the other forum were 'not helpful'

 

[billgyrotech]

Thanks I will try on my own. I understand that I have asked too much from this and the other forum.


Take care

 

[isladogs]

I have restored this deleted thread which contained several responses.
Even if the various answers weren't useful to you, they may be to others in the future.

 

[billgyrotech]

There is nothing at all useful here so it is up to you to keep this thread.

 

[isladogs]

It is standard forum etiquette not to delete threads with responses.
Two of our members spent time contributing links and info on the Northwind database.
Personally I thought these were useful (if not to you). That's why I restored the thread.

 

[AccessBlaster]

Hi billgyotech,

We hear your frustration, all of us have been there. It feels like its impossible to formulate the right question. The natural thing is to reach out to other forums. We are all volunteers here including the mods and experts. So when questions get duplicated on other forums it frustrates the volunteers.

Please feel free to start over, but keep in mind we can't actually build it for you. It has to be a collaboration.

 

[billgyrotech]

I guess pencil and paper will do.

 

[mike60smart]

Metamorphic Design is a premier landscaping company in Dubai, specializing in high-end interior and exterior renovations with bespoke turnkey solutions. We create stunning outdoor spaces, blending luxury with functionality for residential and commercial projects.

This is a 6 year old thread ??