How to make this Database?!

Have a table called STUDENT which contains fields for
StudentID
strFirstName
strLastName
and what ever other information you need about the student
and another table called DATEABSENT which contains fields for
StudentID
dteAbsent

In STUDENT, StudentID would be the primary key. In DATEABSENT, StudentID and dteAbsent together would be the primary key. StudentID would be a foriegn key referencing the StudentID in the student table.

When a student is absent the date would be entered into the DATEABSENT table by adding the StudentID and the date. A table join could be used join the information together such as:
Select STUDENT.*, DATEABSENT.DteAbsent from STUDENT, DATEABSENT where STUDENT.studentID = DATEABSENT.StudentID