Attendance System MS ACCESS

Question

I have 2 tables :

1. StudentInfo
2. Attendance

The StudentInfo table has fields about students like: RollNo, FirstName, LastName etc...

The Attendance table has the fields: RollNo, FirstName, LastName, InClass(Yes/No) and Date.

I want to duplicate the common fields from StudentInfo to Attendance and when I add a new entry in the StudentInfo table it will automatically add them to the Attendance table.

Also, when I add attendances in the Attendance table then I want to be able to view the data by months or dates, so that I can see on what day how many students attend the class.

Can you suggest a way for me to store attendance of students like we store on register, your help will be really appreciated!