How to make class register ms access

Asked By Denise Collins 30 points N/A Posted on - 11/19/2012

Please tell me how to make class register ms access way. Is there a template that can be used in MS Access that allows tracking of student attendance, to what class, and teacher? If so, where can I find them? Is it in the program itself or does it have to be downloaded?

• Status: Open
• Question Views: 882
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Storage

Answered By Eastern Carl 5 points N/A #163671

How to make class register ms access

Dear user,

For your class attendance register, I recommend you to make three tables on Ms Access, names of tables should be date, students and attendance. The students table should consist of the following fields/columns:

Student ID
Student Name

The values of the date table should be from 1-31. It does not need any field.

The attendance table should have the following fields:

Class Name
Date ID
Student ID
Present Yes/No

Hope this will help you.

Thank you.

About Eastern Carl

Questions
5

Answers
103

Best Answers
18

• Vote Up 0 Vote Down

• Posted on - 11/19/2012
• Question Category: Storage