Anybody have a Property Management database in Access??

[Linda]

Starting Monday, I will be Property Manager for several small apartment
complexes (one owner). The owner’s main priority is getting all information
straightened out and maintained in a functional way. I believe that the best
way to do this is with an Access database, identifying the property, the
buildings, the apartments, the tenants, lease periods, rental amounts, etc.
I know only the barest of basics where Access is concerned and have no clue
how to set this up to provide the info and create the reports needed to do
this thing right. I'm collecting the info via Excel at this point, but
definitely think an Access db is the way to go. Has anyone already created
such a database??

 

[Bernard Piette]

I am currently working on exactly such a database and have done much work.
Maybe we can put our heads together Or.. I could share depends whatever--

It includes

Start Data Entry
Create Basic Locations Entries
Enter Countries
Enter Canadian Provinces and Regions
Enter Cities

Create Entities
Add People
Add Prospects
Add Employees
Add Customers
Add Witnesses
Add Tenants

Add Companies
Add Companies
Add General Suppliers
Add Notaries
Add Management Companies
Add Mortgage Brokers
Add Renovators

Create Categories
Building Categories
Departments
LifeStyle Categories
Parking Categories
Payment Terms
Priority Levels
Property Categories
Prospect Categories
Supplier Categories
Unit Assignment Categories
Unit Assignment Sub Categories
Unit Categories
Unit Project Status
Unit Renovation Categories
Unit Sizes
Unit Status
Unit Task Categories
Unit Task Status
Unit Task Sub Categories

Create Properties
Enter Real Estate Properties
Enter Buildings
Enter Parkings
Enter Units
Enter Unit Dates
Enter Unit Financials
Enter Unit Multimedia

Create Business Processes
Unit Lifecycles
Unit Projects
Unit Tasks
Unit Assignments
Unit Renovations
Unit Visits
Unit Reservations
Unit PTP Final


Queries
Reports
Automation
Graphical User Interface


Bernard Piette