The boss handed me another project that deals with tracking a construction project from start to finish. It would log all changes and the financials for each change during the life of a project. This would have a report/template that could be sent to the customer so show the jobs current total, or what the cost/deduct would be for each change made.
I initially started doing this in Excel, but after I realized I was formatting sheets to be tables, I started wondering if it might be better to do this in Access instead. I have a rough idea of how it would look within Access, but am not too sure how I would structure the tables for it.
I attached what I had already thrown together to give a rough idea of the design I was aiming for. Based on that, which program does this appear to be better suited for? I will mention that the current iteration (not the attached) that is being used is Excel, but the reason the boss gave it to me for a revamp is on large projects, the sheet can become quite unruly to manage and sort through.
I initially started doing this in Excel, but after I realized I was formatting sheets to be tables, I started wondering if it might be better to do this in Access instead. I have a rough idea of how it would look within Access, but am not too sure how I would structure the tables for it.
I attached what I had already thrown together to give a rough idea of the design I was aiming for. Based on that, which program does this appear to be better suited for? I will mention that the current iteration (not the attached) that is being used is Excel, but the reason the boss gave it to me for a revamp is on large projects, the sheet can become quite unruly to manage and sort through.