I own a subcontractor business that needs help managing the many jobs that we have going on all the time.
I feel that an access database would allow me to have a home page to select from different forms to submit the data that is needed.
I also need 2 or 3 reports that I can pull (and vary by inputs like dates, etc) to analyze the data.
I would hope to export some of the reports to analyze in excel as well.
The database is not a large one, I just need someone to set up the relationships, etc. so that it connects correctly and also with help doing the queries so that the right data gets collected.
We have multiple builders that we work for that have multiple neighborhoods they build in. In those neighborhoods they have multiple House Models they build that can be different House Types (varying the number of bathrooms)
For these homes that are built we are involved with each house 4 times. We call these phases and they are called 1st Rough, 2nd Rough, 3rd Rough/Trim and Extras/4th Rough.
Each of these job phases can have from 1 to 6 Employees that work on the job and we would like to track the amount they are paid, how many days the job takes.
A report would organize the data above so that I could find out (these are a few example)
1. How long a job phase is averaging for a certain house type
2. How much we average paying an employee for a certain job phase
3. What the average is that we are paying for a certain job phase
4. When we were paid for recent Trim jobs.
We would need to have a list of builder names
We would need a list of neighborhood names and the builders they are tied to
We would need a list of home types (3 up/1down, 2 Up/1 Down, 1 Up/3 Down, for example)
We would need a list of home models, what the home type is, the square footage, what the base $$ price of that model is, the last time the price was updated, and what builder the home model is associated with.
We need a list of jobs we do. Each job is associated with a model type, in a neighborhood with a builder. The job includes multiple (the 4 talked about above) job phases in which we have varying numbers of employees doing certain type of work and getting paid a certain amount for that. For Each job phases we are paid a certain amount, want to track how long that phase takes and what date the job phase was started and we need to track the date we invoiced for that job phase and also the date we were paid for that job phase.
Attached is a screen shot of how the basic database should look and be connected unless there is a better way to do it.
For the forms, I will need a form for the following:
To add a builder
To add a neighborhood
To add a model home
To add a job
To add the different phases to that job and the detail associated with it.
I also would need the ability to update the above model homes, jobs and job phases if changes should occur
I would be looking to have the MS Access file delivered so I can test it a few times and test the reporting functionality before final payment is delivered, I also need a time frame for how long you think this would take to deliver a final.
Please ask any further questions to clarify before submitting your bid.