Click here to Skip to main content
14,869,829 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hey Guys,

I want to create a database which i want to track pupils for a period of years for a particular school.

I have the fields but dont know how to start. The fields are

Division,District,District Code,Zonecode,zone,School,SchoolCode,Surname,firstname,Year, Code(district,school,pupil),Pupil code, Sex,Age,Repetition,Class,Number

                     Repetion Level
Class   New Entrant  First Repeater  Second Repeater
1        2012         2011            2010
2        2011         2010            2009
3        2010         2009            2008
4        2009         2008            2007
5        2008         2007            2006

The logic is a Class 1 pupil in 2012 is a new entrant, a Class 1 pupil in 2011 is a first repeater, a class 1 pupil in 2010 is a second repeater.

Would you please help me with the database schema, and a vb code and a data entry interface

[edit]Code block added - OriginalGriff[/edit]
Updated 13-Apr-12 0:49am

1 solution

We do not do your homework: it is set for a reason. It is there so that you think about what you have been told, and try to understand it. It is also there so that your tutor can identify areas where you are weak, and focus more attention on remedial action.

Try it yourself, you may find it is not as difficult as you think!
If you have a specific problem, then by all means ask about it - but do not expect or ask for the full code for anything!

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900