How do I make a weekly attendance roll for my database?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to make an attendance roll for the people in my database each week, so
that the list of people can be ticked off if they are present, and the
information can then be stored in the database so reports can be printed, etc
without the data being accessable to manipulate.
 
You will need to set up an attendance table. I am assuming you want to
take attendance each day, but show it on a weekly basis?

*Attendance*
AttendID, autonumber
EmpID, long integer -- FK to EmpID in your emplyees table
AtDate, date

Once you have the basic structure set up to hold the data, we can
discuss designing forms for input the way you want to see them

You can either:
1. add a yes/no field in Attendance to mark if they are present or not
OR
2. only record employees that are present in the table

depends on how you want to use the data down the road...


Warm Regards,
Crystal
*
(: have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Attendance Data 3
How do I create an attendance register for those present on a date 2
Attendance Register 1
How do I invoice a cost to a custom built MS Access Accounting Database? 0
Attendance Tracking 5
How to properly record attendance? 3
Design question for attendance sheet 5
HOW DO I TRACK ATTENDANCE 2

Back
Top