MS Access: How to create a relationship between variable?

[StephenTang]

Dear,

I have an under-graduated internship in a real estate company which particularly leases their apartments to foreign tenants. My boss assigned me to create a rental property management through using Microsoft Access that is my final project to get a qualification.

However, I'm a newbie in technological applications. I've searched for an array of Access templates which is expected to be suitable with this business, however, it turns out the opposite.

My trouble is how to link these data together to accomplish the monthly invoices for tenants and manage the information:

+ A given building has a total of 10 rooms

+ Each room has its own rental payment (e.g. $300-$500)

+ Contracts with tenants could be 3-mth,6-mth and 12-mth periods, and they could terminate the contract before its due. Otherwise, each contract has a different start date and due date; So, the invoice should be issued monthly to tenants starting from the date of signing.

+ Each room has its own electricity consumption for every month
(Calculations as follows: the difference between the current and preceding consumption numbers, e.g. room 1A: 2356-2048 = 308 kWh, then multiplying with the price: e.g. 308 kWH * $0.15 = $46.2)

+ A monthly invoice for a tenant should include the next rental payment and the previous electricity fee
e.g. a invoice issued on 23th April is computed as
- the rental payment from 23th April -> 23th May
- and the electricity usage from 23th March -> 23th April

Can you advise me how to tackle this :D
Appreciating for your help

p/s: An Asian Boy
Best Regard

[twinnyfo]

Stephen,

It sounds more like you want us to create this project for you than just tackle one specific problem for troubleshooting. We don’t do that here. If you have one specific problem that is causing you issues, we would be glad to help guide you through toward a solution. But, since it looks more like you haven’t even begun to work on this project, we can't give you any guidance.

Also, it seem to exceedingly strange to me that a real estate company would require technical newbies (that's your language, not mine) to build an Access database for managing tenants as part of their internship.

Either way, you won’t find many responses with solutions for your question as written. We will stand by for more specifics.

[Rabbit]

My advice on how to tackle this is to do a tutorial on MS Access online or take a class.

Then create small test databases and work your way up through experience to creating full fledged designs.

Feel free to ask specific questions when you run into road blocks along the way. But as twinnyfo said, we're not here to do your work for you.