First Time Access user! Need help with creating database for CRM and Job costing!

[bcbbab]

Beginner access user! Now that that's out of the way, I need help. I am trying to create a database that will have a CRM and the ability to do construction job costing, proposals and queries. I build swimming pools. So, I need to know how to set up the tables. If I have to figure the cost of a job, I need the ability to enter costs for 1 item sold from different subs. For example, if I sell a customer a bench, it will COST me an amount from my excavator, my steel crew, my gunite crew and plaster. These are different vendors. But, since I am creating a proposal, I need to be able to have a retail price for this bench (per foot) and have the database figure my exact cost. How would I set up the tables?

[ranman256]

This is a BIG job for a beginner. I hope you know some about related tables and basic SQL.
with that, I think you will need a
Crew table:
_________
steel
plaster
etc

Also:
Vendor table
Supplies table
Jobs
proposals

Start there. This is not a trivial db. Complex even for a pro designer.

[bcbbab]

I am not opposed to hiring someone to do it. If I can't figure it out, I just might have to!