27 Documents+tbl
27 Documents+tbl
27 Documents+tbl
S.NO.
CONTENT
CERTIFICATE
DECLARATION
ACKNOWLEDGMENT
PREFACE
INTRODUCTION
PROJECT OBJECTIVE
ABOUT MS-ACCESS
10
11
12
13
TABLE STRUCTURE
14
FORM
15
CODING
16
TESTING
17
IMPLEMENTATION
18
CONCLUSION
19
BIBLOGRAPHY
20
GLOSSARY
CERTIFICATE
This Project Report has not been submitted any where for any other
course.
We wish them for better future.
(Sign of HOD)
SELF CERTIFICATE
This Project Report has not been submitted anywhere for any
other course.
Thanks
5012105002
5012105022
CERTIFICATE
This Project Report has not been submitted any where for any
other course.
We wish them for better future.
DECLARATION
We hereby declare that our group accomplished the project entitled INSTITUE
MANAGEMENT SYSTEM. This work has been done genuinely by our group
and does not involve any piracy and external sources of efforts.
Within the duration 01st July 2008 to 10th November 2008 at Bhilai Institute of
Technology, Computer Application Department. We should be very thankful to
Mrs. Sunita Soni (H.O.D computer application department) for permitted
ourselves to do this project. This project is Submitted to Chattisgarh Swami
Vivekanand Technical University, Bhilai (C.G) for the partial Fulfillment of the
requirement for the certificate of MCA- Sem- IIIrd .
ACKNOWLEDGEMENT
PREFACE
A practical training needed to be compulsory in each and every field in
todays scenario. This report deals with the communication between an
organization and a computer professional. It also describes about the
services provided by the software-professionals to their customers.
The key objective of this report is to get practical exposure over
the hardware and software being used now in an organization. Hence all the
suggestions for its improvement will be appreciated.
Attempt has been made to present the subject in lucid manner.
Every important section is supplemented with worked out examples. We
have freely consulted the available material of well-known professionals in
this field. We acknowledge, gratefully the help we derived from
professionals and faculties like Mrs. Any Thomus [READER- MCA
department, Bhilai institute of technology, Durg {C.G}]. We are indebted to
principals and Heads of the MCA department for providing us library
facilities.
We hope that the present information will also be
useful to our juniors and other disciplines.
Finally we wish to express our sincere thanks and appreciation to
Mrs. Sunita Soni {respected H.O.D} who have been a constant source of
encouragement and assistance.
INTRODUCTION
We are making a project for ABACUS Institute entitled as INSTITUTE
MANAGEMENT SYSTEM. This project is prepared as instruction given by the
honor of Abacus institute.
EXISTING PROBLEMS:
The following are the problems with the existing manual system which
leads us to develop this software:
1) Problem with present methodology : The present system of maintaining
the records ( without using any Computerised system ) is totally manual
which creates human error.
2) Lack of efficiency : Due to the manual work done.
3) Complexity: Handling of a large data is complex.
To overcome these difficulties of the manual system , we now create
a Computerized Information System is totally digitized and it is used for
maintaining the records, that records should contain Name of the
students/staff , Purpose of staying in this system, Personal information and other
interrelated information that is related to any member of the institute. We
hope that these features are seems to be helpful for any user.
PROJECT OBJECTIVE
Specific Requirement:
Hardware Requirement:
Monitor :- 800x600 resolution at 256 colors minimum.
Memory :- Approximately 1GB of on board memory.
I/ O
MHz
IDE :
VB provides the IDE( Integrated Development Environment).
The IDE is where you do programming in VB-just as the same name
suggests. You develop the IDE. It is called integrated because we can access
virtually all of the development tools that we need from one screen called as
an interface.
Over the year the IDE become more powerful and with that power has
overcome from the complexity. The IDE used to be more or less invisible to
the programmer but now that there are ActivX controls to add version
resource object to study. The IDE is also commonly referred as the dsign
environment or the program.
The visual basic IDE has three different states.
o Design
o Run
o Debug
The IDE composed these components.
Global Items
Global items are accessible to all modules and form in a
project and you declare them with the public key word. However Microsoft
recommends that you keep the number of global items to an absolute
minimum and, infect suggest their use only when you need to communicate
between forms. One reason to avoid global variables is their accessibility
from anywhere in the program; while you are working with the global
variable in one part of a program, another part of the program might be busy
changing that variable, giving you unpredictable results.
Forms
Forms are familiar to all VB programmers, of course they are
the templates you base windows on. Besides standard forms, VB also
support Multiple Document Interface(MDI) forms, as well as whole number
of predefined forms.
Modules
Modules are collection of code and data that function
something like object in object-oriented programming (OOP), but without
defining OOP characteristics like interface, polymorphism and so on. The
point behind the program. Well discuss the importance of doing this later in
this project when we cover VB programming techniques and style; breaking
a large program into smaller, self-contained modules can be invaluable for
creating and maintaining code.
ABOUT MS-ACCESS
Access is such a rich and powerful database access tool that most people are
most familiar and finds it very convenient to use while manipulating
databases. Access makes it easy for users even beginners to work with
databases you can create table, edit data and use queries to find the data you
want with very little effort, and wizards that can do work of designing data
entry forms, reports and mailing labels for you.
Access has become the best selling database
management programs because of its combinations of power and easy use. It
is powerful enough that developers can use it to create entire applications.
Yet it is easy enough to use that in short times. An access database consists
of tables that hold the data and the entire related object such as queries,
forms and reports that are used to manage data.
Access also makes it easy for developers to
create applications. It includes an entire programming language, visual basic
for applications, and its interface is so powerful that developers can create
much custom application without programming .Access queries reports and
macros are powerful to do most of the work required in the programming.
TESTING
System testing is designed to uncover the weakness, which were not found
in earlier tests. The system testing will be possible when all the modules are
integrated and implemented by its user in its operational environment. This
includes the forced system failure and validation of the total system. The
total system is also tested for recovery and fallback after various major
failures to ensure that no data are lost during the recover.
Unit Testing
Unit Testing is done by debugging each and every
commands of the software
Features To Be Tested
The features to be tested are:1).Data should not be redundant.
2).Deletion is occurring correctly.
3).Updating of data
Approach For Testing
A very simple and straight forward approach is used for testing which
involves the debugging of each and every feature of the INSTITUTE.
1). Stored data.
2). Deletion and updating of data.
----------------- X -----------------
IMPLEMENTATION
A system should always be tested thoroughly before implementing it, as
regards its individual program and the systems a whole. This is because
implementing a major job, which requires a lot of man hours and other
resources, so invent of an error being detected after implementation may
cost a lot. Effective testing early in a process translates directly into long
term cost savings reducing a number of errors. This is also necessary
because in some cases, a small error before installation may explode into
much larger problems. After a thorough testing of different aspects of the
system as described above, the system is implemented. When it is
implemented , it comes across the real world manifestation of processing
functions and information structures.
CONCLUSION
1.
2.
3.
4.
5.
----------------- X -----------------
BIBLIOGRAPHY
Visual Basic
1. VB 6 Programming Black Book by Steven Holzner .
2. Mastering visual basic by Evangelos Petroutsos.
----------------- X -----------------
GLOSSARY
Visual Basic
Programming.
Microsoft Access
----------------- X -----------------
ADDMISSION TABEL
COUNCELLING TABEL
FEES TABEL
STAFF TABEL