0 ratings 0% found this document useful (0 votes) 16 views 59 pages Library Management System
The document outlines a library management system, detailing its software and hardware requirements, system overview, and advantages over existing manual systems. It emphasizes the use of Visual Basic for developing user-friendly interfaces and automating tasks like book searches and report generation. Additionally, it describes various database objects in MS Access and the functionalities of the system, including data entry, record management, and reporting capabilities.
AI-enhanced title and description
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content,
claim it here .
Available Formats
Download as PDF or read online on Scribd
Go to previous items Go to next items
Save library management system For Later page 12
INDEX
l CONTENTS — =
ACKNOWLEDGEMENT
LIBRARY PROJECT OVERVIEW
3 SOFTWERE OVERVIEW
> ABOUT FRONT END
> INTRODUCTION TO VISUAL
BASIC
ADO MODEL
>
> DATA REPORT
>
>
[SR.NO
INTRODUCTION TO MS ACCESS
ACCESS DATABASE CAN
COINTAIN SEVE TYPES OF
DATABASE OBJECT.
> DATA TYPE SUMMARY
4 SOFTWERE REQUREMENT
SPRCIFICATION (SRS)
> LIMITATION OF EXISTING
SYSTEM.
> SCOPE OF SYSTEM 4
> ADVANTAGE OF SYSTEM
> LIMITATION OF SYSTEM
> OBJECTIVE SYSTEM
> SYSTEM OVERVIEW
5 HARDWERE & SOFTWERE
REQUIREMENT
> HARDWERE REQUIREMENT
> SOFTWERE REQUIREMENT
ADVANTAGES
7 DFD
.Y. B.COM. Computer Applicationyr
page (2
ne USED/HOW USED:
iyrut 10 ImETURN
our : MAMBER
surnustnTARY —_ITCONTENT REMINDER Fon OOK
owen DESCRIPTION : RETURN BOOK = BOOK
9, 1ssUE OATE
AME: 1SSUEOATE
Aulas:NONE
wHeRE USED/HOW USED:
1} CALCULATE PENALTY
input TO
ourrut : TRANSACTION
supnigMENTARY _:1T CONTENT ISSUE DETAIELS TO CALCULATE PENALTY
cqnTENT DESCRIPTION : ISSUE DATE= BOOK NAME 415SUE DATE RETURN DATE +DUE DATE
10. PENALTY REPORT
Name: calculate penalty
Alias : none
Where used / How used
Input To ; calculate penalty
Output : Member entity
Supplementary : it content penalty report
TY. B.COM. Computer ApplicationTY, B.COM. Computer ApplicationCONCLUSION
CONCLUSION
Yy, -
| Mt computer application
Pee lenpage 133
OBIECT
Anobject variable is used t
by the object data type and after that they are set (0 any
application with set command.
data type treated as val
special types of variable declare without ant
sre capable of containing any type of value. If one cans data tYP© !
declaration statement then variable will treated as a variant.
jon they are declared
0 refer any object in the: applicati
of the object in the
riant they
in variable
TY. B.COM. Computer Application——_—
I
}
|qoxt1 SetFocus
rextl.Locked = False
fext2.Locked = False
rext3.Locked = False
TextS.tocked = False
fext6.Locked = False
end Sub
private Sub Command3_Click()
adode1.Recordset.Delete
End Sub
private Sub Command5_Click()
adodc1.Recordset. Update
MsgBox "record saved", vbinfarmation
End Sub
Private Sub Command6_Click()
Unload Me
End Sub
Private Sub Command?_Click()
Adodc1.Recordset. Move Previous
End Sub
Private Sub Command8_Click(}
Adodc1.Recordset.MoveNext
End Sub
at Sub Command9_Click()
Yodel Recordset.MoveLastyertB.tocked = False
fexto.tocked = False
end Sud
jate Sub COMMANd4_Click()
jaodcl.Recordset.Update
fesgBox "record 32¥€C", VINformation
end Sub
private Sub Command. Click()
+ dodel Recordset.Delete
end Sub
private Sub Command6_Click()
unload Me
end Sub
private Sub Command7_Click()
Adodel.Recordset. MoveFirst
end Sub
Pivate Sub Command8_Click()
Adodc1.Recordset.Movelast
| indSub
Private Sub Timer1_Timer()
fxd Sub
bite Sub Form_Load()
Sd SubTY, B.COM, Computer ApplicationEE
= False
io tacked = False
rerepuocked = False
eea.ocked = False
Tepacs Recordset AGNEW
ents SetFocus
end Sub
private Sub Command3_Clickl)
adodci.Recordset.Delete
End Sub
private Sub Command5_click()
Adodei Refresh
Adodc1.Recordset.Update
End Sub
Private Sub Command7_click()
‘Adode’.Recordset.MovePrevious
End Sub
Private Sub Command8_Click{)
Adodc1.Recordset.MaveNext
End Sub
Private Sub Command9_Click()
Adodc1.Recordset.MoveLast
End Sub
Private Sub Form_Load()MEMBER MASTER
(CREAT Meme
prvate Sub Command. _Click()
dade Recordset. MovePrevious
nd Sub
vate Sub Command?_Click()
Model Recordset. MoveNext
fndSub
Sub Command3_Click()
‘Adodc1 Recordset.AddNew
Tal SetFocus
Tet Locked = False
Tet2Locked = False
etRlocked = False
"et6 Locked = FalsePage iaa
USER INFO.
‘BOOK DETAILS BOOK INFOPage \as
TABL:. DESING
Te
5.COM. computer ApplicationyemBER TABLE
Page 136
go NAME DATA TYPE SE
ane CHAR 25
io INT 10
FSSHORD INT 2 +
Fqit CHAR 2
ME INT. 10 = |
[sSUE TABLE
FELD NAME DATA TYPE SIZE
3NO INT 3 -
10 INT. 0
iSSUE DATE DATE/TIME 10
‘DUE_DATE DATE/TIME. 10
COPIES | AVALABLE INT 02
ISSUE RETURN TABLE
[FIELD NAME
(BNO
DATA TYPE Se
INT i _
[20
ic INT
[ISSUE_DATE DATE/TIME 10 _
INT _
[COPIES _DATE
[RETURN DATE DATE/TIME i
[_DUE_DATE DATE/TIME 30 ao
TY. B.COM. Computer ApplicationSOFTWARE OVERVIEW
1... B.COM. Computer Applicationa
(ypeoT WOIAN ans AeA
99S pus
MIN TWO 4)qyy
()9911 MN 4S arenyy
ns,
n0us Twin
{oud UALSVINYIENIIN 45 2
nous guUOy
(JpeoTWsosIGW GAS areALdNS PH
qns 4
|
(991 HOUaSae ans are
gasps
Oren“ Wuosuazawy ans
ans hl
mous nl
yewuoso 05
19 LWgestatocked
faoacr Recordset AddNeW
ent SetFocus
end Sub
private Sub Command3_Click()
‘adodel Recordset Delete
End Sub
Private Sub CommandS_Click()
adodci Refresh
Adode1. Recordset. Update
End Sub
Private Sub Command? _Click()
Adode!. Recordset. MovePrevious
End Sub
private Sub Command8_Click{)
‘Adodcl.Recordset, MoveNext
End Sub
private Sub Command3_Click()
‘Adode1 Recordset.Movelast
End Sub
Private Sub Form_Load()
End SubP
| page (22
ADVANTAGES
immediate retrieval of information
Better storage capacity
Better sorting of information
Quick sorting information
Preparation of efficient reports
Accuracy of data that no redundancy hence no inconsistency
Easy to update the information
1.¥. B.COM, Computer ApplicationSEES EE eee
Page 128
UIREMENT SPECIFICATION
During the study of existing following point are observed
There is manual system, so lot of time is consumed for searching the
requirement book.
Exam papers CD are not available
Student manpower is required & regular maintenance is Complicate
I medicated response to the inquiries is difficult
Book searching is a complicated task as the librarian has to search if
manually. It is time consuming process
‘SCOPE OF SYSTEM
* The library management system for the books, Member,
* Transaction making was little tedious and time consuming so there was
a need for making it can automated computerized System.
The computerized system named “LIBRARY MANAGEMENT SYSTEM”
Makes the job of librarian more easier and faster it has solved problem
like searching book, Member information, Book Information, Publisher
Information on which librarian can work much faster and find the
solution in easy way.
ADVANTAGES OF SYSTEM
Arrangement of books is according to different department so user can
easily find the book from library.
Interact with system user friendly.
« Easy searching.
Member can resave book anytime.
Librarian can easily find different book report (issue, return, find, book,
damage book etc...)
TY. B.COM. Computer ApplicationSOFTWARE OVERVIEW
ABOUT FRONT END
Front ends are tools that basically serve as data entry screen or are used in
order to facilitate and users, They basically form a part of GUI Le. More user
interactivity is fulfilled. The parameters that are entered via the controls are
jsual Basic.
INTRODUCTION ABOUT VISUAL BASIC 6.0
| Rapid Application Development (RAD) tool that
raphical interface that is intuitive and easy to use.
amming tool that can be used to write kind of
Visual Basic is Graphical aims
at providing the user with ag
Visual Basic is a popular progr
visual application ranging froma game database management application. Now
a day visual basic bring widely used for developing different types of
application and performing various types of jobs. With visual basic, once can
automate everyday task add custom required feature and function to suit once
need, and create application, which makes that are required to develop a
graphical under interface as ready to use components.
The Visual Basic programming environment is also called Point and Click
environment. The programmer does not have write to the code to create and
Display commonly required user-friendly feature each time around. When the
programming needs a specific user interface feature such as a button, he selects
the appropriate ready to use components providing by the Visual Basic
programming environment. These components can be moved, resized and
required. So a Visual Basic programming environment automates the process
.Y. B.COM. Computer Applicationv
page 130
ve date +
ent description : Penalty Report = book
ok name + book price + Is
nt
cof en cate + penalty
11,REQVEST FOR REPORT
ame: request for report
one
ed / How used
lias:
where Us
input To: Generate report
output : librarian
supplementary: it content request report
Content description : request for book report = Member id + book name
12.REPORT DATA
Name : Report data
Alias ; none
Where used / How used
Input To : Library Entity
Output ; Generate repot
Supplementary : it content report data
Content description : Report data = issue report
13. BOOK INFO
Name ; Book Info
Alias : none
TY. 8.COM. Computer Application|
|
PROCESS
' SPECIFICATION
1Y.8.COM. Computer Applicationpage |20
ADVANTAGESsrecordset. AddNew
a setFoCus
rem
rocked = False
mip ened = False
tocked = False
= False
10
re
gna sub
private Sub Command3_Click()
sdodc1 Recordset. MovePrevious
end Sub
private Sub CommandS_Click()
Adodc1.Refresh
Adodc1 Recordset. Update
MsgBox “record seved", vbInformation
End Sub
Private Sub Command?_Click()
Model Recordset. MovePrevious
fd Sub
fr
"vate Sub Command8_Click()
Recordset. MoveNext
Sub~w
ACTION BUTTON
ADD: This button is used to insert new record in specification form
when we press.
DELETE: This button is used to delete a particular.
EDIT: This button is used to edit records.
EXIT: This button is used to save from specification records.
SEARCH: This button is used to find from specification records.
MOVE FIRST: This button is used to move curser to first.
MOVE LAST: This button is used to move curser to last records.
MOVE NEXT: This button is used to move curser to next records.
MOVE PREVIOS: This button is used to move curser to prevos records.
TY. B.COM. Computer Applicationpage l9
interface using
ofereating the user interface by provides the designe nee .
‘¢ ready to use components. In addition, it also i ponents used
sesoctating the user serten logically defined code with the comPOnSN MA
aemprojedl. My project on “LIBRARY MANAGEMENT! Te% Ty
Transaction happening in Library inan organization/instin vy mouse click.
heproved easier as more ofthe tasks obtained are managed bY 8 AAT ay
‘The final reports and other facilities and calculation are calcula
There are main object available in the ADO
COMMAND: Which is used to execute the queries in data?
CONNECTION: Which is used to establish connection?
RECORDSET: Which is representation record set the queries?
DATA REPORT
in any system report generation is always required. Data report is a report
development tool, which is supplied with visual basic, with data report, the
process of creating report, becomes very simple using data report designer,
and there is no need to write complex programs. Data reports provide number
of selection of different report output to generate report
Using any particular format you get the desired output without setting the co-
ordinates. Data reports a rich set of calculation tools and functions that enable
you to make almost type of calculation on database field’s data,
TY. B.COM. Computer Application
ZtSOFT WAIRIE
REQUIUREMIENT
Spec ification
(SRS)
7.¥. 8.COM. Computer ApplicationMeta
ROM LAYOUT WITH CODING
F
i COM. computer ApplicationsySTEMOVERVIEW
The library management system ts flexible and easy to understand
We can enter the record the new book, member, and newspaper and
of new book member,
member category and retrieve the det:
Newspaper and member category in the library.
«There are some modules in library management system. Master
Modules, reports modules and search.
publisher Master,
Master entry, book entry, user entry, member master,
printer master, member category master.
Transaction: The module calculates the fine member wise on Returning
book.
Reports: reports can be generate like member wise reserved book,
publisher, member, issue return book, member wise added book report
Ete...
Search: These modules maintain the search of book, master, member,
category, publisher, printer, vender, designation, department,
newspaper etc...
TY. B.COM. Computer Application‘ADD BOOK
private Sub Command1_Click(Index AS Integer)
Unload Me
End Sub
Private Sub Command10_Click()
‘Adode1 Recordset. MoveFirst
End Sub
Private Sub Command2_Click()
Text1.Locked = False
Text2.Locked = False
Text3.Locked = False
Text4.Locked = Falseans pug
(yoo HOWWas ANS A1eAUd
qns pug
mous’ EwW04
(ppiio WHOINYNLAY 49S ayeAud
qns pug
moys'Swuo4
(1911 WHOSALTVNAd 49S ayenld
ans pa
(ayse moys TwH04
1D WaLSWWeaaW3aW ans ayenlid
ns pupage [at
IcROSOET ACCESS DATABASE CAN CONTAIN SEVEN TYPES.OF
DATABASE OBJECT
1, Table store data
m one more tables
2. Queries gather data you request fr
the data in from, or print it in report
jew, edit or
3. You can view or e
4, Forms display data form table or queries so you can vi
enter Data
5. Reports summaries and present data from table and queries so you
can print or analysis it
6. Macros automatic your database by performing action you specify
Without the need of
Performing,
7. Modules store access basic code you can write to customize, enhance
| and extend your database
TY. B.COM. Computer Applicationpage 119
processor: Pentium 4 2GHz
Ram: 2GB
Hard Drive: 100GB
Keyboard
Mouse
SOFTWARE REQUIREMENT
Operating system: Window XP /Windows-7
Developing tool: Visual Basic
Database: MS access
; T.Y. B.COM. Computer ApplicationLast
oraset Move
records
ae
rs 0
form toad)
private SUF
end sud
private Sub Label _clickl)
Saige me tre tome
Dim LNAME As String
Dim PASSWORD As Integer
Private Sub Check1_Click()
Wf Text2.PasswordChar = "*" Then
Text2.PasswordChar = ""
Else
Text2.PasswordChar = "*"
End ifwy
nore used / How used
spput TO TER: fOr
output
supplementary :It content book info
t librarian entity
nt description : bi
conte Ook info + book name + isbn + Author + Publi
ae hor + Publisher
14,ACC NO OF BOOK
,
}
name: Acc no of book
‘Alias sone
where used / How used
Input To : librarian
Output : Register book
Supplementary : it content acc no book
Content description : Acc no of book
TI
Y. 8.COM. Computer Applicationend 50>
ate sub Labels 1K()
eng Sub
private Sub Form.Loadt)
ena sub
00K DETAILS
Ce
ene |
2
= ae a ay
ate
me =
ee ~
Private Sub Command1_Click()
Unload Me
End Sub
Private Sub Command10_Click()
Adodc1.Recordset.MoveFirst
End Sub
Private Sub ‘Command2_Click()PAYMENT INFO
SAE DETANS Aner. GU7e5 tite
vy, 0
8.COM. Computer Application| ee
DATA DICTONARY.
1.REQ.FOR CREATE MEMBER
NAME: REG.FOR CREATE MEMBER
utas : NONE
wHeRE USED / HOW USED
MEMBERSHIP MANAGEMENT
input TO
oureut MEMBER
SUPPLEMENTARY IT CONTENT CREATE MEMBER
CONTENT DESCRIPTION : REQ. FOR MEMBER NAME + AGE +BIRTH DATE +ADDRESS +
‘PHONE+ EMAIL
2. MEMBERSHIP DETAIL
NAME : MEMBER DETAILS
| ALIAS : NONE
| WHERE USED/ HOW USED:
| input 10 !MEMBER
oureur |EMBERSHIP MANAGEMENT
SUPPLEMENTARY :IT CONTENT CREATE MEMBER DETAILS
CONTENT DESCRIPTION :REQ. FOR MEMBER =NAME +AGE + BHIRTH DATE+ ADDRESS PHONE
FEMAIL
3.SEARCH FOR BOOK
EG.FOR CREATE MEMBER
NAMI
ALIAS:NONE
TY, B.COM. Computer Applicationprivate Sub Label12_Click()
End Sub
private Sub Label8_Click()
end Sub
Private Sub Text2_Changet()
End Sub
LosT BOOK
Private Sub Commandi_Click(index As Integer)
End
End Sub
Private Sub Command10_Click()
Adodc1 Recordset. MoveFirstACKNOWLEGEMENT
ndebted to our guide Mrs. Pankita Desai
e of inspiration for his constant support
We are thankful
We are extremely grateful and remain i
& Miss Sangita Pawar for being a sourc
in the Design, implementation and Evaluation of the project.
to them for their constant constructive criticism and invaluable suggestion,
which benefited us a lot while development the project on “LIBRARY
MANAGEMENT SYSTEM”. She has been a constant source of inspiration and
motivation for hard work. Through this column, it would be our almost
pleasure our warm thanks to her for their encouragement cooperative and
consent without which we mightn’t be able to accomplish this project.
We also express our gratitude to Miss Sangita Pawar for providing us
the infrastructure to carry out the project and to all staff members who were
directly and indirectly instrument in enabling to stay committed for the project.
Thank you.ACKNOWLEDGEMENT
T.¥. B.COM. Computer ApplicationA
nd Sub
pavate Sud COMMAND] Click()
anload Me
end Sub
private Sub COMMAND Click()
Text Text = "SDD" And Tert2 Text «
“St
molform1.Show 00123" Then
formé. Hide
fe
MagBox “INVALID PASSWORD OR USER NAME, TRY AGAIN|!"
Text2.SetFocus
rdf
find Sub
Private Sub Form_Load()
End Sub
Private Sub Text1_Change()
Tert2.BackColor = VBGREN
fnd Sub
Private Sub Text2_Change()
Text2.PasswordChar = “*"
Tent2 BackColor = vbYellow
£94 Sup
MOI FoRMhone inte
Reauest for reoort
Rennrt data
CN
BAR 13st
Membership detalis
Sst)
Book issue details
—— Ace. No for book:
Remind for return book
Penalty recort
T¥.B.COM. Computer Application~
TAB!
Page \37
_gwinte | PATA TPE Tse ——
ea [DATATYPE
é Bara
is WT i ——
oe ———
Me ——
se CHAR a
d ifs a“ 8s
Mg.
8.0m,
. Computer Applicationprivate Sub Command_Click()
unload Me
end Sub
private Sub Command2_Click()
AdodeL Recordset. AddNew
Text1.SetFocus
Text1.Locked = False
Text2.Locked = False
Text3.Locked = False
Text4.Locked = False
Text5.Locked = False
End Sub
Private Sub Command3_Click()
Adodc1.Recordset.DeleteFORM STRUCTURE
EeEy]
| =mpage 16
Library management system isa system which maintains the information about
the books present in the library. The book received in the library is entered in
books entry from and the new members are entered in the member's entry
from, When the members get the desired book the same is issued on the
availability of the books is also entered into the book issue the members has to
pay the fine if any on the basic of the days delayed deposit of the book in the
library.
This project (library management system) is a general purpose project, which
satisfies all the needs of a typical library system. The project has been tailored
to solve the problem faced by the librarian, Members and Students in a manual
processing of the information.
Library usually perform their work manually in which amount of time and
human efforts is wasted in retrieving information, handing of huge data,
generation of reports. Updating of data etc. these problem can be easily solve
the automation of existing library information.
TLV. B.COM. Computer Applicationend Sud
esub Commanda_Clickt(]
privat
set. MoveFirst
‘adode Records
end Sub
private Sub Command5_Click()
‘adodcl. Refresh
adodcl Recordset. Update
MsgBox “record saved", vbinformation
End Sub
private Sub Frame1_DragDrop{Source As Control, X As Single,
. YAS Single)
End Sub
private Sub Command6_Click()
Adodc1.Recordset.MoveLast
End Sub
Private Sub Command? _Click()
Adodc1.Recordset.MovePrevious
End Sub
Private Sub Command8_Click{)
Adodc1.Recordset.MoveNext
End Sub
Private Sub Form_Load()
End Sub
Private Sub Label2_Click()Page 132
DATA TYPE SUMMARY
VISUAL BASIC RECOGNIZE FOLLOWING TYPES OF VARIABLE AS :-
© NUMERIC
¢ STRING
« BOOLEAN
« DATA OBJECT
© VARIANT.
NUMERIC
Like other programming languages visual basic provides numeric variables
they are:
Integers, single, double, byte, long, currency. Integer variable are used for the
non functional values. It stories values in the range from -32768 to 32768, long
data types is used for range -2147483648 to 2147483647, single data type is
used for fractional values from -3.402 e 38 to 1.40 e 45, double precision
floating point numbers is capable of containing values from -1.797 e 308 to
4.940 e 324 and positive numbers. Currency is used for fixed-point numbers
with four decimal digits, It can represent numbers in the rang -
922377203685477.5808 to 377203685477.5807. byte data type is used for
representing numbers from 0 to 255. String variable are used to store string
type data.
BOOLEN
Boolean data type store true/false values. Boolean variable are used in testing
condition.
DATA
Date & Time variable are stored internally in a special format, but you don't
need to know the exact format. Date variable are declared by following
Statements.
TY. B.COM, Computer Applicationr
page \27
rene USED/HOW USED:
}EMBERSHIP MANAGEMENT
input TO
ourur IMEMBER
juprteMeNTARY IT CONTENT CREATE MEMBER
ION:
coNTENT DESCRIPTION : REQ. FOR MEMBER= NAME FAGE +BHIRTHDATE ADDRESS +7HONE
emalt
A.sEARCH DATA
NAME : SEARCH DATA
ALIAS :NONE
WHERE USED/HOW USED:
Input TO EMBER
oureur SEARCH
SUPPLEMENTARY HIT CONTENT FOR SEARCH DATA
CONTENT DESCRIPTION :SEARCH DATA = ACC.NO +B0OK NAME + ISBN + AUTHOR AVAILABLE
5.B00K DEATAILS
NAME: BOOK DEATAILS
ALIAS:NONE
WHERE USED/HOW USED:
:BOOK ISSUE MANAGEMENT
INPUT TO
ourPUT BOOK MASTER
SUPPLEMENTARY HIT CONTENT BOOK ISSUE
‘TY. B.COM, Computer Applicationa
Private Sub OFORM2_Clickl)
Forms.show
End Sub
private Sub ADDBOOKFORM_Click!)
Formé show
End Sub
private Sub BOOKFORM_Clickl)
Forma Show
End Sub
private Sub CEXIT_Click(index As Integer)
Unload Me
End Sub
Private Sub EDIT_Click()
End Sub
private Sub FEXIT_click()make it easy for a person to store,
‘Access is a flexible program that works for works for both simple and complex
database project. It’s also a relation database. Which means it let’s you define
rel
th
learnas we work.
110
which enables you to retrieve desired
facility called the Microsoft
you can specify selection criterta,
hierarchical reports.
in a reports, visual basic provides another
reate
ections which are given
records ii
data report generation that feature ability to
In data reports you can see the five different st
Below:
1, REPORT HEADER
2. PAGE HEADER
3. DETAILS
4, REPORTS FOOTER
5. PAGE FOOTER
INTRODUCTION TO MS ACCESS
MS Access is a relation database manager. It is software package designed to
maintain and retrieve a related set of data.
nship between database different types of information, so you can use
gether. But before you get in lots database theory. Let’s going and
TLV. B,COM. Computer Applicationgp commandd lek)
3)
dset. MoveLast
ant
4 Recor
wars
ens?
wate sub Form. Load)
end Su
pavate Sub Text1_Change()
end Sub
PENALTY
a
Private Sub Command10_Click()
Adodci.Recordset.MoveFirst
End Sub
Private Sub Command2_Click()
Text1.Locked = False
Text2.Locked = Falsepage 116
nly view information.
In our software member can o
Ifthe librarian is not available than any other person place him
cannot maintain the library.
hrew librarian.
«Member can issue, return and reserve book only t
OBJECTIVE SYSTEM
« Improvement in cannot and performance
me the current the problem occurred
The system was development to overco!
in library. The
System must be able to validate the user store the record and bug free.
+ Save post
an only hire 1 or
After implementing the computerized library system library c
2 staff to
Handle the book transaction process w! ith the aids of computerize system.
Library can save the cost
of hire employee and also save the paper cost.
e Save Time
Librarian is able to search the record in short time by pressing only few keys
compare to
Previous time before implementing the system librarian can save a lot time.
T.Y, B.COM. Computer Applicationend Sub
private Sub Command2_Click()
Text1.Locked = False
Text2.Locked = False
Text3.Locked = False
Text4.Locked = False
TextS.Locked = False
Text6.Locked = False
Text8.Locked = False
Text9.Locked = False
Adodci.Recordset.AddNew
Text1 SetFocus
End Sub
Private Sub Command3_Click()
Adodc1.Recordset.Delete
End Sub
Private Sub Command5_Click()
Adodc1 Refresh
Adodc1.Recordset Update
End Sub
Private Sub Command7_Click()
Adodc1.Recordset.MovePrevious
End Sub
Private Sub Command8_Click()
‘Adodcl.Recordset. MoveNext
End Sub
Private Sub Command9_Click()v
inthis we learned more about doing library managem
AREMONL eye
val basic 6.0 and connecting database to i. this pr abet ne
" Oh ry
reter more books and search website for doing this project the
This may,
addition knowledge for us in makes addition knowledge toy ,
us by
following the details .
in library management system in the future in the addition information
canbe add this project can be run on the internate in online manner
the user can takes information from any place and at any time about
the available books and all about the member which are added
previously.
"i ft
| "COM, Computer ApplicationPage tas
' ACTION BUTTON
-LCOM. computer Applicationend SUD
vate sub Label? CCK)
Pe
end sub
pavate Su Textt_chanel)
end SUD
issue RETURN.
RETURN BOOK
0
info
we
mmemedt
oe
ae) es
oe a Sel ee
Private Sub Command10_Click()
Adodc1.Recordset.MoveFirst
End Sub
Private Sub Command2_Click(Index As Integer)
Adodcl.Recordset.AddNew .yy —
pane 1%
DESCRIPTION :1SSUE DETAILS:
= ACC_NO +000)
Bi K NAMES ISBN AUTHOR PUBLISHERS
ent
une *CATEGORY *AVAILABLE BOOK
gus OETANS
aMe: nea, FORISSUE DETALS
‘ALlAS:NONE
weteRE USED/HOW USED:
wpuT TO STRANSACTION
) ourruT OK ISSUE MANAGEMENT.
jupriewENTARY IT CONTENT CREATE MEMBER
coNTENT DESCRIPTION : ISUE DETAILS = ACC_NO+ BOOK NAME +AUTHOR “HSSUE RETURN
pare #1SSUE DATE #DUR DATE
{7,REMINDER FOR RETURN BOOK
NAME: REMINDER FOR RETURN BOOK
ALIAS:NONE
WHERE USED/HOW USED:
INPUT TO : MEMBER
ourPuT {RETURN MANAGEMENT
SUPPLEMENTARY {£7 CONTENT REMINDER FOR BOOK
ATE + RETURN
CONTENT DESCRIPTION: REMINDER FOR RETURN BOOK © \SSUE DATE + DUE DI
DATE
8.RETURN BOOK
NAME: RETURN BOOK
TY. B.COM. Computer Application