Real Estate Management Database

[Mohsin Malik]

Hi, I am designing a Real Estate Management Database where i can manage my Property and all the record related to my tenants, property expense, rent received, rent due etc. I have some Questions where i am stuck in finding the solution, first of all I have a tblBuilding where i can add my property having BuildingID as Primary Key, then i have a tblUnit where i can add Multiple Units of Property having BuildingID as a foreign key. After adding Property i then have a tblLease as an agreement table that is linked with tblUnit and tblProperty as well. As if the property is of SingleUnit nature then it have only one tenant so a one agreement (direct r/ship with tblLease) and if a building is multiUnit then its unit are linked with Multiple tenants and Agreement.While creating a group by Query where i have to display my Building and Sub Units (if any) with tblLease having [Last of Rent Amount], [Last of Agreement Start Date], [Last of Agreement End Date]. Running this Query give me the errors of , I have more questions regarding Agreement and rent calculation, how ms access remind me about the rent due amount and balance and is this possible to automatically increase rent by 10% of every tenant after 12 months, Review my attached database for info? Please guide me in designing this database software? Thank You

 

[JohnBroderick]

Hi...

Nice to see your services that you have shared here. Infact rael estate management database is such a facility for real estate agents and landlord..

 

[Pat Hartman]

Your schema needs a lot of work. It will be better to fix that before you do anything else. You need to review the rules of normalization and get rid of the repeating groups. Things like phone lines and meters belong in a separate table. Another problem is tblDebit and tblCredit. There is no reason for them to be separate. As you can see, all but one column is the same in both tables. Make one table call it tblTransactions and add a field named TransactionType to identify the type of transaction.

I am also curious about the tenant table. Isn't the tenant living in the unit he is renting? If he is, there is no need for an address in the tenant table.

Your table and column names look good.

 

[aman30]

If you have lots of properties, then it is necessary to manage them like their time to time maintenance. You can provide it for rent. You can use it as an income source.
___________________
Builders in Jaipur

 

[erik345]

There are many companies which maintain property database because it is very easy to find properties according to requirements from the database. I own a property management company and want to buy a good management database so tell me the best database to maintain whole record of properties.

 

[Mohsin Malik]

There are many companies which maintain property database because it is very easy to find properties according to requirements from the database. I own a property management company and want to buy a good management database so tell me the best database to maintain whole record of properties.

Are you talking about Goods Management in Ms-Access, The Best Goods Management database in Ms-Access is on the following Microsoft website: Download Goods Management Template compatible with Ms-Access 2010 and furthermore I have completed my Project of Real Estate Management in Ms-Access.

 

[Severin]

Hi, It's hard to know where to start because there's a lot of issues that needs to be sorted for the database to function.

You have done lots of work on your db, so for people to help maybe you should present a problem at a time. When one is solved you can go on to the next.

 

[Pat Hartman]

Welcome aboard erik
I'm sure you can find advice regarding off-the-shelf applications from a property managers user group. We are not subject matter experts here. We develop software. I have a product that I sell which is used to evaluate income producing properties but it doesn't manage properties that you own so I probably know more about the subject than most but I couldn't make a recommendation without hours of searching and evaluation.