MS Access Database Designed

As a small side venture, in my local I rent out lock up garages and parking spaces for parking and storage. Some I manage for other people so I take a commission, some I own myself.

I currently use Excel, and each garage/space has a worksheet which shows the tenants details, address etc and rent. I log the rent each month in a row, I then minus my commission in a different Column so I know how much to pay the owner.

Column A = Date Due, Column B =Amount of rent due, Column C = Amount of rent paid, Column D = Date rent Paid, Column D = My Commission percentage, Column E = Amount owed to owner, Column F= Date Paid, Column F= My Commission.

I then have another worksheet that pulls all my commission from every sheet and let’s me know how much I’ve made on each garage/space and how much my total profit is.

When a new tenant moves in, I create a new worksheet from a empty template and link it to the totals summary worksheet.

At the end of every tax year. I save the old excel document and create a new one so I have that data to pay tax.

Is there a easier way I can do this on MS Access? I was thinking of creating a mail merge word document so I can send the owner a statement of what they have been paid each month.

Also an easier way after every tax year to start fresh or filter the data so i know what my earnings was.

Also an easier to store and create new tenants once a old one moves on (Keeping the old tenants data)

Also a page that shows rents that are Overdue. So I can keep track on rents to chase.

Please let me know if this is possible and a rough cost. I need to keep this as cheap as possible please as i do not earn alot doing this, i can continue to use excel but it always worth looking to see if there is a better faster way.

Thank you

Kiran