Build a Microsoft ACCESS data organisation and automation

Job ID: 32573492

Budget: $250 – $750 CAD

We want to use Microsoft ACCESS to manage our tenant and building informations such as :

A file to insert new tenants :
- Select the building
- Select the appartement in that building
- informations on that appartmant pops up (size, last price, adress, notes)
- Last Name and name
- Phone number
- e-mail
- Date of renting
- Second tenant if there is (and their informations)
- Attached files
- Notes

A file to insert new buildings :
- The adress
- The appartements
- Size
- Last or current Price
- Notes

A file to insert payment per month :
- We select the tenant (by research of their name, their e-mail adress or phone number)
- We add the amount of the payment
- And the way they paid
- The date
- Or a note that says when they are going to pay

Automations :
- We can print enveloppe ticket with their Last name, name and adress
- A list to see every tenant that started renting at a certain month (we can select the month we want)
- A document that sums up the total amount every month and total for the year. (starting January 1rst, by period, exemple : january is period 1).

Knowing french would help but not neccessary