Create an application with access to manage the appointment for a charity organism and be able to generate reports based on the type and the number of appointment by week, months and years.
This association help people giving personal services like friend visit, accompaniment for medical appointment, etc..
We need to add / remove client, volunteers, appointment,
Should have 1 table for clients with the following column :
Nom : texte
Prenom : texte
Adresse : texte
Telephone : texte
Email : texte
Service required (drop down list with following value : VA, VC, PI, ACC, ADM, FI, FE)
Statut : Actif or Inactif
Contact : texte
language : texte
1 table for volunteers :
Nom : texte
Prenom : texte
Sexe : list : H or F
Adresse : texte
Telephone : texte
Email : texte
Membership date : date
Statut : Actif or Inactif
Contact : texte
language : texte
Forms appointment should contain :
To add an appointment we need to select :
the name and fistname of the clients
the date and hour of the appointment
service needed : VA, VC, ACC, PI, ADM. FI or FE
location : texte
commentary ; texte
the volunteer assigned
the status : completed or not yet
Also if the service needed is VA the appointment should be recursive once a week until the end of the current year.
We need to have a forms for reporting containing the number of service done by week, month and year and the number of hour by services.
VA = 2 h
VC = 3h
ACC = 4h
PI = 1h
We need to be able to send an email to all the volunteers actif with outlook, using a button in the forms or something like that.
For ADM, FI, FE, need to have a field duration include in the appointment forms to specify the number of hour.
Hi, I am a developer with over 22 years experience building complex database systems, specialising in the development of applications in MS Access using VBA and WinAPI. I could do this project to your specification within a short time frame. Please view my portfolio for some examples of my work.
Dear Sir, For this purpose, I would suggest a custom made .NET application with a nice GUI as front-end and an Access database as back-end. This has huge advantages compared to programming everything in Access. See my portfolio for an example (PDCA Database). Kind regards, Scubapro.
Hello, I can develop your application. I'm a Freelance With 10 Years of Experience In Developing Applications On Ms Access For Small, Medium And Large Companies For Public And Private Sector
We are an India based software outsourcing company with years of experience in mobile and web application development. We deliver a full spectrum of software consulting and development services with a rich and varied experience in providing offshore software development and project management capabilities. Please check PMB for more details.
Hi, I have over 16 years of experience in design, development and implementation of software projects using VB6, VB.NET, MS SQL. I also have expertise in developing reports based on Crystal Reports and SSRS. I can assure you that I can complete the project as per your requirement in 5 days. Thanks & Regards, Shiva
I used to build an application for a Karaoke that charge by hour by using Microsoft access. They are using it until now. So, I have confident to complete your project in 7 days.