COLLEGE MANAGEMENT SYSTEM ON VISUAL BASIC ( BY SANTOSH KUMAR--- IIMT , KARKARDOOMA)

PROJECT REPORT ON COLLEGE MANAGEMENT SYSTEM Submitted In Partial Fulfillment of the Requirement Of “Bachelor of Business Administration” BATCH (2009-2012)

PROJECT SUPERVISOR:

SUBMITTED BY ;

MRS. SEEMA GUPTA (HOD)

SANTOSH KUMAR

MS. NEHA MANCHANDA

(01121001909)

(ASSISTANT PROFESSOR)

IDEAL INSTITUTE OF MANAGEMENT AND TECHNOLOGY (Affiliated to Guru Gobind Singh Indraprastha University)

1 SANTOSH KUMAR (01121001909)

CERTIFICATE It is certify that summer training project report on “COLLEGE MANAGEMENT SYSTEM” is a record of project work done by SANTOSH KUMAR enrollment no 01121001909 during the period of hIS study under our guidance & that the project report has not previously formed the basis for the award of any degree, diploma, fellowship or similar titles and that it is an independent work done by her..

DATE PLACE: DELHI MRS. SEEMA GUPTA (H.O.D.) MISS. NEHA MANCHANDA (ASST.PROFESSOR )


DECLARATION WE hereby declare that this Project Report titled “COLLEGE MANAGEMENTSYSTEM” submitted by me to “IDEAL INSTITUTE OF MANAGEMENT AND TECHNOLOGY “ is a bonafide work undertaken by US and has not been submitted to any other University or Institution for the award of any degree diploma / certificate or published any time before

SANTOSH KUMAR Enrollment no.- 01121001909 Semester -6th Date: / / 2012


INDEX S.no.

Table of content

Page no.

1.

CHAPTER 1. INTRODUCTION

1-13

1.1

Project Overview

1.2

Need of Proposed system

1.3

Feasibility study

2.

CHAPTER 2. SYSTEM REQUIREMENT

2.1

Hardware Requirement

2.2

Software requirement

2.3

Front end and back end

3.

CHAPTER 3. PROJECT PHASES

3.1

Software requirement specification(SRS)

3.2

Requirement Analysis

3.2.1

Data Flow Diagram

3.2.2

Entity Relationship Diagram

3.2.3

Use case diagram

3.3

Design phase

3.3.1

Logical design

3.3.2

Physical design

3.3.3

Design strategies

3.4

Implementation

3.4.1

Screen shots

3.5

Testing

3.5.1

Types of testing

3.6

Maintenance

4.

CHAPTER 4. REFERENCES

14-16

17-71


ACKNOWLEDGEMENT

First of all I will thank to our director sir “ Mr. ANIL PARKASH SHARMA” who give me the valuable suggestion for my minor project. The success of this final report is the outcome of Guidance and Valuable suggestions provided by the all concerned without which the report could not fide on the right back. I express my sense of deep gratitude to Faculty Coordinator “Ms. SEEMA NATH AND NEHA ” for inclusions and timely suggestions in the preparation of this final report.

Name: Santosh kumar (01121001909)


INTRODUCTION The project “COLLEGE MANAGEMENT” is made to use that management working in “IIMT”. This Project is helpful to Registration of New records into the “COLLEGE”. This Project Contain mainly following section:-

 VIEW SECTION  ALTER SECTION

 STAFF INFORMATION  STUDENT INFORMATION .  STAFF RECORDS (ADD / MODIFY / DELETE)  STUDENT RECORDS (ADD / MODIFY / DELETE)

 ATTENDENCE RECORDS (ADD / MODIFY / DELETE).


PROJECT OVERVIEW The system COLLEGE MANAGEMENT SYSTEM can be used to manage the data of all type of educational institutes. It will support both stand alone and also networking environment. The system uses VB. Net Technology. The main modules involved in this system are: 1. Login 2. Forms 3. Reports 4. Window Module wise description Login Login module is used to check whether the user is an authorized person to use the system or not. For this the user should give the correct user name and password. The different types of users’ are 1. Admin 2. Student 3. Employee Forms This module consists of the following sub modules  Student Registration Form  Student Fee Form

 Students attendance Form  Student ID Form

 Employee Detail Form


 Employee Salary Form

 Employee ID Form

The Student Registration Form is designed for registering the new student’s details and course details. The Student Fee Form is used to enter the student’s fee details. The Student Marks Form is designed for submitting the semester or exam marks of the students for a particular course or an individual student. The Student Id Form is used to create the identity number for each student for different course. The Employee details form is designed for entering the staff details and other relevant details .The Employee Id used to create the identity number for each student for different course. The salary form is used to derive the salary for employees The Course details form is designed for entering the different course available in the campus and other relevant details. Reports All the above mentioned data are stored in the back end and can be retrieved as reports with filtering options. The Following are the reports

