Storing Real Estate Information in Accees - Best Way?

[ExcelGirl1975]

Hello

I am creating a database to store a collection of buildings and their associated square feet. I am creating a second table to capture all buildings changes in SF (e.g. if the client no longer leases 1 floor of a building OR the client decides to add a floor to a building, OR the client exits a building - get the gist?).

What the client wants to do with this data is to show changes to any building's square feet over a period of five years (any five year period).

So should I create a table with a record of the buildings square feet for each year, every year

OR

Can I create a table that only captures the CHANGE in SF and the year that change occured, using a query to caculate the change to the buiding's SF by year.

 

[jackd]

I suggest you make a data model as a first step. Then create some sample test data and
see how well your model deals with the data. Adjust as necessary. Then deal with tables
and processes.

There are a number of data models at this site. Some relate to real estate, properties etc.
Perhaps some of these will help you.
http://www.databaseanswers.org/data_models/index.htm

http://www.databaseanswers.org/data_models/real_estate_properties/index.htm