Access Database - Appt, Email & Text Reminder
$250-750 USD
Paid on delivery
We are a Point of Sale company. We are looking for someone to create a small Access database, which we can import into our current POS application. Below is a scope of the project:
This database must be able to connect to a SQL database, without having to install ODBC on each system.
1.) Form, which will allow clients to enter New Customers
2.) Ability to enter appointment times, by Employee
3.) Ability to Print a Report, which shows all appointments for the day, time and employee.
4.) Ability to Edit/Change Appointments.
MOST IMPORTANT ASPECTS BELOW.
5.) When the appointment is created, an email and/or text message shall be sent to the person who has the appointment.
6.) A Reminder, Email and/or text message sent at a "GIVEN" time, which should be specified in a stand a lone table for any appointments.
7.) Ability for those who have appointments to reply back to Email and/or Text Message with CANCEL in subject. Somehow, either by clicking and UPDATE button within database, download any CANCELLATIONS and update the Appointment schedule automatically.
8.) Print a report, which shows who canceled and new available appointments.
9.) We intend to bill clients per text message sent/received. We would need to calculate these text messages and have them sent to our office at the end of each month via email automatically.
I hope I explained well, if not please ask questions.
Rob
Project ID: #1317331
About the project
34 freelancers are bidding on average $501 for this job
Hello. We are a German company with a team of 2 dedicated professionals in developing MS Office applications based on the VBA programming. Please refer to your messages.
Extensive and verifiable Access, SQL Server, VSTO, VBA and Outlook Integration experience; please review PM for solution!
I've done several similar projects in the past. 15+ years with MS Access, VB, and C. Thanks for considering me. (m)
Hi This is interesting work. I can program this functionality. Would like to discuss some queries about this. Thanks Shawn
I have more than 4 years of experience in inventory management field. I am an expert in C# .NET. I can do this job for you.
I am Working in financial services so i have a good experience in to develop the different type of MIS and work with access database .I think i can handle this Project comfortably.
This is one of my core strengths and I have done several similar projects in the past.
Hi EasyPosSoftware, my first assignment was for me to really understand what you are asking for. I do understand it. I do not bid for project just for the fun of it but I do when I know I have enough leverage for t More