Can be taken from this system  Student Report  Employee Report  Fee Detail Report  Marks Detail Report  Generate attendance


Objective Of The Project

Main aim in developing campus management system is to provide an easy way not only to automate all functionalities of a college, but also to provide full functional reports to top management of college with the finest of details about any aspect of college. We are committed to bring the best way of management in the various forms of Campus management system. We understand that campus management system in not a product to be sold , it is a bridge between the College and Students. So we can say the Core purpose of designing “College Management System” is to manage the task related to the college students/employees and to reduce time to searching of appropriate candidates in college view

TOOLS & ENVIRONMENTAL USED

FRONT END AND BACK END TOOLS The concept of front end and back end has been chosen to develop this software as this suits the DBMS architecture to its full potential. Visual Basic has been chosen at the front end Microsoft access has been chosen at the back end.

MICROSOFT- ACCESS: MICROSOFT- ACCESS is a database management system or DBMS. A DBMS helps you to manage data that’s stored in a computer database. It is a full-featured application development system that includes the Visual Basic Programming language and other tools for setting up sophisticated applications for yourself and your customers.

Microsoft Access is designed from the ground up to provide full support for all window features. Some of the most important windows like features you’ll find in Access are:


32-BIT APPLICATION: MS-Access 2000 is a 32- bit application, which means that it runs in its own protected computer memory area. Therefore Access won’t grind to a halt if some other program on your computer decides to misbehave. Access also takes advantage of the multithreading capabilities of windows, the Jet database engine, Microsoft Access, and modules written for Visual Basic all run in separate there’d.

DATABASE EXPLORER: The database window in Access looks and acts a lot like Windows Explorer, as well as windows that appear.


Scope Of The System

This system provides the detail structure of the college campus and its departments. This software synchronizes the working of all the departments. It looks on all aspects of college, its students, faculties, Departments, marks and other co – curricular activities. This software enables the easiest way to manage all functionalities of a college, which facilitates colleges to maintain the functionality related to college employees and their students.

Benefits: Following are the benefits for using College Management System: For Employees:  Easy to create any kind of certificate.

 Easy to query all related details of student and employee

 Easy to generate payroll of individual employee.

For College:  Collective records of students of all the branches.

 Collective records of employees of all departments

 Easy approach to find the detail information for any student/employee 11 SANTOSH KUMAR (01121001909)

 Easy to handle all functionality of college

 Easy to manage all actions (generating attendance report, fee report etc)

 All information can be synchronized in one place. And distribute to a particular department to manage properly.

 CMS is beneficial for both students/employees only in the way that they can get all previous or current information’s when they need.

 It is helpful to maintain the students record (admission record, fees record, Marks records etc).

 Teacher does not maintain the file, documentation, reports (class Wise, section wise)

Advantages:  By using this s/w, you can learn how you prepare your records in standard manner

 Also you can find the previous session papers and current news related to any student or employees.

 By using this s/w, administrator can manage all records in standard manner. 12 SANTOSH KUMAR (01121001909)

 Also it can help to get all or a particular student attendance information by attendance master

 Also it can help to maintain the fees and accounting reports of college in proper way.

 It helps to generate mark sheets of current year or previous year's students


NEED FOR PROPOSED SYSTEM

The main objective of the existing system is to provide a user-friendly interface. The system, which is proposed, now computerizes all the details that are maintained manually. Once the details are fed into the computer there is no need for various persons to deal with separate sections. Only a single person is enough to maintain all the reports. The security can also be given as per the requirement of the user

 Large volumes of data can be stored with case.

 Maintenance of file is flexible.

 Records stored are updated now and then.

 Stored data and procedures can be easily edited.

 Reports can be generated with case.

 Accurate calculations are made.

 Less manpower required.


FEASIBILITY STUDY Feasibility Study is a step towards identification of the candidate system as a feasible product. First the studies often pre-suppose that when the feasibility document is being prepared, the analyst is in a position to evaluate solutions. Second, most studies tend to overlook the confusion inherent in system development – the constraints and the assumed attitudes.

If the feasibility study is to serve as a decision document, it must answer three questions:  Is there a new and better way to do a job that will benefit the user?  What are the costs and savings of the alternatives?  What is recommended?

Feasibility Considerations: There are three key considerations to the feasibility study: 1) Economic 2) Technical 3) Behavioral

