Access to track money?

[plasteredric]

Hi Guys,

I've scoured the internet the past few days trying to find if it would be possible to use access for what i'm wanting to do but haven't had any luck.

Im looking to set up a letting agency system and need a way to track rents for tenants and landlords.
For each tenant im going to need to add their due rent each month which will vary per tenant and also be able to input what rent has been received from each tenant.

I was thinking i would need to have a seperate table for each tenant and add the rents to this or have a table with all the tenants and a seperate table of received monies and set up a relationship between the two.
I'm just aware that adding lines or columns for each transaction may result in a very large database.

Any advice you can offer will be greatly appreciated.

 

[Isskint]

You have answered your own question really.

1 Table with Tenant details - TenantID, Name, rent etc
1 Table for rents received - RecieptID, TenantID, DateReceived, AmountReceived etc
If the rent will not change you could ignore AmountReceived, but i suspect rents will go up from time to time and there is a possiblity of defaults and lesser or greater payments.

 

[plasteredric]

Would I be able to create a statement/log of rents like the following?

01/01/2013 January rent charge 400
15/01/2013 received rent 200
30/01/2013 received rent 200
01/02/2013 February rent charge 400


cheers

 

[Isskint]

You want to be able to show what the tenant was charged and then what they paid?

Simple answer, Yes. Complex answer? How?
You could add 2 fields - AmountCharged and DateCharged - to the second table. This would give you an easy one line check but possibly more difficult to query.
Another option would be to include a field - PaymentDirection - that would indicate Charge or Payment. Thus each month, for each tenant, you would have 1 record showing charge, date, etc and another record showing payment, date, etc.
A third option would be a seperate table for charges. I do not think this is the right approach however.

 

[plasteredric]

thanks for that, thats a great help.
I'll get working on it and see how it goes, no doubt i'll be back here further down the line

 

[Alansidman]

http://www.excelguru.ca/content.php?1