Sample database Condominium / Real Estate / Property management

[Daniel2000]

Looking for sample database that will contain the estate data, house numbers and tenants and that will calculate a monthly service fee.

[orange]

You haven't provided any detail.
You may get some design ideas from this free data model.

[Daniel2000]

thanks orange. what we have is district, estate, block number, parcel no and picture.

then we have the individual details of the block, i.e block a from estate a and house number is a1, bedroom size...

we will then have the tenant info....based on these, we then need to create a monthly recurring service fee on each house number.

[orange]

Can you work with the model and flesh it out to meet your needs? Are you looking for a packaged solution?
What is your experience/expertise with database?

[Daniel2000]

orange. thanks. i am well versed with database but i am in the process of designing the database from scratch. looking for some ideas to start with.

u have any idea how to post a monthly recurring fees in accept?

[orange]

How do you calculate the fees now? Can you tell us in plain English how fees are determined?

[Daniel2000]

orange, right now not calculating any fees as I am building the daabase from scratch but requirement is to have a monthly flat fee of say US$100 per house per month. every month the fees will be charged and user can then post the payment to offset against the fees. you will have due and paid every month.

database should charge the fee automatically as will have more than 100 units / houses. hope you can find a solution for me. also some ideas of building up the database.

thanks in advance.

[orange]

When you are constructing any database (or project) you should have a basic business model in mind.
For example, if you were building a shopping center, you wouldn't start by ordering concrete or steel.
You would start with a set of requirements from those requesting the center. You might build a prototype, or model
or an artist's concept picture of what the center might look like.

Start with laying out a business description. Mock up some test data and test it against your model. See if it allows you to get the info you need. If it doesn't, then adjust the model.
Don't start by building an Access database.

[June7]

Agree with orange. Need a model first. Make an ERD.

Charging fees 'automatically' will require code that creates records. That code has to be executed by initiating some event - button click is customary but code can be placed in a form open event and the form set to open by default when the db opens. A task can be set in Windows Task Manager that will automatically run a script that opens the database or directly calls a procedure in database.

The more 'user friendly' the more code.

[Daniel2000]

Ok. Here is what I have to work with
Table house.
house id / number (should be estate and block number combined)
house estate
house district
house block number

Table tenants (link to table house)

Then using the house table create a summary on each estate and block number to show their parcel number and their picture. Fees will be charged monthly as a recurring fee on the house Id

[June7]

Do you know anything about programming in Access? Do you know how to build queries - in particular an INSERT SELECT query that pulls data from one table for appending into another table? Need to understand these concepts to accomplish the automation you want.

[Daniel2000]

June7, thanks. Sure I do.

The task here is to link tenants with the house. house unique key is estate + block (i.e amazon A1, amazon A2) and this is generated using after update procedure.

Then the relationship is tenant house id = house id generated by after update procedure...easy said than done!!!!

if it was you, how would you link them?

[June7]

I don't understand why an UPDATE procedure is involved.

I presume you need to retain history of tenants that occupied each unit? If yes, then you need a junction table that documents this association. Example:

tblTenantUnit
UnitID
TenantID
DateOccupied
RentAmount

[Daniel2000]

June7, based on your explanations, how then will you link the tenant and house tables? unit id is the link in tenant table which wil link to quivalent to house id

[June7]

The table I suggested is the link. Create records by data entry.