To create students attendance form in access 07

[sachuchem22]

Hi ...
i want to create students attendance form in my students database in which there are tblstudent having fields like student name .Roll No. Std. Div. etc . please help how to do it?

[nico5038]

Very basic question with little to advice on. I would start with creating a tblAttendance table and have a "template" table (e.g. with class dates) to use to append attendance records, as multiple students will have the same classes they need to attend...
Having created the design, the forms will automatically follow...

Nic;o)

[sachuchem22]

Thanks for rply but am new user of access so please can you explains in detail and stepwise .

[nico5038]

Start with creating the needed tables: tblStudent and tblAttendance and add the needed fields like Class, AttendedYN, etc. and think about the unique key that's needed.

Nic;0)

[sachuchem22]

Thanks again..
I already having tblstudent with fields Student Name. Roll No. etc and i am thinking Roll no as unique key. so what is nest stepe.

[nico5038]

What does Roll stands for, enrollment for a course ?
The there needs to be an enrollment table, as a student can apply for multiple courses.
This table will need an enrollment id and the student id also the properties of the enrollment will have to be added, like startdate, number of hrs/days/weeks, etc..

Nic;o)

[zmbd]

sachuchem22
Have you taken a look at:
MS Templates - Students Access database template
It's a very basic example that may do what you are attempting to create "in-house."

++ Of Note: the Collect data through e-mail feature may not work in the newer versions of Access starting in Access-2013. If this does give you issues let us know and we can help remove the feature.