The company that this project is needed for is a small service related company. We have about 5 people on the road daily. I have a new secretary that is not familiar with our area and she can't schedule appointments very well. I need to be able to have her take information from the customer and hit a button to run a macro and show her available times and dates that we could be there. I have an existing MS access database that I created about 7 years ago. We have a lot of information in it. It is almost 2 gigs right now(critical mass for access).
1. The results she can offer to clients based on counties and or zip codes(knowing distance from one to another). Also preference based on current route.
2. A window that will pop up that she can just push the button when the customer selects the date and time.
This database is very large and because of my lack of technical skills all of the information to be used is from one table(bulk of space used).
Looking for client with a lot of MS Access experience. This is just the start of what I would like done with this database. More work will follow.
An example would be that we have appointments for 1 person at 8:00am, 9:00am and 12:00pm on one day and based upon the distance from each location maybe 10:30am would be best. But it would give options for all the times available for that day and maybe two more days ahead. Then if the client wanted it for the following week we could choose "next week" or something similar.
Please describe or submit examples of similar work you have done.
Looking forward to working with someone well qualified.
10 freelancers are bidding on average $605 for this job
sir, i can do this for u, i have read ur project description. i have done a lot of work related to this project. i will send u a demo very soon. thanks. with best regards. saif