CHAPTER ONE

INTRODUCTION

1.1 General overview

The society has turned to be a complex structure that changes every

day. Computerization students results takes a unique and bold step to look

at virtually all aspects of documentation of students records in our

institution of learning. Our concern here is to evaluate the role computers

will play in enhancing proper documentation of student’s record with

special emphasis of student’s results.

Furthermore, this research attempts to look at the method in existence of

collecting and documentation student’s results as an unavoidable fact or in

enhancing the schools performance in ensuring proper documentation. In

other words it involves, analyzing the existing system that is system

analysis and designing new system for college that will be very effective

and efficient in processing the result in the college. The various offices or

officers concerned with this records will be properly examine the determine

some of the independent being faced by them in keeping the students

records using the existing methods.

This however, becomes important since in the final analysis. The findings

of the study would offer sufficient explanations as to how best the school

1
can forge ahead in meeting the task of keeping proper records of students

result and to sensate the authority on the need to computerize student’s

results.

1.1HISTORICAL DEVELOPMENT OF FEDERAL SCIENCE

COLLEGE SOKOTO.

Federal science college Sokoto was established in 1991/1992 academic

session be the federal military government of General Ibrahim Badamasi

Babangida {retired} through the federal ministry of education.

The new since college established inherited from her parent’s mother;

former federal school of Arts and science, a number structure/ materials

which includes staff.

The establishment of federal science college in 1991/1992 academic session

was prior to the changing of the Nigerian education system from the five

years of post primary school {secondary school} to 6 years post primary in

consonance with the current 6-3-3-4 educational system now in operation in

Nigeria.

The first principle of the newly established federal science college

sokoto was and still a well known and foremost Nigerian ac academic

veteran, seasoned administrator father and disciplinary Mr. A.H.U.E.

Ejembi who was transferred from the former federal school of Arts Aba

2
{now Abia state} to establish the new federal science college in sokoto in

the choice of him by the federal government of Nigeria to be the man to

establish the new federal science in sokoto may not have been if not for the

above qualities coupled with his experience as a good manager of both

human and material resources.

Under the headship and leadership of Mr A.H.U.Ejembe as the principle

of the newly established federal science college the college saw a number

of major and minor re-organization in most of the materials inherited.

3
 DIAGRAM OF HIERACHY
PRINCIPAL

VICE PRINCIPAL VICE PRINCIPAL {ADMIN}

ACADEMIC STAFF LIBRARY GUIDANCE

NON-ACADEMIC STAFF

TRANSPROT KITCHEN CLINIC UTILITIES TELEPHONIST HOUSING STORE SPORTS LABOUR

ELECTRICITY WATER

4
THE DUTIES

 Principal {chief executive}: is the overseer of the school and control

those working under him or with him to see that the school meets its

required standard.

 Vice principal Academic: he is directly under the principal with the

responsibilities of handling issues relating to the success of the

students.

 Vice principal Administration: is also working under the principal

control the non academic staff to make sure that no working is left

undone, gets information from them and take it to the principal for

solution.

 The Bursary: he is responsible for handling the financial aspect of the

school {controlling income like fee; paying the workers and given out

money for purchase of goods}

 Academic staff {Teachers}: They are responsible for impacting

knowledge to the students.

 Liberian: He/she ensures the proper record of the books in the library.

 Guidance counseling unit: These peoples take issue concerning the

external exams. They prepare the information gotten from the students

5
 and give them the necessary advice they needs about any external

exams they may want to take.

 Transport: this has to do with the movement of the students and staff

from one place to another.

 Kitchen: the master in the office make adequate arrangement for the

provision of food stuff and proper feeding of the students.

 Clinic: the health care or the nurse takes proper care of the students

and staff as regards to their physic al health.

 Utilities: this base on both electricity and water supply to the college.

 Telephonist: there most be adequate means of communicating within

and outside the college.

 Housing: the house master provides rooms for the students and staff.

 Store: this is where the food stuff is kept with other important goods.

 Labor master: Ensure that the school environment it kept clean at all

