Newbie>>>>>>>:'(please help asap

[Trumble990]

I am trying to create a database that tracks Employee's info,(clock number, Last name, First name, Address, Hire Date) and Attendance tracker so I can track (unplanned excused absences, excused absence and Floating Holiday) and their Weekly Production. Do I need a table for each week for production and a table for each attendance area such as Unplanned Excused, Excused, and Floating Holiday. Please help I have been working on this for about a week now and I am just about ot pull out my hair. I have a time frame to get this completed for my boss and it is looking very slim to none of me getting this completed............

 

[HiTechCoach]

Do I need a table for each week for production and a table for each attendance area such as Unplanned Excused, Excused, and Floating Holiday.

No. You do not want separate tables by type! You simply add a field for the type.

To get you started, see this excellent example:

Vacation Tracker

Hope this helps ...