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.
Thanks Access Guy.
Actually the "databases" I have used Excel for were fairly simple tables and not relational. If relational I would have immediately switched to Access. I have just left a construction AUS$80M Admin job where the payments were d...
Absolutely. Your interface for data entry must follow the users workflow. It should lead them through the process according to sequence data is accessed and sequence data is read from documents etc.
If possible, create your interface so it treats...
Hi Stephanie
After resisting for some time, a client has now pushed the issue and I have only recently converted a 2003 database to 2007 and still discovering.
It is very different to develop in and some things are missing, which you are probabl...