I worked as a Certified Management accountant. I almost made a career writing VBA code, in Excel but also Access. It is vital when there are many files and systems and there is no properly built tool for everything. I worked with many junior accountants and I automatized many workflows using Excel and VBA. I think it is relevant to know it.
If Access have better capabilities for data management why do you think that is more popular Excel for these tasks? I think Access should be the King y that cases. Thank you.
I worked as a Certified Management accountant. I almost made a career writing VBA code, in Excel but also Access. It is vital when there are many files and systems and there is no properly built tool for everything. I worked with many junior accountants and I automatized many workflows using Excel and VBA. I think it is relevant to know it.
If Access have better capabilities for data management why do you think that is more popular Excel for these tasks? I think Access should be the King y that cases. Thank you.
Excel is more flexible and can be understood even by non-technical people. I rarely see Access, but Excel is everywhere.