FEASIBILITY ANALYSIS OF THE SYSTEM

Economic Feasibility The project was considered to be economically feasible because-

 The cost involved in developing the candidate system well under the budget of the organization.


 The Cost-Benefit Analysis tells us that the value of the benefits offered by the proposed system is much higher than the cost.

Technical Feasibility The proposed system is technically feasible because all the necessary hardware and software required for developing and installing the system is available with the organization.

Behavioral Feasibility The proposed system is also behaviorally feasible as it is very user friendly. Extensive training of the users is not required. The users can easily learn to use the system and can adapt themselves according to the system. ANALYSIS: Analysis is a detailed study of the various operations performed by a system and their relationships within and outside of the system. A key question is what must be done to solve the problem? One aspects of analysis are defining the boundaries of the system and determining whether or not a candidate system should consider other related system. During analysis, data are collected on the available files, decision points, and transactions handled by the present system. Some logical system models and tools that are used in analysis. DFD interviews, onsite observations, and questionnaires are examples. The interview is a commonly used tool in analysis. It requires special skills and sensitivity to the subjects being interviewed. Bias in data collection and interpretation can be a problem. Training, experience, common sense is required for collection of the information needed to do analysis.

Once analysis is completed, the analyst has firm understanding of what is to be done. The next step is to decide how the problem might be solved. Thus, in system design, we move from the logical to the physical aspect of the life cycle.

DESIGN:


The most creative and challenging phase of the system life cycle is system design. The term design describes a final system and the process by which it is developed. It refers to the technical specifications (analogous to the engineer’s blueprints) that will be applied in implementing the candidate system. It also includes the construction of programs and program testing. The key question here is: How should the problem be solved? The major steps in designing are:

The first step is to determine how the output is to be produced and I what format. Samples of the output (and input) are also presented. Second, input data and master files (data base) have to be designed to meet the requirements of the proposed output. The operational (processing) phases are handled through program construction and testing, including a list of the programs needed to meet the system’s objectives and complete documentation. Finally, details related to justification of the system and an estimate of the impact of the candidate system on the user and the organization are documented and evaluated by management as a step towards implementation.

The final report prior to the implementation phase includes procedural flowcharts, record layouts, report layouts, and workable plans for implementing the candidate system. Information on personnel, money, h/w, facilities and their estimated cost must also be available. At this point, projected costs must be close to actual cost of implementation.

In some firms, separate groups of programmers do the programming where as other firm’s employ analyst-programmers that do the analysis and design as well as code programs. For this discussion, we assume that two separate persons carry out analysis and programming. There are certain functions, though, that the analyst must perform while programs are being written.

IMPLEMENTATION: The implementation phase is less creative than system design. It is primarily concerned with user training, site preparation, and file conversion. When the candidate system is linked to terminals to remote sites, the telecommunication network and test of the network along with the system are also included under implementation.

During the final testing user acceptance is tested followed by user training. Depending on the nature of the system, extensive user training may be required. Conversion usually takes place at about the same time the user is being trained or later


In the extreme, the programmer is falsely viewed as some who ought to be isolated from other aspects of system development. Programming is itself design work, however. The initial parameters of the candidates system should be modified as a result of programming efforts. Programming provides a “reality test” for the assumptions maid by the analyst it is therefore a mistake to exclude programmers from the initial system design

System testing checks the readiness and accuracy of the system to access update and retrieve data from new files. Once the program becomes available test data are read into the computer and processed against the file provide for testing in most conversions a parallel run is conducted where the new system runs simultaneously with the old system this method though costly provides added assurance against errors in the candidate system.

POST – IMPLIMENTATION AND MAINTENANCE:

After the installation phase is completed and the user staff is adjusted to the changes created by the candidate system evaluation and maintenance begin. Like any system there is an aging process that requires periodic maintenance of hardware and software if the new information is inconsistent with the design specification then changes have to be maid. Hardware also requires maintenance to keep in tune with design specification.


SYSTEM SPECIFICATION

HARDWARE CONFIGURATION The hardware used for the development of the project is: PROCESSOR: PENTIUM III 866 MHz

 RAM: 128 MD SD RAM

 MONITOR: 15” COLOR

 HARD DISK:20 GB

 FLOPPY DRIVE: 1.44 MB

 CDDRIVE: LG 52X

 KEYBOARD: STANDARD 102

 KEYSMOUSE: 3 BUTTONS

SOFTWARE CONFIGURATION The software used for the development of the project is OPERATING SYSTEM: Windows XP Professional


 ENVIRONMENT: Visual Studio .NET 2005

 .NET FRAMEWORK: Version 1.0

 LANGUAGE: Visual Basic.NET

 BACKBEND : Ms access


