To replace Access, you can use OpenOffice.org Base. I would suggest doing a test run, first with the most complex databases. Base doesn't have much in the way of calculations within the database, though it does have some reasonable query and reporting features. You can find ways of bringing data into Base here.
Regarding a bookkeeping application, I haven't used any. However, options include TurboCash, Lazy Eight (also written as Lazy 8), Emma, GnuCash, jGnash and QHacc.
Dig deeper on Open source databases
Related Q&A from Solveig Haugland
Our expert tells you how to use search to find strings in OpenOffice.org's Calc.continue reading
An office suite expert describes how to use ODBC with OpenOffice 2.0.continue reading
An office suite expert describes where to find information on OpenOffice 2.0's use in the enterprise worldwide.continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.