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.
11 freelancers are bidding on average $72 for this job
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
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.