TECHNOLOGY USED  .NET  VBSCRIPT

FRONT END AND BACK END  FRONT END: VISUAL BASIC 6.

 BACK END: MICROSOFT ACCESS 2007


PROJECT PHASE


SOFTWARE REQUIREMENT SPECIFICATION(SRS) Introduction: The introduction of the Software Requirement Specification states the goals and objectives of the software, describing it in context of the computer based system.

Information Description: It provides detailed description of the problem that the software must solve. Information content, flow and structure are documented. Hardware, Software and human interfaces are described for external system elements and internal software functions.

Functional Description: A processing narrative is provided for each function , design constraints are stated and justified, performance characteristics are stated, and one or more diagrams are included to graphically represent the overall structure of the software and interplay among software and other system elements. Behavioral Description: This section of the SRS examines the operation of software as a consequence of external events and internally generated control characteristics.

Validation Criteria: It is probably the most important and ironically the most often neglected section of the Software Requirement Specification. The section is neglected because completing it demands a thorough understanding of the software requirements. Specification of validation criteria acts as an implicit review of all other requirements, so it is essential that time and attention is given to this section.


Bibliography and references: It is also important to put all the important references at the end of the document so that any other programmer or user can refer to them in case of any confusions or problems.


ANALYSIS Analysis is the first technical step in the process of any software development. A careful analysis can help the software designer and programmer to have a better insight of the product to be created. A careless analysis can result into incomplete or dysfunctional software. To avoid such a situation it is very important to properly identify the required software’s features and create an effective design for it. It is also important to analyze and find out whether the application being developed suits the current hardware and software platform available or not. The application should be developed well within time and should meet the specified requirements. If the application is being developed for commercial purposes then a cost-benefit analysis becomes must to find out the real value of the software product.

TECHNIQUES USED FOR ANALYSIS Interviews: The interview is the face-to-face interpersonal meeting designed to identify relations and capture information as it exists. It is flexible tool, offering a better opportunity than the questionnaire to evaluate the validity of the information gathered. This tool is used because it is a superior technique for capturing information as it exists and it is also an exploratory device to identify or verify information.

Guidelines for interviews

 Who will be interviewed?

 In what order will they be interviewed?

 What specific questions will be asked in each interview? Besides these, individual, group discussions can also be conducted, which can lead to some frank expression of opinions and ideas.


During interviews it should be kept in mind that there is a proper coordination between the interviewer and the interviewee so that the purpose of the interviews id fruitfully fulfilled.

Questionnaires The questionnaire is a self-administrated tool that is more economical and requires less skill to administer than the other methods. It examines a large number of respondents at the same time, provides standardized wording and instructions, and places less pressure on subjects for immediate responses.


DATA FLOW DIAGRAM (DFD) O – LEVEL

ADMINISTRATION

ACCESS STUDENT RECORD COLLEGE MANAGEMENT SYSTEM

GENERAT

RECORDS


ENTITY RELATIONSHIP DIAGRAM (ER DIAGRAM) ER-DIAGRAM An entity relationship model is a detailed and logical representation of the data for an organization or for business area. The entity relationship, which is also known as ER relationship is based on the theory of real world which consist of a set of basic object, which are called entities and relationships among these object.

The data model was developed to facilitate data base design by allowing specification of an enterprise schema which represents the overall logical structure of a database. We will present the modeling concept of ER model which is higher level conceptual data, The ER-model does not provide the overall data base structure but it gives the intermediate step on the basis of which data base is designed.

The ER modeling is a technique for analysis and logical modeling of a systems data requirements. It uses graphical notation for representing these. Ei = Entity Ri = Relationship MEANING

Entity

Entity

Weak entity

Relationship


Attribute

Key Attribute


ENTITY RELATIONSHIP DIAGRAM (ER DIAGRAM)


SYSTEM DESIGN The main part of designing a client/server application is to map the requirements identified into the features provided by the environment.

DESIGN PHASE The design phase focuses on the detailed implementation of the system recommended in the feasibility study. Emphasis is on translating performance specifications into design specifications. The design phase is a transition from a useroriented document (system proposal) to a document oriented to the programmers or database personnel. The design process is a set of iterative steps that allow the designer to describe all the aspects of the software to be built, based on the user specification .System design goes through two phases :The requirements analysis phase defines WHAT a system must do and the design phase states HOW to do it.

The term design is used in two ways. When used as a verb, it represents the process of design & when used as a noun, it represents the result of the design process, which is the design for the system. The goal of the design process is to provide a model or representation of a system, which can be used later to build that system. The produced model is called the design of the system. The design process is essentially a blue print of a solution for the system. The input to the design phase is the specifications for the system to be designed.

