Linking a set of dates for a time sheet

[Anthrax]

The project I am currently working on requires me to build a database for checking off if a certain person has submitted a time sheet for a certain date.

I have a table for the dates that has the fields "date" and "Submitted time sheet?". The time sheet field is a checkbox.

I also have a table for employees with fields "employee last name", "employee first name" and "location".

What I want to know is how to link each employee with the dates and whether or not they submitted a time sheet.

I have yet to figure out a solution that does not result in a horribly normalized database.

 

[Anthrax]

That was helpful in getting a few things sorted out but I'm still confused as to why I don't need the Boolean field. How would somebody mark whether or not a persons time sheet was submitted?

EDIT: never mind after looking at it and inputting data I understand why. Thanks a lot.

 

[Anthrax]

One more question, how do I get historical dates to show up so I can input old data all at once?

What I mean is that its more rare for an employee not to submit a time sheet so I want it do default to showing up as submitted.