Employee Database

[smudgedwhiteink]

Hello,

This one is in need of some serious detail - PLEASE HELP.

Well, I am quite fluent in Excel, as after university, it is what I have
focused on. However, I recently started working for a company as office
staff, and have realized that they have nothing for an employee database. I
would like to put together an Access database (correct me if I am wrong, but
I figured this would be the most reasonable of Office programs seeing as I
would like to include an array of information on each individual employee).

What I would like to do is, for each employee (between 150-200 of them),
have information on "personal information," "certificates/experience,"
"payroll information," "leaves of absences." I would like it orgainzed it in
a fashion that it is all searched by employee number which is 4 capitalized
letters for each employee (EXAMPLE: Jane Doe - DOEJ). I would like this to
be fairly visually appealing as well, as it will be used by multiple office
staff throughout.

I am not sure that this project of mine is out of my league, but I have
time, and I would like to tackle it. I just need some majour help!! The
company is not willing to spend money on a pre-made employee database, and I
do have somewhat of computer competency - it just really hasn't been in
access. I am up for a challenge! If you are too - YOU'LL HELP!!

Thanks,
Accessively Confused.

 

[Arvin Meyer [MVP]]

I am not sure that this project of mine is out of my league, but I have
time, and I would like to tackle it. I just need some majour help!! The
company is not willing to spend money on a pre-made employee database, and
I
do have somewhat of computer competency - it just really hasn't been in
access. I am up for a challenge! If you are too - YOU'LL HELP!!

I'm sure you'll be fine with a little bit of help. That's what we're here
for. I can't help wondering though, if the management of your company is
using resources wisely. Unless they are paying you a pittance, or you have
nothing else important to do, it would be cheaper to hire someone who is
knowledgeable, and even cheaper to find something in a box. Be that as it
may, you may want to develop your Access skills, build a nice program, then
move on to a company with better management.

At any rate, ask away. We'll be glad to help.

 

[smudgedwhiteink]

Okay, well thank-you. I have the basic structure down for the databse. I
have created a form for each employee with the EmployeeID as the key, and
mutiple other fields for misc information. I just would like to incorporate
into the form a absense recorder. There are different types of absenses that
the company tracks for each employee including but no limited to sick, awol,
wcb, etc... They would like the date in which the ansense was incurred. I
don't know how I might do this. Any suggestions. Please answer this
question with as much detail as possible, as I am a newbie!!

Note also that I would like to be able to print out all the absences for
each employee if I need to... there has to be a visual somewhere!! (I know
this can be done through quering and what not I suspect)

Thanks,
Accessivley Confused.