DATABASE DESIGN Database design activity deals with the design of the physical database. A key to this is how the access paths are to be implemented. A physical path is derived from a logical path. It may be implemented through pointers, chains or some other mechanisms. A database is a collection of information that’s related to a particular subject or purpose, such as details of a bank and the users that use it. If your database isn’t stored on a computer, or only parts


of it are, you may be tracking information from a variety of sources that you will need to coordinate and organize yourself. Field: A field is the smallest entity in the database. It is a particular characteristic or property of a specific person or subject. Record: A record is a collection of related fields. Table: A table is a collection of related records. Usually a separate table is made for different types of subjects or purposes. The tables can be related to obtain a working relationship in the database. Module The complete functions of this project are based on the fowling module.

 Attendance Maintenance Module: In this module we deal with different activities associated with college like regular attendance, short attendance report, every day attendance, checking of short list, replacement of staff, Appointing new lecturer according to the requirement, maintaining total staff(teacher & non teacher), and many more term associated with college management by this module. To handle these entire tasks it takes help of following forms, which are as follows:

 Access student information form

 Attendance form.

 Short list check form 32 SANTOSH KUMAR (01121001909)

 Total attendance by date

 Quick Search module This module contains a strong search mechanism, which search for different ways as per the requirement of the user. It can search:

 Attendance list present in the database

 Different student present in different class provides a full detail of all student.

 It also provides facility to check the list of short attendance of the student

 It also searches for the total student present in class for any required date


SYSTEM IMPLEMENTATION 4.1 About Language

The Control Properties Before writing an event procedure for the control to response to a user's input, you have to set certain properties for the control to determine its appearance and how it will work with the event procedure. You can set the properties of the controls in the properties window or at runtime. Handling some of the common controls

The Text Box The text box is the standard control for accepting input from the user as well as to display the output. It can handle string (text) and numeric data but not images or pictures. String in a text box can be converted to a numeric data by using the function Val(text). The following example illustrates a simple program that processes the input from the user. Example In this program, two text boxes are inserted into the form together with a few labels. The two text boxes are used to accept inputs from the user and one of the labels will be used to display the sum of two numbers that are entered into the two text boxes. Besides, a command button is also programmed to calculate the sum of the two numbers using the plus operator. The program use creates a variable sum to accept the summation of values from text box 1 and


text box 2.The procedure to calculate and to display the output on the label is shown below. The output is shown in Figure 3.2 Private Sub Command1_Click () „To add the values in text box 1 and text box 2 Sum = Val (Text1.Text) + Val (Text2.Text) „To display the answer on label 1 Label1.Caption = Sum End Sub

Figure

The Label The label is a very useful control for Visual Basic, as it is not only used to provide instructions and guides to the users, it can also be used to display outputs. One of its most important properties is Caption. Using the syntax label. Caption, it can display text and


numeric data . You can change its caption in the properties window and also at runtime. Please refer to Example 3.1 and Figure 3.1 for the usage of label.

The Command Button The command button is one of the most important controls as it is used to execute commands. It displays an illusion that the button is pressed when the user click on it. The most common event associated with the command button is the Click event, and the syntax for the procedure is Private Sub Command1_Click () Statements End Sub

The Picture Box The Picture Box is one of the controls that is used to handle graphics. You can load a picture at design phase by clicking on the picture item in the properties window and select the picture from the selected folder. You can also load the picture at runtime using the Load Picture method. For example, the statement will load the picture grape.gif into the picture box. Picture1.Picture=Load Picture ("C:\VB program\Images\grape.gif") You will learn more about the picture box in future lessons. The image in the picture box is not resizable.

The Image Box 36 SANTOSH KUMAR (01121001909)

The Image Box is another control that handles images and pictures. It functions almost identically to the picture box. However, there is one major difference, the image in an Image Box is stretchable, which means it can be resized. This feature is not available in the Picture Box. Similar to the Picture Box, it can also use the Load Picture method to load the picture. For example, the statement loads the picture grape.gif into the image box. Image1.Picture=Load Picture ("C:\VB program\Images\grape.gif")

The List Box The function of the List Box is to present a list of items where the user can click and select the items from the list. In order to add items to the list, we can use the AddItem method. For example, if you wish to add a number of items to list box 1, you can key in the following statements Example

Private Sub Form Load ( ) List1.AddItem “Lesson1” List1.AddItem “Lesson2” List1.AddItem “Lesson3” List1.AddItem “Lesson4” End Sub The items in the list box can be identified by the List Index property, the value of the List Index for the first item is 0, the second item has a List Index 1, and the second item has a List Index 2 and so on 37 SANTOSH KUMAR (01121001909)

