How to create a roll call form?

[hesca]

Hello experts. I'm a newbie struggling to create a database for my keeping track of students. Im head of the deparment so the teachers report roll calls to me and I want to create a tool for them to enter this information into the database. BTW I have no programming knowledge whatsoever.

Here´s the question. I would like to know.. How can I create a roll call form? I want it to contain 3 things:
1. A list of the students registered to the course
2. A Y/N checkbox to mark them either present or absent, and another to mark tardiness
3. The course ID

I would like the form to start as a blank page with a courseID checkbox. After selecting the course ID, the form would pop up the student names' list with the checkbox columns from item 2. above.



Is it possible to achieve this using acess 2007 and without having to write custom code?

Here's what I have:

Tables:
a. Registered Students. Contains the names and the course ID to which people register.
b. Courses. A list of courses with schedule, profesor and description. The course ID field is contained here.
Relationship: One to many. One course, many students.

Thank you for your help!

[June7]

To accomplish this requires code. The code would have to create a set of records to input attendance info. This is not elementary!

Review links in this thread https://www.accessforums.net/access/...nce-20899.html
They don't address student attendance specifically but discuss techniques needed to do what you want.

These have a database attached you might find interesting
https://www.accessforums.net/access/...how-21378.html
https://www.accessforums.net/access/...ead-13292.html