New Database

[lindaclark30]

I am new to using access but would like to learn more about devbeloping
a database for holiday and sickness records. Does anyone have a copy
of a database that would help record the number of days outstanding for
an employees holiday entitlement.

Thought I would be able to learn more about using access if I could
have a look at a database that was already set up to record the holiday
and sickness records of an employee in order to give me a better
understanding of how working with access.

Many thanks

 

[Ed Warren]

I have written several of these for clients and this is like taking up cliff
diving because you want to learn to swim!
Here are some comments

1. You need a set of tables that track employees (employeeID,
employeeFirstName,EmployeeMiddleName,EmployeeLastName,Employee......)
2. You need a set of tables that track the employees employment history
(EmploymentID, DateStart,DateEnd,Position, Other stuff depends on the
situation)
note: employees come and go then come back and some companies will
let them come back with some portion of their leave in tact others will not.
3. You need a set of tables that track the employees leave usage
(employeeID, LeaveUsageID, date, type,length of time)
note: some employees work on number of days (don't allow 1/2 day)
others work on Hours basis.
4. You need a set of tables that track the types of leave you will be
following (e.g. LeaveTypeID, LeaveTypeText)
note: simple examples are sick leave and annual leave but I have run
into things like educational leave, family leave, reserve training leave,
etc. ....
5. You need a set of table relationships that tie all above together to
maintain data integerity.
6. You need a set of VBA code that caputures the "Business Rules" for the
award, removal, carryover, etc of leave.
7. You need a set of forms to fill in all of the above
8. You need a set of reports to print out the information like leave
statements for the individuals etc.

Note within one organization I work with I have five different versions
running because they have different rules for leave in each department (it
is up to the department head how he/she interperts the rules).


I hope the above will give you a starting point, you may be able to simplify
your specific application enough to build something to start with. I do
encourage you to jump in and build something. Access is simple and
complicated at the same time. I had to jus start with something I wanted to
build, build it, then start over with what I had learned in the process.

Cheers,

Ed Warren

 

[lindaclark30]

Thanks Ed,

Thought I had chosen something simple to start off with but looking at
your reply it seems much more involved that first envisaged. Have
got some tutorials from our local university which may also help me,
but I will plug on and hopefully will learn a thing or two on the way,
like you say will probably start over once again after I have learned a
thing or two on the way.


Regards