Closed

MS Access database

I need a basic access database built. In my company, my goal is to visit every business in Australia. I have 48 sales reps who will be starting work soon, out on the road. They get assigned a list of streets they need to go and visit (calling on businesses as they do so). Currently, we are just highlighting these streets in a refidex as we visit them.

What I want to implement is a system that once loaded with records, with each record to contain 'Suburb''Postcode''Count''UBD ref''Street Name', a user (sales person) could logon and generate a list of streets, by entering starting criteria of Street Name or Postcode. The generated list would include records ascending from the starting criteria, and the list would stop when the total value from the 'Count' fields on the combined records reaches 150. The 'count' field for each record is the number of businesses on that street... Also when a record has been already included in a report, it naturally cannot be included in any further reports that are generated - it just needs to be tagged as 'used' or whatever....

After the report is generated, it is emailed to the user based on their email address that was setup when their user login was setup. After the report is generated, it needs to be stored so that I can go back at any time and have a look at when a particular street was visited, and who visited it (which user generated the report).

The entire setup needs to be created in such away where the admin is the only one who can add and remove logins. The admin also needs to be able to view a list of all the reports that have been generated by users, and on what dates they were generated.

If you understand teh concept, please submit your offer AND TIME FRAME. Ignore my budget, I have no idea what this will cost.

Skills:

See more: sales reps australia, look for work in australia, do i need sales reps, australia it company list, admin australia, what is ms access, we value your business, were, user generated, understand, Road, postcode, ms access email, MS Access Database, look frame, i want to do a frame that i can, i need sales reps, goal, database no, database email, database c#, database australia, database admin, c# with access database, C# database

About the Employer:
( 0 reviews ) Logan, Australia

Project ID: #11168

11 freelancers are bidding on average $72 for this job

inavigator

We can do the same. But we required further clarification for the same. Please PM us with more detail to provide you the exact time frame with price.

$20 USD in 0 days
(33 Reviews)
5.0
dsendra

Count with me for coding this. I have 13+ years of programming experience and over 5 in ASP programming. This would cost around $450. Please see PMB for samples of my work

$100 USD in 15 days
(48 Reviews)
2.3
nidle

Dear Sir/Madam! If You are interested in top-quality work, please, consider our bid. Our company has been in programming and design sphere for years and has performed excellent results. Our experts can provide You with More

$100 USD in 21 days
(7 Reviews)
1.6
kashvi

We are 10 years old software and web development company and are in same professional with fully dedicated team.

$80 USD in 15 days
(0 Reviews)
0.0
sunita1234

Hello, We have wide area experience in open source technology like php/c++/linux/so files/fusebox AND WINDOW based ASP,COM,DCOM,MTS,VB,VC++,.NET,Flash Please forward me your mail ID so i can forward you project proposa More

$100 USD in 15 days
(0 Reviews)
0.0
vijendran

Edgeportal is an Information Technologies Solutions and service company that specializes in providing Turnkey solution to various organizations. We have highly skilled working on various technologies like MICROSOFT,Jav More

$70 USD in 10 days
(0 Reviews)
0.0
viaden

[url removed, login to view] got your idea. We can provide you EXACTLY WHAT YOU NEED!!! We have all the required skills to complete your project in the best way, so you can be abolutely sure, that you'll receive a top-quality result for More

$100 USD in 21 days
(14 Reviews)
5.0
jalaraminfotech

Respected sir i am good at MS-access and ASP so i can develop your application very well thanks for consideration your sincerely patel prathmesh k

$50 USD in 1 day
(0 Reviews)
0.0
geetha

I can complete ur work and submit in the given [url removed, login to view] forward to hearing from you geetha

$50 USD in 7 days
(3 Reviews)
0.0
intelligencei

Dear Sir! We are a team of high qualified and expirienced programmers and designers. We have reviewed Your project requirements and we are ready to start on Your project right now. Feel free to contact us 24x7. Regards More

$100 USD in 3 days
(146 Reviews)
3.4
simpleindia

Hello, We are a startup based in India, started by group of professionals. Cost will be $300. We can show you a demo of your application free of cost. We would like to hear from you. Prem Kumar.

$100 USD in 30 days
(0 Reviews)
0.0
SharkMan

Hi I can do this at a very low cost. Please read your private message. Thanks

$20 USD in 3 days
(3 Reviews)
0.0