The Combo Box The function of the Combo Box is also to present a list of items where the user can click and select the items from the list. However, the user needs to click on the small arrowhead on the right of the combo box to see the items which are presented in a drop-down list. In order to add items to the list, you can also use the AddItem method. For example, if you wish to add a number of items to Combo box 1, you can key in the following statements Example Private Sub Form_Load ( ) Combo1.AddItem “Item1” Combo1.AddItem “Item2” Combo1.AddItem “Item3” Combo1.AddItem “Item4” End Sub

The Check Box

The Check Box control lets the user selects or unselects an option. When the Check Box is checked, its value is set to 1 and when it is unchecked, the value is set to 0. You can include the statements Check1.Value=1 to mark the Check Box and Check1.Value=0 to unmark the Check Box, as well as use them to initiate certain actions. For example, the program will change the background color of the form to red when the check box is unchecked and it will change to blue when the check box is checked. You will learn about the conditional 38 SANTOSH KUMAR (01121001909)

statement If….Then….Elesif in later lesson. VbRed and blue are color constants and Back Color is the background color property of the form.

The Option Box

The Option Box control also lets the user selects one of the choices. However, two or more Option Boxes must work together because as one of the Option Boxes is selected, the other Option Boxes will be unselected. In fact, only one Option Box can be selected at one time. When an option box is selected, its value is set to “True” and when it is unselected; its value is set to “False”. In the following example, the shape control is placed in the form together with six Option Boxes. When the user clicks on different option boxes, different shapes will appear. The values of the shape control are 0, 1, and 2,3,4,5 which will make it appear as a rectangle, a square, an oval shape, a rounded rectangle and a rounded square respectively. Example Private Sub Option1_Click ( ) Shape1.Shape = 0 End Sub Private Sub Option2_Click() Shape1.Shape = 1 End Sub Private Sub Option3_Click() Shape1.Shape = 2 End Sub 39 SANTOSH KUMAR (01121001909)

Private Sub Option4_Click() Shape1.Shape = 3 End Sub Private Sub Option5_Click() Shape1.Shape = 4 End Sub Private Sub Option6_Click() Shape1.Shape = 5 End Sub

The Drive List Box

The Drive List Box is for displaying a list of drives available in your computer. When you place this control into the form and run the program, you will be able to select different drives from your computer as shown in Figure 3.3

The Directory List Box The Directory List Box is for displaying the list of directories or folders in a selected drive. When you place this control into the form and run the program, you will be able to select different directories from a selected drive in your computer as shown in Figure 3.4


The File List Box The File List Box is for displaying the list of files in a selected directory or folder. When you place this control into the form and run the program, you will be able to shown the list of files in a selected directory as shown in Figure You can coordinate the Drive List Box, the Directory List Box and the File List Box to search for the files you want. The procedure will be discussed in later lessons.

MS ACCESS 2003

Microsoft Access is a powerful program to create and manage your databases. It has many built in features to assist you in constructing and viewing your information. Access is much more involved and is a more genuine database application than other programs such as Microsoft Works.

The keywords involved in the process are: Database File, Table, Record, Field, Data-type. Here is the Hierarchy that Microsoft Access uses in breaking down a database.

Database File: This is your main file that encompasses the entire database and that is saved to your hard-drive or floppy disk. Example: StudentDatabase.mdb Table: A table is a collection of data about a specific topic. There can be multiple tables in a


database. Field: Fields are the different categories within a Table. Tables usually contain multiple fields. Data types: Data types are the properties of each field. A field only has 1 data type. Fieldname) Student Last Name Data type) Text


SCREEN LAYOUT (SNAP SHOT)


Option Explicit

Private Sub Form_KeyPress(KeyAscii As Integer) Unload Me Form1.Show

End Sub

Private Sub Form_Load() Label3.Caption = Date$


Label6.Caption = Time$

lblVersion.Caption = "Version " & App.Major & "." & App.Minor & "." & App.Revision lblProductName.Caption = App.Title End Sub

Private Sub Frame1_Click() Unload Me Form1.Show

End Sub

Private Sub imgLogo_Click() Unload Me Form1.Show

End Sub


LOGIN PAGE


IF ENTER INVALID USERNAME PASSWORD


IF ENTER CORRECT USERNAME PASSWORD

Static I As Integer If Text1.Text = "S" And Text2.Text = "S" Then MsgBox "SIGNUP SUCCESFULLY" Unload Me Form3.Show Else MsgBox "INVALID USER" I=I+1 If I = 3 Then Unload Me End If End If


