Must completed in 5 days!
I need an ms access database that is similar to what a TAFE or small institution would run... Will list functions from most to least important.
Calendar system with the following views
Month Should show all "Bookings"(sorted by time, times dont need to be shown, just sorted by time)
Week Should show times Course
Day obviously show day times, a little more info ie. Trainer/ Teacher etc
If possible the Course should have a total number of Clients for it and when you look at the calendar it should show up in red for class full and green if there is still spots available, based oon the clients booked in to that class..
The Course booking form will need to be able to select/input the following information....
Course, Date, Time, Modules (module dates)(maybe a list box for this as multiple modules can be covered in one course on different dates), Trainer, Cost, Location Notes,
Then a Sub Form which has the client booking, cost, Letter sent(tick box), Invoiced(tick box), Confirmed(tick box), Payed(tick box)
At this point if you double click on the client a form should be displayed with the modules the course is covering the dates they are getting covered and how the client/student is going(Notes), At this point i invisage another list box populated with the selected modules on the main page, which then allows for the following, (Attendance), WB Received, WB Given, Ass received, Grade(Compitent, Not Yet Competent etc), Completed Date, Asessor.
This will need to be integrated and poolished off in a huge database i have allready created, in general the database could do with a little more cleaning up.
If possible the calendar also needs to be able to support Bookings/Appointments in general (Show up in different colours for different logged in useres/ trainers, if not too hard).
AS STATED ABOVE this work will be an extension on an allready existing database the entire project needs to be done/converted to 2007 and all round cleaned up, the bookings form and client results form will need to be simplish so i can change them later or worse case so i can get you to add things...
Reports need to be printed out for class attendance, client modules and there status, ie. assessed or no etc.
Would be good to have a rolling notes function and the clients data eaily accessible on the client page also.
Any work that is done will need to follow the same Naming conventiosn i have used otherwise it will get otu of control..
I dont have a huge budget im open to fair suggestions if you want to see what has been done so far in the database then email me and i can send it through.
Needs to be able to run on/in
MS ACCESS 2007 Multi User environment. ie Over a network