is Access is the best tool for building an accounting program?
if not .. what is the best for that?
Most people trying to build accounting programs lose a lot of money and time.
It's
much much and much again more difficult than it seems.
My advice is always to buy in some professionally written software.
I would never get involved in that again myself, and I have some experience in databases and coding.