End Sub

Private Sub Command10_Click() End

End Sub

Private Sub Command11_Click() frmSplash1.Show

End Sub

Private Sub Command2_Click() Unload Me Form1.Show

End Sub


End Sub


End Sub


End Sub

Private Sub Command9_Click()


frmSplash1.Show

End Sub

AFTER SIGNUP PAGE


End Sub



Unload Me Form5.Show

End Sub

Private Sub Command3_Click() Unload Me Form2.Show End Sub


End Sub


End Sub


End Sub


End Sub



End Sub


End Sub

Private Sub Form_Load()

End Sub


WHEN SELECT STUDENT OPTION


End Sub


End End Sub


Private Sub Command2_Click() Form11.Show

End Sub


Private Sub Command4_Click() Me.Refresh

End Sub


End Sub


WHEN CHOOSE PRINT DETAILS BUTTON

Private Sub Command1_Click() Command1.Visible = False Command2.Visible = False Form11.PrintForm Unload Me

End Sub

Private Sub Command2_Click() Unload Me


End Sub

Private Sub Form_Load() Label3.Caption = Form4.Text1.Text Label4.Caption = Form4.Label1.Caption Label5.Caption = Form4.Label3.Caption Label6.Caption = Form4.Label5.Caption Label22.Caption = Form4.Label2.Caption Label24.Caption = Form4.Label4.Caption Label25.Caption = Form4.Label6.Caption Label26.Caption = Form4.Label22.Caption Text9.Text = Form4.Label24.Caption

End Sub

Private Sub Label27_Click()

End Sub


WHEN SELECT TEACHER OPTION


End Sub


End Sub


Private Sub Command2_Click() Form12.Show End Sub



End Sub


End Sub


WHEN CHOOSE PRINT DETAILS BUTTON


Private Sub Command1_Click() Command1.Visible = False Command2.Visible = False Form12.PrintForm Unload Me

End Sub

Private Sub Command2_Click() Unload Me End Sub

Private Sub Form_Load() Label3.Caption = Form5.Text1.Text Label4.Caption = Form5.Label1.Caption Label5.Caption = Form5.Label3.Caption Label6.Caption = Form5.Label5.Caption Label22.Caption = Form5.Label2.Caption Label24.Caption = Form5.Label4.Caption Label25.Caption = Form5.Label6.Caption Label26.Caption = Form5.Label22.Caption Text9.Text = Form5.Label24.Caption

End Sub


WHEN SELECT STUDENT FEE DETAIL OPTION


End Sub



End

End Sub

Private Sub Command2_Click() Form13.Show

End Sub



End Sub


En


WHEN CHOOSE GENERATE SLIP BUTTON


WHEN SELECT STUDENT OPITON DIRENCT FROM HOME PAGE


WHEN SELECT TEACJER OPITON DIRENCT FROM HOME PAGE


WHEN SELECT STUDENTFEE OPITON DIRENCT FROM HOME PAGE

Option Explicit


End Sub


Private Sub Picture1_Click() If Text1.Text = "STUDENT" And Text2.Text = "STUDENT" Then MsgBox "SIGNUP SUCCESFULLY" Unload Me Form4.Show Form4.Command1.Enabled = False

ElseIf Text1.Text = "TEACHER" And Text2.Text = "TEACHER" Then MsgBox "SIGNUP SUCCESFULLY" Unload Me Form5.Show Form5.Command1.Enabled = False ElseIf Text1.Text = "STUDENTFEE" And Text2.Text = "STUDENTFEE" Then MsgBox "SIGNUP SUCCESFULLY" Unload Me Form8.Show Form8.Command1.Enabled = False ElseIf Text1.Text = "TEACHERS" And Text2.Text = "TEACHERS" Then MsgBox "SIGNUP SUCCESFULLY" Unload Me Form9.Show

Else MsgBox "INVALID USERID PASSWORD" End If

End Sub

Private Sub Picture2_Click() Unload Me END SUB


AFTER SIGUP DIRECTLY FROM TEACHR OPTION


End Sub



End Sub

Private Sub Command2_Click() Form12.Show End Sub



End Sub


End Sub


TESTING Software testing is a critical element of software quality assurance and represents the ultimate review of application, design and coding. The aim of testing process is to identify all defects existing in a software product. Testing provides a practical way of reducing defects in a system and increasing the user’s confidence in a developed system. TESTING OBJECTIVE:-

  

Testing is a process of executing a program with a program with the intent of finding of error. A good test case is one of that has a high probability of finding an as yet undiscovered error. A successful test is one that uncovers as an yet undiscovered error.

