Thank you for the opportunity to bid on your project.
In short, I work for a major public department in Australia that works on real property data (RP Data) and land titles data from the various states. I’ve worked on MS Access databases daily for the past 13 years creating such Access databases for taxation analysis on capital gains, debt management dashboard reports and analytical models. I have diplomas in information technology and an undergraduate degree in accounting (please visit my portfolio link if you would like to more about me).
As I understand your project description you are looking for an Access system that can auto upload property data and perform basic property sales analysis. The system needs to be simple, flexible and adaptable. I have developed similar products for a former client.
Some questions for you:
1. What operating system are you using (Vista, 7, 8, Other) ?
2. What MS Access version are you using (2007, 2010, 2013, Other)?
3. What file format is your property data in (CSV, TXT, EXCEL etc)?
4. How much data do you estimate there is (megabytes / gigabytes)?
I have same database designs that are similar to what you require. Could I suggest you take a look at them as a starting point to a design that will suite your needs. If you will like to see them please message me and I will attach copies.
Thank you for your time.