Find Jobs
Hire Freelancers

reporting and tracking for large mailorder database

$250-750 USD

Cancelled
Posted over 13 years ago

$250-750 USD

Paid on delivery
We have an access database with 140,000 entries, and 10 fields (name, address, etc). We send 2 mailshots every year and then depending on the response need to make the following entries into the database with a FAST and EASY method: # Purchase (record paying customer and payment method) # Kept Goods (record non-paying customer and schedule reminder) # Returned Unwanted (customer did not want goods) # Returned Wrong Address (customer needs to be removed from the database) Our company also needs to start tracking these returns for the database over several years. We imagine a barcode tracking system to speed things up but we would need advice on how to implement this. There is no reason to keep an access database if another system like sql will do the same job. Creative solutions are required, and good english required.
Project ID: 879084

About the project

19 proposals
Remote project
Active 13 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
19 freelancers are bidding on average $602 USD for this job
User Avatar
Hello plz check PMB for details.
$750 USD in 20 days
4.8 (73 reviews)
7.8
7.8
User Avatar
Hi sir, Please check PM for more details, thanks, kimi.
$750 USD in 15 days
5.0 (231 reviews)
7.2
7.2
User Avatar
Hi, I have more 10 years experience in MS Access and SQL server, so I'm realy GURU in this. I can help you with this project. Best Regards, Alex
$750 USD in 10 days
4.9 (23 reviews)
5.4
5.4
User Avatar
Please look for live demo in PM
$500 USD in 10 days
4.9 (19 reviews)
4.7
4.7
User Avatar
Respected Sir, Please see PM for details. Kindest regards.
$500 USD in 0 day
4.8 (16 reviews)
4.5
4.5
User Avatar
Plese check PM
$750 USD in 20 days
5.0 (1 review)
3.8
3.8
User Avatar
Let me DO IT....!
$450 USD in 10 days
4.5 (13 reviews)
3.7
3.7
User Avatar
I am a professional MS Access Developer with more than 10 years experience. Please see you PMB for bid details.
$750 USD in 15 days
5.0 (2 reviews)
3.3
3.3
User Avatar
Please check PMB
$500 USD in 15 days
4.8 (3 reviews)
3.3
3.3
User Avatar
Hi there, I am a professional programmer and very keen to do the job. What you need is a typical application for data mining and I developed a series of similar applications n the past. I am absolutely keen to be put in a position to help you in this. Regards
$480 USD in 2 days
4.7 (2 reviews)
2.7
2.7
User Avatar
Please Check Private Message .
$600 USD in 20 days
5.0 (2 reviews)
1.9
1.9
User Avatar
please check your PM
$550 USD in 20 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Access is still the correct tool, but you should use Access ADP (Access Data Project) that connects directly to a MS SQL Server database. This will provide all of the power and flexibility you should ever need. I created an Access-ADP/SQL Server solution for a small chain of grocery stores that allows them to track direct store delivery receiving as items are unloaded from the truck. As items are taken off the truck, they are barcode scanned; this process automatically creates a receiving record by auto-populating important fields by retrieving data from a remote master POS database. The Access application can be installed on a tablet or mini laptop (or any laptop), and the barcode scanner can be wireless. Using a MS SQL Server backend database will provide powerful reporting and statistical analysis capabilities. The free version of MS SQL Server now includes SQL Server Reporting Services. I have 15 years of experience with Access and 11 years with SQL Server. I would like to point out that it is very easy to underestimate the complexity and scope of a project such as yours. My MS Access experience covers everything from complex, multi-user distributed (front end – back end) applications, to quick, disposable, ad hoc utilities. I am proficient in Access SQL and VBA, so I am able to code complex business logic and create very intuitive, easily-navigated user interfaces. I also have extensive knowledge of Access ADP (Access front end, SQL Server back end) applications. Many of my Access databases have been in daily use for years without any serious problems. As a data modeler, I know how to create a data structure that is flexible and able to grow and change along with your business requirements. My Access user interfaces are intuitive and designed for easy, stream-lined data entry. I also have the VBA coding skills to make the user interface as user-friendly as required. Access is also my favorite report writing environment, so my reports compliment the data structure and the user interface. Follow up support for my client is something I take very serious. The manner in which I design and document a project enables me to quickly provide technical support and revisions, even after years of separation from the project. My work and availability schedule is very flexible and accommodating. Numerous references and samples of my work are available upon request. A full guarantee accompanies all of my work, and my clients are not expected to pay for anything they are not satisfied with. Remote collaboration has been very successful using Remote Desktop, GoToMeeting and GoToMyPC.
$750 USD in 14 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have over 30 years of experience.
$400 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
We developed and implemented systems like that for a postal operators.
$700 USD in 30 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello Sir, Please check PMB for more information. Thanks!
$600 USD in 30 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi there, experienced .NET Developer and database admin here. I have a good proposition for you, please check PM for info.
$300 USD in 25 days
0.0 (0 reviews)
0.0
0.0
User Avatar
please see PM ^^
$660 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
hi I have ten years experience on MS Access. I have done ten Access DB for client in 2010 also I have five years in MS Access 2003 and Access 2007 I am sure I can do it well. Let us start now. look forward to your reply. Btw: I were MVP about Mircosoft Access in 2003 Zhi Zhang
$700 USD in 10 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of PAKISTAN
karachi, Pakistan
4.8
84
Payment method verified
Member since May 28, 2007

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.