Employee Attendance

oxicottin

oxicottin

Learning by pecking away....
Local time
Today, 10:35
Joined
Jun 26, 2007
Messages
889
Hello, I searched for a sample database that would involve keeping records of employees attendance. I have no luck and was woundering if someone had such a database I could use?

Thanks,
Chad
 
There should be plenty of samples; "attendance" database isn't all that unusual. Or did you mean the samples you found didn't meet what you needed?

Maybe a little more detail will help us know what you need and point you to right sample?
 
I typed in "Employee Attendance" and "Attendance" in the search and didnt find many results. None of the results that were given had examples. Can you give me a link or some words I can type in the search to help me out!

Thanks,
Chad
 
You mean right here?

Did you try Mircosoft's website- they have templates; they may be useful.

As I don't know what exactly you need from an attendance, I can't give you a specific example. However, I've created a prototype for tracking attendance in a spreadsheet-like fashion. But this requires that you know VBA well enough to understand what's going on.

Here's the link.
 
Thanks you guys for the ideas! I have an attendence worksheet in excell as of now and I have been using for quite some time but I want to create a database that can store the information. The thing I like about the excel sheets are I can see the year for that employee. Is there anyway I can do this with access? I attached a sample of the excel sheet so you can see what im wanting to go off of.


Thanks,
Chad
 

Attachments

Pretty much anything you can do in Excel you can do in Access.
 
...with the understanding that you should *not* treat data the same way as you do in Excel to Access. This is a common mistake for people moving from Excel to Access (or any spreadsheet to any database, actually).

Be sure you know about normalization before proceeding.
 
Any ideas on how you would set up the forms, tables ect? Once I get started I wont have much trouble. My problem is how would I get started! I want to be able to see the entire year and thats my problem. How would I set that up on a form and be able to pull data from the tables for a perticular employee. I have built two databases so far so im sum what familliar with access. Any sugestions?

Thanks,
Chad
 
As a starting point, you will need an employee table and a attendance code table. Not sure on the calander structure, but do a search as I have seen some posts on the subject here
 
You must log in or register to reply here.

Similar threads

C
MySQL Server Question
Replies
7
Views
270
Pat Hartman
P
I
Create and training record database
Replies
8
Views
732
Pat Hartman
P
B
Expanding related tables and splitting database
Replies
10
Views
521
Pat Hartman
P
J
Need Help with Form
Replies
15
Views
694
GaP42
G
E
Repeating Details
Replies
11
Views
647
Pat Hartman
P

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Back
Top Bottom