I need an excel template or a model access database that will allow our real estate company to do the following:
Electronically Catalog our closing files (basically an electronic index)
Provide a file that we can use as a mail merge to send mail out to our past clients
Provide a method to produce and print several reports:
1) All files that are older than 5 years old (there should be a closing date field that will allow this)
2) A report which will show all of the agents in the database and what they sold in the past year (although the past five years will be in the file)
3)A report which will show how much $$ have been sold in the past year or another selected year (note see below - if there are two agents involve, the purchase price should be added twice) and give a total, maybe even a quarterly total also.
Should also provide some way to search the file by several different methods.
please contact me for the necessary field lists after I accept your bid, basically they will be buyer name and address, seller name and address, date closed, agent, agent 2 (if in house sell), property address, purchase price
Happy Bidding!
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
windows xp , microsoft office xp