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.

Kemahiran: Microsoft Access, Visual Basic untuk Aplikasi, Destop Windows

Lihat lagi: 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

Tentang Majikan:
( 30 ulasan ) United States

ID Projek: #4101306

11 pekerja bebas membida secara purata $179 untuk pekerjaan ini


I have 20+ years of experience programming ms-access, .net & sql server. At your disposal for any doubt or question, Regards Fabio

$185 USD dalam 10 hari
(665 Ulasan)

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

$160 USD dalam 4 hari
(7 Ulasan)

I like to discuss further

$250 USD dalam 6 hari
(7 Ulasan)

Hello Sir, kindly check PMB.

$100 USD dalam 6 hari
(8 Ulasan)

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

$150 USD dalam 7 hari
(2 Ulasan)

I couldhelp you

$250 USD dalam 10 hari
(1 Ulasan)

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 Lagi

$250 USD dalam 3 hari
(1 Ulasan)

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

$50 USD dalam 10 hari
(0 Ulasan)

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 Lagi

$250 USD dalam 5 hari
(0 Ulasan)

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 Lagi

$200 USD dalam 3 hari
(0 Ulasan)

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

$30 USD dalam 0 hari
(0 Ulasan)

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 dalam 10 hari
(0 Ulasan)