The objective is to design test cases that systemically uncover different Classes of error and do so with a minimum amount of time and effort.

This process has two parts:

a)Planning:-This involves writing and reviewing unit, integration, functional, validation and acceptance test plans.

b) Execution: This involves executing these test plans, measuring, collecting data and verifying if its meets the quality criteria. Data collected is used to make appropriate changes in the plans related to developments and testing. The quality of a product or item can be achieved by ensuring that the product meets the requirements by planning and conducting the following tests at various stages.


The main types of software testing are:

COMPONENTS:

Starting from the button the first Level is “Component Testing”, sometimes called unit testing. It involves checking that each specified in the “Component Design” has been implemented in the component. In theory an independent tester should do this, but in practice the developer usually does it, as they are the only people who understand how a components work. The problem with a component is that it performs only a small part of functionality of a system, and it relies on cooperative with other parts of the system, which may not have been built yet. To cover come this, the developer either builds, or uses special software to trick the component into believing it is working in a fully functional system.

In our project we perform three levels of testing. 1. Unit testing 2. Integration testing 3. System testing 1. Unit Testing :In unit testing we tested different modules of system in isolation. To test a program we provide set of inputs to program and observe whether it behaves as expected .in unit testing we user white –box approach to develop the test cases.


2. Integration Testing :During integration testing we integrated both modules of system using integration plan. In integration testing we tested the module interfaces. For integration testing we used mixed approach to test the modules .We use incremental approach to integrate the systems module.

3. System Testing :System testing is actually series of test whose primary purpose is to fully exercise the project .We performed three type of system testing

i) Validation testing ii) Recovery testing iii) Security testing Validation Testing:The purpose of validation testing is to know whether requirements of project are fulfilled or not. For this we perform two type of testing.  Alpha testing  Beta testing Alpha testing :For alpha testing we simulated the required environment within the organization and used the system.

Beta testing:For beta testing we launch the system temporarily ans test it from outside the organization. 72 SANTOSH KUMAR (01121001909)

Recovery testing:In recovery testing we forced the project to fail in variety of ways and verify that recovery is performed properly. Here the recovery testing has been done from all the aspects including automatic reinstallation, check pointing mechanism, data recovery etc. All the above points are evaluated for correctness.

Security testing:Security testing attempts to verify that protection mechanism built into a system evil in fact protect it from improper penetration. Here we testing that any unauthorized user could not change the information of website .The project has been thoroughly processed through security testing and given enough time and resources for testing the penetration in to the project.



ADVANTAGES OF THE PROJECT:

The system has the following advantages:       

The data can be maintained and updated easily with minimum efforts. The complex reports were generated easily and without any delay so that important decisions regarding to control the exam deficit, recovery of data, and declaration proof the results can be done without any delay. The allocation of the examination schedule is immediately provided to the students as earlier. Various kinds of queries put in by the administration can be answered immediately. Various level of security is maintained for the information at the most. Grouping and sorting of the records is maintained. Fast retrieval of information regarding the examination can be done.

DEFICIENCIES:

Of course we can not claim to have the best flexible information system, but all the same we do have the most flexible information system that can be implemented in most of the organization. Almost all the aspects that are existing in the current manual system has been taken to a number of accounts. The system is very much user friendly. Even without having working experience of the system, it can be handled in a very efficient manner. The screens are adjusted in a structured hierarchical manner such that one can move from one screen to the another easily with the help of menu.


Limitations



The software is not centralized.



The billing module does work for floating point numbers.



There is not payroll system for the employee.



Each and every department works Independently and generates its own bill.



This software takes the present date from the system so if the



system date is anyhow wrong the software may malfunction.



This software does not provide backup.



The hotel personal expenses billing is generated on monthly basis.

FUTURE APPLICATION OF THE PROJECT

By this time according to the user we have completed all the requirements but still there are some section which can be computerized in this system and after that one can say it is a fully completed “hotel management system”.

It will be save money according to its performance also will be helpful fast accessing of the organization.


BIBLIOGRAPHY:



Visual Basic 6.0 in 21 Days , Author :-Greg M. Perry, Publisher:-SAMS



Aptech Academy’ books, Author:-Valery V Shmelef



6.0. VB Complete reference by Paul Sheriff, Indianapolis, Ind. : Que ; Hemel Hempstead : Prentice Hall, 1998



www.sourcecode.com


COLLEGE MANAGEMENT SYSTEM ON VISUAL BASIC ( BY SANTOSH KUMAR--- IIMT , KARKARDOOMA)

Recommend Documents