Employee Tracking

[nycon]

Hello Everyone,

I'm new to this forum, and to Access. I've messed around and read a few books and now my employer has asked me to put together a basic access database to track employee performance.

We're a small security company and looking to have a daily report system for officers where they can enter number of tickets given, number of arrests, hours of patrol, etc.

I would like to have the option to break down the tickets into type of offence, ie parking, trespass etc, same with arrests so things like theft.



I just need a hand getting the design setup and then I can go from there. All officers are assigned an employee ID, and platoon, so I'd want a break down per platoon as well.

Any help would be greatly appreciated!

[TheShabz]

if this will be used to report or for auditing and legal purposes, I'd highly recommend getting professional help for it. not only would there be fewer bugs, but you'd CYA and be able to point to 3rd party professionals and lay the blame on them.

that being said, here's a breakdown of tables i'd use. you can figure out the joins.
tblEmployee
tblPlatoon
tblSchedule
tblOffenseType
tblCitation

if you'd like the structure and a few reporting queries done, message me and we can work something out.

[nycon]

Great thanks!

I'm going to get started on this and I'll for sure message you.

[NTC]

Basically you will have your core Officer Table. You will have a static list table naming the Offenses (so you don't have to retype it each time). And you will have an Action table.

The Action table will detail the ticket info, and the offense field will be a lookup field pointing from the Offenses table. Be sure to include a field for the officer ID - to cross reference to it.

Make a form and source it on the Officer table. Then make a form sourced on the Action table. Next in the Officerform - inset the ActionForm as a subtable. The wizard will step you thru it.

This is the core of what you probably need.

Hope this helps.

[nycon]

Thanks everyone for the information.
One other thing I should add is we would like to be able to do, weekly, monthly, and yearly stat print outs for reviews and such. I assume this is possible.

[jlicari721]

Oh man...I am looking for EXACTLY the same thing. How is the database coming along so far? I'd love a copy when you are done.

[jlicari721]

Any progress?