I'm not sure where this should go but here goes:
A student of my mom asked me to workup something for her to store informations and do calculations.
Basically she described an events planner where she'll enter a date, name of event, the cost, and the payment to be received. Money owed, totals for the month and for a particular category will be calculated. She should be able to enter US, POUND, and a few other currencies of her choice and see in conversion in the amount owed/paid columns.
I used an Excel spreadsheet to do the job, most of her requirements anyway. :$. I detected a few minor kinks in certain formulas only after she paid for it but these kinks doesn't stop her from doing her main tasks anyway and I'll fix them the next time she comes by.
Now she's asking me to change a few things (which translates to additional complicated formulas on my part).
Should I continue working with the spreadsheet or would an Access Database file work better in this situation? When is a database the better choice vs a spreadsheet and vice versa for a small to medium number of records.