[URGENT] Database

Hey there, ive been asked by my boss to come up with some sort of database, for accounts.

Basically he wants:

When someone pays it is updated on the database and it says when they paid, how much, if they didnt pay, if they didnt pay last month and paid this month which means in areas. And he wants it to be simple to get up and understand.



Would this be an excel job? Its for Rents...

Would it be easier to do one big one and keep updating the values? OR Do one per household and then update that by going onto the file and editing it?


Any help suggestions or tutorials greatly appreciated, rep and if you play it, furni given out.

You could consider using Access if you don't want to come up with some kind of custom solution.

I use excel for everything so I would suggest excel.

Access > Excel.

You could also write a PHP file to update/add new users your database easily if it's web related.