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:
1.Have 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)
2.once 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)
3.reports 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.