Database Schema and vb code

See more:

VB

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]