We are a business that requires a MS Access Database for keeping track of our weekly routes.
At present we are use excel to print off route sheets. We have over 130 customers and about 7 routes 4 days a week. Here is a few example of what we are trying to do:
-to query what route a customer is on and what days they are getting service its very time consuming as each spread sheet has to be searched
-to change a customer to a different route
-to use with maps to see where to place new clients
-To de-active clients
We would like a MS Access data base to do the following:
[url removed, login to view] a entry form for new/existing customers with all their details, with this form we can select the delivery days of the week (Mon-Sun) and the route number it is to go on each day (route may change daily)
[url removed, login to view] this has been entered this information should then be able to create route sheets similar to the ones they are using now so we can print them off daily.(we require the drivers to write in information on route sheets)
[url removed, login to view] that shows me my profit margin for the routes.
4. The ability for my workers to log in to just their routes and print a list.
5. The ability for the workers to log hours.
We can go into more details when we start - Thanks
Please see the attached excel run sheet.
38 freelancers are bidding on average $228 for this job
I have gone through the attached excel sheet.Do you have some graphical interface design in min or i can make my own ? Please provide report formats. Which Ms Access version will be used for development ?
Hi This is Piyush Patel I have 8 yrs of Exp in VBA,VB6,VB.net,SQL and MsAccess. I have developed many applications in VB6,VBA,VB.NET. Please Check My PM