Add on to Existing Access Database App

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.

Evner: Microsoft Access, Visual Basic for Apps, Windows Skrivebord

Se mere: add data existing access database, add existing access database, what is the meaning of data structure, what is data structure in programming, what is database programming, programming in access database, programming access database, price of app, microsoft access programming, meaning of data structure, i need an access database, different type of data structure, data structure meaning, access database software, access database module, rental properties for sale, market prices, sales app, real estate app, pop-up formula, database calculations, access database, sales report access, query pop, rental access

Om arbejdsgiveren:
( 30 bedømmelser ) United States

Projekt ID: #4101306

11 freelancere byder i gennemsnit $179 på dette job


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 dage
(665 bedømmelser)

13+ years of Access programming. Please see the PM for comments.

$160 USD in 4 dage
(7 bedømmelser)

I like to discuss further

$250 USD in 6 dage
(7 bedømmelser)

Hello Sir, kindly check PMB.

$100 USD in 6 dage
(8 bedømmelser)

Hi, I can do it. Please send me database structure, may be some data and the previous application. Thanks

$150 USD in 7 dage
(2 bedømmelser)

I couldhelp you

$250 USD in 10 dage
(1 bedømmelse)

Brian Griffin 813 375 2755 EXPERIENCE Independent Consultant / Systems Analyst Feb 11 - Present I am designing and developing a VB.NET (ASP.NET) application for the state of Virginia 911 emergency service org Flere

$250 USD in 3 dage
(1 bedømmelse)

i take it. if you accept i need 3 days to start. enjoy

$50 USD in 10 dage
(0 bedømmelser)

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 he Flere

$250 USD in 5 dage
(0 bedømmelser)

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 Micr Flere

$200 USD in 3 dage
(0 bedømmelser)

Hello. More 20 years programming experiense. See pmb, please.

$30 USD in 0 dage
(0 bedømmelser)

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 dage
(0 bedømmelser)