I need to create a form to track the attendance record of employees. Probably a datasheet in a calendar format allowing the user to enter holidays and sick days etc. I am sure this has been done before and I am wondering if there is a demo database out there which I could look at and learn from for my own design.
I tried this for my company a few times and tried to work with calendars for inputting information, but the calendars were always too small and impractical. Instead of using a calendar, I used a form for each employee and a sub form. You retrieve the record (form) for each employee, and you enter the information on the sub form. This would work similar to the Statements or Account receivable program I posted. I deleted the application because I have about 32 employees and entering the information takes a lot of time. What is your experience level with Access. Do you know how to make forms and subforms?
Thanks for the reply. I have got to grips with the basics, creating forms and subforms and learning as I go. Ifound this demo database on the internet which has an impressive looking form to keep attendance records. Take a look and let me know what you think. Ideally, I would like to create something like this.
Well maybe this is a bit late (I have only just joined the site) but maybe somebody needs to do a bottom line analysis - that is how the company is being hit in the hip pocket. Just simply timing someone entering all of the information for each appl…