Project Detail

Urgently need MSAccess scripting

Urgently need MSAccess scripting is project number 227501
posted at Freelancer.com. Click here to post your own project.

| More

Status:

Selected Providers: ragavendram

Budget: $30-250

Created: 02/18/2008 at 20:19 EST

Bid Count: 13

Average Bid:
$ 129

02/23/2008 at 20:19 EST

Project Creator: hooman7 offline
Employer Rating: 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 (6 reviews)

Description

This is a very simple project and I need it finished very very fast. I have an Access database ready with tables already designed and data populated. You will simply be formatting the data using queries and creating a CSV output file. There are various changes I need done to the existing system to make it more versatile.

Objective
This is an application that will be used in the telecommunication industry. Your objective will be to take various sets of pricing/vendor data and transform the information into a format that can be outputted as a CSV file.

Description
When a customer sends us a call over the internet, a switch decides which vendor to send to call to based on price. The switch will attempt the cheapest vendor first, if the call does not answer, the switch will try the next cheapest and the next until the call is completed. The switch can attempt up to 8 vendors before it gives up. Each vendor provides us a list of routes with a rate for each route. The switch does a digit match based on the first 7 digits of the number being called. For example, if the switch receives a call to 12148761404 it will look for a match in the system which would be 1214876. It then sends the call to the cheapest vendor to be completed. This system of sending calls to the cheapest vendor is called Least Cost Routing or LCR. In order for the switch to know how to route the calls, it requires that an LCR file be imported. Because there are anywhere from 50,000 to 150,000 routes per vendor, this task cannot be done by hand. An MS Access database has been prepared with all the rate and vendor data populated. You will only need to modify an application within Access to query all the rate tables and create various LCR tables.

Additional files submitted:
Project Spec.doc

Report Violation

Job Type

See more: access, application, call, csv, customer, data, database, file, list, make, match, ms access, number, project, rate, routing, simple, simple project, system, task

Messages Posted:1

If you are the project creator or one of the bidders Log In for more options

PMB

100

3 days

02-18-2008 23:12 EST

9.5917/10
(120 reviews)

We can do it

shmai online

250

5 days

02-19-2008 04:27 EST

9.7766/10
(94 reviews)

have a glance at PM. Regards,

HussienSharaf offline

200

4 days

02-19-2008 16:04 EST

9.9767/10
(43 reviews)

HI, i m the best VBA/MS Access programmer . i have designed and implemented many successful DB systems on MS Access. plz check PM thanks

mingon offline

100

3 days

02-19-2008 00:15 EST

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(19 reviews)

I've got a great experience in SQL and VBA. I can do this project. Regards, Sergey

wsh2 online

229.95

2 days

02-19-2008 09:55 EST

9.9412/10
(17 reviews)

Greetings Texas from the Keystone state of Pennsylvania.. {smile}. Texas writes: "There are various changes I need done to the existing system to make it more versatile." Silly question of me, but what makes you think that from a database programming standpoint these changes are "simple"? Particularily when you consider your need for data key padding and Outlier rate analysis. You Texans never cease to amaze me.. {smile}. Hello my name is Bill.. I am a MsAccess, MsExcel, VB.Net, VB6, VBA, VBScript, SQL, and Windows programming Expert, Leader and Mentor [screenname:wsh2] at www.vbcity.com and www.experts-exchange.com. I have successfully completed quite a few GAF projects, so you can find additional references for me here: http://elance.com/users/feedback_172391.html I have 20+ years of hands-on Programming and Business Information System experience to include Internet interfacing applications. I have a BS in Accounting / Marketing Minor; graduating with the highest of honors. I am located in Easton PA USA (halfway between Philadelphia and New York City). American english is my only language. I look forward to assisting you in achieving ALL of your goals in your every endeavor. Respectfully, Bill.

rnari offline

100

1 day

02-19-2008 02:02 EST

6/10 6/10 6/10 6/10 6/10 6/10 6/10 6/10 6/10 6/10
(2 reviews)

will it finish today.i have lot experience in such jobs. regards, rnari.

BDIIT offline

2 days

02-19-2008 03:31 EST

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(1 reviews)

Im an access programmer and like ot do this for u..

mragavendra offline

170

2 days

02-18-2008 23:52 EST

(No Feedback Yet)

Hi, I posses 5+yrs of experience in VB6,VBA, Excel, Access, Word, vb.net,RDBMS(SQL Server, Oracle) and sharepoint technologies. I have a sample of work for similar kind of project. I can do this job. please ask me for more information to know more about my capabilities and qualifications. Please reply me to my yahho id to get sample of work, since I am not able to upload the same here. my Yahoo IM Id : ragavendra1108 (at) yahoo.co.in skype id : ragavendra1108 msn : l_manju Awaiting your response. Thanks Ragi

Rayzweb offline

1 day

02-19-2008 05:55 EST

(No Feedback Yet)

I can do this project for you very easily thru VBA programming itself. The task is so simple. I can send the converted CSV file within 8 hours of duration. I'm sure!!! Please send the database to me Thanks in advance, With Regards, Rajesh M rajeshwebmail 'at' 'geemail' 'dot' 'com'

ragavendram offline

170

2 days

02-19-2008 12:55 EST

(No Feedback Yet)

Hi, I posses 5+ yrs of experience on VBA, VB6, Access, VB.net, SQL Server, Programmer. I can do this job. Thanks Ragavendra

svarogg offline

100

2 days

02-19-2008 13:54 EST

(No Feedback Yet)

Hi. I'm an Experienced SQL/Access programmer, and can do this job easily. Please check PM.

ICoder3000 offline

100

3 days

02-19-2008 14:46 EST

(No Feedback Yet)

I Can Do the Job for u

zenonfly offline

3 days

02-19-2008 20:39 EST

(No Feedback Yet)

Hello Sir, I have more than 5+ Years of experience in Developing and Testing web based and desktop Applications so I can do this job offering you a better quality of work. Thank You Darshan

Bid on this Project

WHAT IS FREELANCER.COM?

Freelancer.com is a global outsourcing solution and freelance jobs website. Here you can find freelance coders, writers, programmers, designers, marketers and more. You can also outsource projects and save a lot of money in the process. Getting the best web design, professional programming, custom writing or affordable marketing has never been easier!

We have thousands of satisfied clients from every corner of the world. Would you like to outsource your next project? Would you like to find freelance jobs and make money online? Just sign up to get started! Outsourcing jobs is the process of hiring an outside company or individual to complete your projects. We have created a safe environment for both service buyers and service providers via our secure payment system. You outsource the project and don't release any money until you're satisfied! Try outsourcing for free today! Don't forget to bookmark our homepage for your next project or job.