Design a timesheet application

[Trevi]

Hi all,
I would be interested in designing timesheet application in Access, is that possible? That would be for NGO purpose.

- selection of country of the employee and then relevant bank holidays (taken out of the database)
- possibility to select his/her workload
- enter monthly salary (for employees) or daily salary (for freelancers)
- no need to enter time in, time out, lunch out, lunch in. We work only with days.
- possibility to split salary among donors (e.g. 20% of salary goes under Donor 1, 80% goes under Donor 2). 20% means 40 days a year, 80% means 160 days a year. Person would assign every worked day in month to the specific donor. There will be a counter of already assigned days to all donors (in October you can see: 30 days already assigned to Donor 1, 10 days still left etc.)


- application would be calculating salary - only for daily rate people (number of worked days x daily rate)
- possiblity to enter extra working day (Sat, Sun) which is then used as a compensation day
- print capability with all details

Is that possible in Access? If yes, could this app would run somewhere on server (like file server) and people would access it entering the IP address?

Thanks for any suggestions

[TheShabz]

To answer your question, yes. it is possible. what you would do is create the database and the forms and code, split the db, put the backend on a network drive and give the frontend to your users.

There are some free php timesheets apps available online. a google search will get you plenty of results. I think youd be better off with something like that. php front end connected to a mysql db back.