Find Jobs
Hire Freelancers

Add on to Existing Access Database App

$30-250 USD

Cancelled
Posted about 11 years ago

$30-250 USD

Paid on delivery
I have an Access database app that runs a query on real estate sold listings to determine market prices for new properties that come up on the market. It then figures out the list price per square foot vs. average sales price per square foot for a new listing and then filters out those new records where it is over 80% of the average price, all using data from properties that have sold within the same subdivision (and filters using the subdivision field in the database). Now I need to add a new module and query to the database. This will require adding a few new fields to the database structure where all the data will be held. The data to be imported will have a couple fields different than what has been built in currently. I want a new module that takes records where status=L (meaning it was leased), then compare average lease prices per sqft to the sales price of a property, all that are within the same subdivision. Then, using a formula that spits out a number, it filters out those records where status=A (for sale) where the calculation is less than a certain percentage (I'm thinking 10% is that number). In other words, instead of finding an average Sales Price like the software does now, I want the new module to find this "Gross Margin" number for properties that potentially can be rentals. The data will be imported the exact same way as it is now. I will only be importing records where Status=L. The calculations to be done on import will only be a Lease $/sqft number. All the data stored is easily sortable and has been created using generally accepted programming standards. I also need to be able to ignore records that I have reviewed, but have those previously ignored records pop back up once the ListPrice has been updated through an import. It will have to be a different type of ignore than what has been coded currently, as there is an ignore feature in the current report. The database has live data so that will have to be converted to accommodate the few new data fields. Capture1 is the main screen. Capture2 shows the import dialog box. Capture3 shows the reports to be generated (where I would like to choose to generating "Rental Property Report". Capture4 is the 80% report that shows properties whose list price is 80% or less than the average within its subdivision.
Project ID: 4101306

About the project

10 proposals
Remote project
Active 11 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
10 freelancers are bidding on average $172 USD for this job
User Avatar
I have 20+ years of experience programming ms-access, .net & sql server. At your disposal for any doubt or question, Regards Fabio
$185 USD in 10 days
5.0 (656 reviews)
7.3
7.3
User Avatar
I like to discuss further
$250 USD in 6 days
5.0 (8 reviews)
4.3
4.3
User Avatar
Hi, I can do it. Please send me database structure, may be some data and the previous application. Thanks
$150 USD in 7 days
5.0 (7 reviews)
4.0
4.0
User Avatar
Hello Sir, kindly check PMB.
$100 USD in 6 days
4.7 (14 reviews)
4.2
4.2
User Avatar
I couldhelp you
$250 USD in 10 days
5.0 (1 review)
1.8
1.8
User Avatar
i take it. if you accept i need 3 days to start. enjoy
$50 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, I was selected to be one of the two technical reviewers for the text book 'Microsoft Access 2010 Inside Out' (Microsoft Press) - if you have that book you will find my name on a cover page. Hopefully this helps establish my credibility with the Microsoft Access product. I am located in Birmingham AL. I am a solo practitioner but also an incorporated business since 2003 and member of our local Chamber of Commerce. As with any established business, I am available during normal business hours. In general my clients are seeking an established and reliable USA based developer. All my work is guaranteed. If this is a fit I welcome hearing from you. Regards, Jim B. Cahaba Data
$250 USD in 5 days
0.0 (0 reviews)
2.8
2.8
User Avatar
hi I have ten years experience on MS Access. I have done seven Access DB for client in 2012 also I have five years in MS Access 2003 and Access 2007 I am sure I can do it well. Btw: I were MVP about Microsoft Access in 2003 Bill
$200 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello. More 20 years programming experiense. See pmb, please.
$30 USD in 0 day
0.0 (0 reviews)
0.0
0.0
User Avatar
This sounds like an interesting project that would be enjoyable to develop. I am quite proficient in MS Access, and am interested in helping.
$250 USD in 10 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Austin, United States
5.0
30
Payment method verified
Member since Oct 26, 2009

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.