time.

 Sports: this involves the students and some time the staff participating

in games within and outside the college.

SECURITY AND RELIABILITY

6
The system can save data after processing which no other person can come

in to contact with it without knowing where it was save and how it is save

and can copied in to a diskette.

1.2 DIFINITION OF TERMS

 System analysis: This can be defined as the process involved in

determining how best to use computers with other resources to

perform task which meet the information requirements of an

organization.

 System analyst: This a computer specialist who uses human and

computer resources to design a system.

 Computerization: This is the use of computers and human resources

to create an efficient and effective system that overcomes the

problems of the old system.

 System configuration set-up: System configuration are basic

components of computers which make up the system to work

together as a single unit. These are the physical components of the

system {Hardware}.

STATEMEN T OF THE PROBLEMS

7
The problems identified with the Federal Science College sokoto during our

study in the school and in effective current system of result processing are

as follows:

I. The current system is not computerized and therefore all the

processing is done manually, where the processing will be slow.

II. No ready made information about the result, to check for any result

the staff in charge have to go through a number of files.

III. There is a repetitive strain injury {i.e the structure of each students

result is repeated each term before filling in the information}.

IV. No security for the result and this may lead to a situation where by an

un authorized users may go through some body result and also lead to

misplacement of the result.

V. There is the possibility of the result being damaged or worn out if

kept for long time e.g 15 to 2O years.

1.3OBJECTIVE OF THE STUDY

The objective of the study is to:

1) Design a new system using computer that will be very fast and

accurate.

2) Design a system that will make report very effective.

3) Design a system that will produce ready made record in time.

8
4) Design a record that will allowed proper record keeping of the

students results.

5) Design a system that will produce permanent structure of the students

result before filling in the information.

6) Design a system that will keep the students results for long time.

1.5 SCOPE OF THE STUDY

This study is covering the processing of result of federal science college

sokoto only. The study is analyzing the current or existing system result

processing of the above said unit and designing a new system of

processing result which will be of more advantage using computer.

1.6 LIMITATION OF THE STUDY

This project research is limited to the processing of the students

result, analyzing of the current system of Federal Science College and

using computer to ease the problems they are facing. The study would

have been extended to other unit of the college. But this is as a result of

shortage of time, financial constraints and insufficient materials which

the school authority or members of the administration would not want to

release out, with reasons best known to them.

9
 CHAPTER TWO

LITERATURE REVIEW

2.1 REVIEW OF RELATED LITERATURE

This involves the study where the existing system is fully understood.

It has to do with the procedure or methods used in processing the

student’s results.

2.1 INPUT REQUIREMENT

The following are the input items which are used in the existing

system.

NAME

This is a field where the students will be specified by the name.

ADMISSION NUMBER:

This refer to the current identification number of the student.

SUBJECT:

This is the name of the subject offered by the students.

SEX:

This is a field where the sex of the students will be specified either male or

female.

TERM:

It refer to either first second, or third term.

10
CLASS:

This refer to the class the students belongs.

NUMBER IN CLASSS:

It has to do with the number of the students in a particular class.

CONTINUES ASSESEMENT

This is the mark of the students assessment {i.e test and assignment which

is given by the teacher before the commencement of examination and the

mark is usually 3O%}.

EXAMS SCORES:

The scores which the students obtained during examination which is usually

7O%.

11
MARKS OBTAINABLE

This refer to the marks which is required by every students to score in both

assessment and exams. The mark is 1OO%.

MARKS OBTAINED

This refers to the total marks the students score in both assessment and

exams.

AVERAGE MARKS

This refers to the total scores obtained by the students divided by total

number of subjects offered b y the same student.

2.2 OUTPUT REQUIREMENT

Federal science college produce report about the students result after

each terms examination for every students belonging to the college to know

his or her performance.

The result is processed manually and the input given will be

determined the output.

The current system therefore produces report consisting of the

following:

SERIAL NUMBER

NAME

ADMISSION NUMBER

12
SEX

