How do I set up a database for a construction company?

[Guest]

I need to set up a database in Access that allows me to put my customer
information in, as well as my vendor information.
This way I can see how much each job costs, without having to also put the
info in excel

 

[Patrice]

Not sure what is the problem ?

Basically you'll have to list the name and type of each set of related
information you want to record in the DB. Watch out also tutorials to see
how to best establish relationships between tables inside a database...

 

[Guest]

I suggest making at least 2 tables - on with customer information, one with
vendor information, and link those.

 

[Terry Kreft]

This is not a trivial exercise.

You'll need to be able to record/calculate the following:-

Customer details
Vendor details
Purchase
Sales
Stock
Labour costs
Project details
Project items
Labour items

and all the other stuff that doesn't come off the top of my head.

You are better off seeing if there is an off the shelf package which will do
what you want or getting someone to write a bespoke system for you.



--

Terry Kreft


"database construction company" <database construction
(e-mail address removed)> wrote in message
news:[email protected]...