Find Jobs
Hire Freelancers

Access and Vb project

$30-100 USD

In Progress
Posted almost 18 years ago

$30-100 USD

Paid on delivery
MS Access/Visual Basic Project to provide import, entry and analysis of property information. I purchased the Auditor's database for my county in Ohio. I received approximately 3 dozen text files. The majority of the data I require is included in less that a dozen files that are all linked by the Property Parcel ID (there are less than 90,000 properties in the county). I've loaded some of these files into MS Access but need the project completed quicker than I can do it myself. Specifically my project will be to: 1. Load the remaining data into MS Access Tables - I have file layouts for the tables. Key and index structure to be discussed. All data must be stamped with the extract date from the county. 2. Create relationships that correctly link the data via key values. 3. Build lookup tables for code values in the base data tables and correctly link them. The lookup value information is provided by the county. 4. Create data manipulation queries to load working tables required to analyze the data. 5. Create a form interface to: a. Perform Database Maintenance - purge data based on extract date and import new data when I purchase another update from the county. b. Query the data based on selected search criteria. Criteria will include information about the property, the owner, the value, the tax situation, sales history and other related data. Form must also provide the ability to select which fields will be output and the form of the output (data list, report or export to Excel). c. Link marketing activities associated with properties and owners. Specifically, to document mailings and other contacts with the property or the owner. Forms must allow the creation of marketing activites and permit their linking to properties and owners via selections which return one or many (similar to the reporting interface). When I mail to 1,000 owners I want to quickly link the marketing piece to the property/owner via a mass update. I also want the ability to quickly assign a followup activity w/ a specific date. 6. Create two standard report templates - one portrait and one landscape - to be used foe outputting data. Correct format must be used based on the ouput selected by the form interface. 7. Create reports to document marketing accomplishments (completed) and planned tasks for a day, week, month, etc. 8. Provide the ability to load and store photo images of the properties into the database. for complete requirement details, check the attached file.. NOTE: plz dont bid if you cant complete the project within 7 days after your selection and maximum i'm willing to pay $50 (project is simple enough for an expert, just its bit long).. Thanks
Project ID: 52315

About the project

17 proposals
Remote project
Active 18 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

About the client

Flag of PAKISTAN
faislabad, Pakistan
0.0
0
Member since Feb 27, 2006

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.