TERM AND YEAR

CLASS

N O. IN CLASS

CONTINUES ASSESMENT

EXAMS SCORES

MARKS OBTAINABLE

MARKS OBTAINED

AVERAGE MARKS

POSITION

REMARKS

13
FEDERAL SCIENCE COLLGE,

SOKTO

14
2.3 SYSTEM PROCEDURE

The system procedure involves the methods used by the federal

science college in processing the student’s results which is done manually

or earlier explained. The system used involves the students writing

examination sat by the individual teachers of each subject. During the

examination, a different teacher is appointed to invigilate the students, after

which the scripts will be submitted to the teachers responsible to the

subject. The scripts is marked and handed to the form master of that

particular class. The fore master is responsible for taking in the attendance

of the students daily, make sure that the students are obedient to their

teachers and attends to students when they have problems.

The fore master then get the score mark of the students form the

individual teachers, compiled the results and prepare the report sheer to the

various students to know their performances.

2.4 FILE MAINTAINED

In processing the students result there are files that will be

maintained in the current system. These files could use in feature references

when the needs arises. The files are:

i. Students record file

ii. Students result file

15
I. Students record file: This file contained record of this students

that are fairly permanent in nture even after updating the file

does not change {i.e it does not varies}. For example, we have

name, admission number etc.

II. Students result record: This file contains record that arte made

up of various transaction created from source document of

examination and continues assessment and it varies, it has short

life span as new result have to replace the one.

16
2.5 HUMAN ELEMENT

The exam officer who is the examination head and also among the

academic board meeting prepare a time table based on the exam that will

take place and set the date for the exam. He supervised the exams and make

sure that it is done appropriately. After the exams, the fore master will

record the manual result in to the board sheet and submit to the principal

and the academic board meeting. The academic board meeting {members}

are responsible for the approval, correction and moderation of the result and

give and final decision. Then the fore masters are responsible for the

compilation and report sheet.

The academic board is also responsible for the handling of any

problems relating to students.

Those involves in the Academic Board Meeting are:

1. the principal

2. vice principal academic

3. Guidance counseling unit

4. Exam officer

17
 CHAPTER THREE

METHODOLOY

3. 1 RESEARCH METHODOLOGY

This refers to accurate design of data entry procedure so that data going in

to the information system will be correct as the design stage is to work from

the requirement specification to produce a system specification.

3.1 RE-STATEMENT OF THE PROBLEMS AND OBJECTIVES

The problems identified with the Federal Science College during our study

in the college pertaining the effective current system of the result

processing are as follows:

a. The current system is not computerized and as a result of that, all the

processing are done manually; which causes the processing slow.

b. No ready made information about the result, to check for any result,

the staff or teacher in charge have to go through a number of files.

c. There is repetitive strain injuries {i.e. the structure of each student

result is repeated each term before filling in the information}.

d. No security for the result and to a situation where by an authorized

user may go through some body’s result and also lead to the

misplacement of the result.

18
 e. There is possibility of the result been damaged or worn out if kept for

long time, may be a period of 15 to 2O years.

THE OBJECTIVE OF THE STUDY IS TO:

i. Design new system using computer that will be very fast and

accurate.

ii. Design a system that will make report very effective.

iii. Design a system that will produce ready made record in time.

iv. Design a system that will allow proper record keeping of the

students result.

v. Design a system that will produce permanent structure of the

students result before filling in the information.

vi. Design a system that will keep the students result for long

time.

3.2 NEW INPUT REQUIREMENT

 SERIAL NO.{S/NO}: this is the numeric characters

which are numbered serially to each students.

 ADMISSION N O: this is referred to the number given

to the students.

 NAME: this is the field where the name of the students

is being specified.

19
 SEX: this is referred to the sex the students belong to;

eater male or female.

 SASSION: this refers to the academic year.

 DEPARTMENT: this refers to the various department

of subject offered in the school.

 TERM: this can be either first term, second term or

third term.

 NO. OF SUBJECT: this indicates the total subjects

offered by each student.

 SUBJECT: this indicates the particular subject.

 LOCATION GOVERNMENT AREA: this refers to

the local government area where the student come

from.

 STATE: this specified state of origin of each student.

 CLASAS: this refers to the class in which the student

is.

 NO. OF STUDENTS: this refers to the total number of

students in a particular class.

 SCORE: this refers to the mark obtained in each

subject.

20
  TOTAL: the total comprises of the score obtained in

the continues assessment.

 GRADE: this refers to the grades or marks which will

qualify the students for pass or fail.

3.3 NEW OUTPUT REQUIREMENT

Since all the recording is completed in the input requirement, then

this {input} will determine the new output. However, the output

requirement will contain the following:

SERAIL NO

ADMISSION NO.

NAME

SEX

SESSION

DEPARMENT

TERM

NO. OF SUBJECTS

SUBJECT

LOCAL GOVERNMENT AREA

NO. OF STUDENTS IN CLASS

NO. OG SUBJECT SAT

21
NO. OF SUBJECTS PASSED

POSITION IN CLASS.

22
FEDERAL SCIENCE COLLEGE SOKOTO

23
3.4 THE NEW SYSTEM PROCEDURE

The new system procedure here is referred to as management

information {MIS. This is because it is quite different from the manual

system which is being operated by the various staff of the college after the

students have finished their exams and the scripts are marked and submitted

to the class fore master for recording and preparing of the report sheet. In

this new system after the scripts have been marked and corrected, in will be

then taken to the management information system for putting the scores in

to the computer system for recording and processing. In this system, re

cording has to be in ascending order where it should be recorded at the

students effected subjects and their field for calculating of average

weighing of the grade of the students. After recording, calculating and

grading in the computer then copies of the output which are required can be

printed out for the students as terminal result {report} and broad sheet. And

the information will be stored in the computer for future use.

3.5 PROGRAM DESIGN

This program is designed in Beginners All Purpose Symbolic

Instruction, code which has the acronomy as BASIC, which was first

develop in 196O by John Kenny and Thomas Kurtc in the United State of

24
America {USA}. It was earlier developed as a teaching language but today

is the one of the most popular programming language.

The format of a basic programming statement is, each Basic

instruction must be gives a number tells the computer the sequence it has to

follow in executing the program, line numbers are positive whole numbers

without sign. In this our research of computerization of students result in

Federal Science College Sokoto. The program will base on he processing of

the students result which will consist of grading calculating the average of

the term and the whole session. The algorithms which are followed in

writing the program are as follows:

STEP 1: Enter the inputs fields: Serial number, Administration number,

Name, Sex, Local Government area, state, Class Session, Department,

subject, No. in class, No. of subject sat, No. of subject pass, term marks

obtained, class average, total average, Read the input field items.

STEP 2: Compute the input fields: Scores, {Continues assessment and

examination}.

STEP 3: compute the average = Total Scores/ No of the subject. Compute

grand total score 1+ score 2 … score.

STEP 4: Compute the final average point. Total Average/No. of terms. Print

Total average points, Remarks.

25
STEP 5: Stop

This steps and stages involves in the programming aspect of the new syste.

3.6 NEW FILES TO BE MAINTAINED

Instead of flat files which are involved in the processing of Result in

Federal Science College. The new files will be created in order to help in

processing of students result, in the new system and these files are called

computer files because they are created and possessed with the computer

system using BASIC interpreter.

Students record file: this is a files that contains the master record of the

students an d it does not varies in nature.

admission no.

name

sex

class

school

local government area

state.

Resident result file: this is a files that varies in nature during processing

active ity. It comprises of the continues assessment and the examination

score to give the total score.

26
The folders are:

Term

Session

Continues assessment score

Examination score

Total score

Average

Grade

Students report files: this is the combination of both student record and

result files in order to give the final report to the students and the report can

be produced in two forms, terminal report and the yearly report which

combine three of the final report {result} also this file can be used to

produce general statement of result and report booklet sheet. It includes the

followings:

Serial number

Name

Admission

Admission number

Sex

27
Class

Term

Session

Local government t

State

Scores {continues assessment + Examination scores}

Average

Grade

Remarks.

28
 CHAPTER FOUR

IMPLEMENTATION

4.1 INPUT PROCESSING AND OUTPUT ANALYSIS OF THE EXISTING SYSTEM

Activities at this stage includes installation of new system. The

systems changes from the manual to computerize methods of the students

result in Federal Science College Sokoto. Before the new system is

implemented there is need for studying the overall current system. The new

system is designed after studying the current system. The new system start

with the new input and output requirement. And the system met the

objectives set out in the original specification from time to time.

Implementing a system, the following procedures should be adopted.

1. design write and test computer programs.

2. Trains Users

3. Test Clearable procedures

4. produce documentation

5. Create Master File

6. Cut over to new system

After the new input and output requirement we then design the new system

that should be maintained in the ew system to replace the old system

{files}. This fies includes:

29
Students record file

Students result file

Students report file

In designing the new input and output and the files to ne maintained, a

program was designed that is algorithm of how the program will be use step

by step of executing the problems thus, where the data is to inputted is

expected to calculate the total and the average of the result. The program

flowchart were designed and finally te source code which is the main

program.

After the charge over have been successfully done, there need for the

arrangement of collecting the scripts after marking it and taking it to be

managed information system unit where the unit will ensure an accurate and

speed. In this stage, the staff should be training on how to make use of the

new system and there should be a rotation.

In the manual system, the record of the students result were kept in a file

jacket and store in a file cabinet, while in the new system the records are

written in to the computer and stored there for feature use and easy access.

4.1 HARDWARE REQUIREMENT

This refers to the physical component of the computer that will be required

for the processing of the students result. The components comprises of

30
scanner, mouse keyboard, printer, central processing unit {C.P.U} and

monitor.

The keyboard is used for inputting the data in to system, the central

processing unit for processing the data store and control it where as the

printer or the monitor is used for viewing or displaying the output to the be

seen.

Below is a technical details of MICRO computer that will be used.

1. PROCESSOR- 8O686. This is the latest processor

company with 1OOOMHZ.

2. MODEL NAME- Howlet Packard.

3. HARD DISK DERIVE – 54O megabytes {}MB

4. FLOPPY DISK DERIVE- “3.5and “5.25” High

density Floppy derive double.

5. RAM -12 Mega Bite {MB} latest and best grans.

6. ENHANCED KEYBOARD -12 keys soft touch

7. LOGITEN mouse

8. SVGA {super video Graphics Adopter} – colored

monitor with 256 colors.

9. PRINTER – HP laser jet 11OO

10.SCANNER

31
 11.UPS {Uninterrupted power supply}- the latest one

which can which can resist current for two and

half {2.5} hour.

SOFTWRE REQUIREMENT

The requirement for this for this system is

Operating system- Microsoft disk operating system version 6.22 {MS DOS

622v}.

TRANSLATOR- in this translator comes interpreter.

3.4 HUAMN ELEMENT

the management information system {MIS}unit will be headed by the

director management information system and most be a computer literate,

he shall be responsible for administering and coordinating all activities of

the management information unit, he shall feed the academic board with

necessary information about the student result. There should be operator

whose work is to interact with the computer that is, to input data of the

result and get out put of the processed result. He makes sure that the right

data is inputted because it consists of the student results. There should also

be a supervisor form the examination board that will also be a computer

literate that will be supervising the work done by the management

information system unit to ensure that what is required is what has been

32
done. There most be a computer specialist who will always ensure that the

computer is working very well, and to always ensure that the system

specification meet the requirement of the management. Finally, there most

b a messenger or cleaner who may not be a computer literature to be

cleaning the computer and the room where the computer are been kept in

order to prevent any thing like dust that will cause damage to the system.

In conclusion, the numbers of personal that will be needed as regard

to what has been explained or responsible for the task mentioned above are:

1. Director

2. Computer operator

3. supervisor

4. Analyst {computer specialist}

5. A messenger

33
 CHAPTER FIVE

SUMMARY CONCLUSION AND RECOMMENDATIONS

5.1 SUMMARY

In changing over from old system {manual} to the new system which

contain many changes of materials human and maintenance, there is need to

know the cost of the materials.

First of all there is cost of materials, which involve the buying of

computer and it’s peripherals, the coast of materials that are required are as

follows:

Materials

Complete computer {Howlet packed} 7O,OOO.OO

Printer {Laser jet printer} 5O,OOO.OO

Scanner 5O,OOO.OO

The second part is the training of staff on how to operate the computer with

latest Diploma level. There is also cost of maintenance of the system which

involve the setting of the place where the computer will base and the buying

of their condition in order to normalize the temperature of the place. The

other coast is servicing the computer a schedule that is cleaning, lubricating

of the system to prevent any damage.

34
After all those have been done, the new system will start working

effectively, where the institution will start from benefiting from the new

system and the expected benefits that will be derived from the system are:

o There will be ready made information

o There would high degree of accuracy and it consistency can be relied

upon.

o There will be a good record maintenance.

CONCLUSION AND RECOMMENDATION

This project research work is made up of five chapters, chapter one

introduced the topic of this research work, computerization of students

result processing. A case study of Federal Science College Sokoto and gave

the historical development, problems associated with the current system and

objectives of the study. In chapter two analyzed the whole system of result

processing and design a new system of result processing which is called

computerization of student result chapter three. Implementing correctly the

system design in chapter four but will now only make students result

process efficient, but also good record maintenance easy across to data and

read made information on students result. We will at this point suggest the

immediate computerization of students result processing in Federal Science

College will provide accurate and meaningful information.

35
 A computer also earlier discussed at the first chapter one of this

project is an electronic device that accept data, manipulate it store

information at tremendous speed, is a very important characteristics of a

computer.

Judging by the problems of the manual methods are discussed in this

project, we are recommending to the management staff of the Federal

Science College to purchase and own computers of their own to ease the

burden and difficulties encountered in the processing of the students result.

We also recommend the proceeding of this research work, because, as the

society get changing and the system of processing data also changed.

36
 REFERENCIES

Chapman, R.J. and Oliver E.C. 1978. Data processing and information

Technology 5th Ed. 285- 389, 4O2- 4O5.

ejembi, A.H.U A Hand book on Federal Science College, Sokoto. 2-12.

french, C.S. 1973 computer science. 5th Ed. 175-18O, 2O1- 2O5, 6O2- 688.

howmes, B.J. 198O. Basic Programmig- A computer course Text, 4th Ed.

28, 37, 5O-67.

School Course Handout System analysis and Design.

Private conn As New ADODB.Connection

Private Rec As New ADODB.Recordset

Private rs As New ADODB.Recordset

Dim Path As String

Dim dbPath, tbrs As String

Dim TotalAmount As String

Dim Qty As String

Dim TDATE As Date

Dim Amount As Double

'Dim tbrs As String

37
Dim fname, lname As String

Private Sub MDIForm_Load()

'Set RSS = New ADODB.Recordset

dbPath = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path

& "\fcsjao.mdb;Persist Security Info=False"

conn.Open dbPath

End Sub

Private Sub MDIForm_Unload(Cancel As Integer)

End

End Sub

Private Sub mnuAllStudent_Click()

frmAllStudent.Show

End Sub

38
Private Sub mnuEnglis_Click()

frmEnglish.Show

End Sub

Private Sub mnuExit_Click()

End

End Sub

Private Sub mnuNewStudent_Click()

frmNewStudent.Show

End Sub

Private Sub mnustudent_Click()

Dim BAL As Double

Dim TYP As String

strREG = Trim(InputBox("ENTER CUSTOMER REG. NO. BELOW:",

"Search"))

39
If strREG = "" Then Exit Sub

tbrs = ("select * from tbstudent where regno= '" + strREG + "'")

Rec.Open tbrs, conn, adOpenDynamic, adLockOptimistic

With Rec

While Not .EOF

fname = !fname

lname = !lname

city = !city

dor = !dor

State = !State

address = !address

NATION = !NATION

pname = !pname

pphoneno = !pphoneno

paddress = !paddress

40
sex = !sex

If !regno = strREG Then

Load frmEditStudent

With frmEditStudent

On Error Resume Next

.txtId.Text = strREG

.txtFname.Text = fname

.txtLname.Text = lname

.txtAddress.Text = address

.txtCity.Text = city

.txtState.Text = State

.txtNational.Text = NATION

.cmbSex.Text = sex

.DTPDOB = dob

.txtPname.Text = pname

.txtPaddress.Text = paddress

.txtPphoneNo.Text = pphoneno

.txtdor = dor

.Show

End With

41
Rec.Close

'Conn.Close

Exit Sub

End If

.MoveNext

DoEvents

MsgBox "Incorrect Customer Reg. No.! Make sure this Customer have

Registered.", vbExclamation, "No Match"

Rec.Close

Exit Sub

Wend

Rec.Close

End With

End Sub

Dim CID, NO As String

Dim dbPath As String

Dim conn As ADODB.Connection

Dim Rec As ADODB.Recordset

42
Dim rs As ADODB.Recordset

Private Sub cmdExit_Click()

Unload Me

End Sub

Private Sub cmdSave_Click()

Me.Hide

If Trim(txtFname.Text) = "" Then

MsgBox "Empty Entry found! Please, fill the form.", vbCritical,

"Empty Field"

Me.Show

Exit Sub

End If

43
conn.ConnectionString = dbPath

conn.Open dbPath

Rec.Open "tbstudent", conn, adOpenDynamic, adLockOptimistic

'---------- TO CHECK REGISTRATION NUMBER DUPLICAT

---------------

With Rec

While Not .EOF

If !regno = (txtId.Text) Then

MsgBox (txtId.Text) & " Has Already Been Registered", vbInformation,

"Multiple Registration not Allowed"

Exit Sub

End If

.MoveNext

44
DoEvents

Wend

End With

With Rec

.AddNew

!regno = txtId.Text

!dor = txtdor.Text

!fname = txtFname.Text

!lname = txtLname.Text

!address = txtAddress.Text

!city = txtCity.Text

!State = txtState.Text

!NATION = txtNational.Text

!sex = cmbSex.Text

!dob = DTPDOB

!pname = txtPname.Text

!paddress = txtPaddress.Text

45
 !pphoneno = txtPphoneNo.Text

If MsgBox("Do you want to Submit?", vbYesNo + vbQuestion, _

"Confirm") = vbYes Then

.Update

MsgBox "Submittion was Successful!", vbInformation, "Submitted"

Unload Me

' frmMain.Show

Else

Me.Show

Exit Sub

End If

.Close

End With

End Sub

Private Sub Form_Activate()

conn.ConnectionString = dbPath

46
conn.Open dbPath

Rec.Open "tbstudent", conn, adOpenDynamic, adLockOptimistic

With Rec

If .BOF = True And .EOF = True Then

CID = "50000"

End If

If .BOF = False Or .EOF = False Then

.Sort = regno

.MoveLast

CID = Format((Val(!regno) + 1), "00000")

NO = CID

End If

End With

Rec.Close

conn.Close

txtId.Text = NO

End Sub

47
Private Sub Form_Load()

Move (Screen.Width - Width) / 2, (Screen.Height - Height) / 8

Set conn = New ADODB.Connection

Set Rec = New ADODB.Recordset

dbPath = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path

& "\fcsjao.mdb;Persist Security Info=False"

txtdor.Text = Date

cmbSex.AddItem "MALE"

cmbSex.AddItem "FEMALE"

End Sub

Private Sub Frame1_DragDrop(Source As Control, X As Single, Y As

Single)

End Sub

48
APPENDIX B

49
50
51
52