[go: up one dir, main page]

0% found this document useful (0 votes)
16 views59 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.

Uploaded by

vatsalbharodiya1
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
0% found this document useful (0 votes)
16 views59 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.

Uploaded by

vatsalbharodiya1
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
You are on page 1/ 59
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 Application yr 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 Application TY, B.COM. Computer Application CONCLUSION CONCLUSION Yy, - | Mt computer application Pee len page 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.MoveLast yertB.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 Sub TY, B.COM, Computer Application EE = 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 = False Page iaa USER INFO. ‘BOOK DETAILS BOOK INFO Page \as TABL:. DESING Te 5.COM. computer Application yemBER 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 Application SOFTWARE OVERVIEW 1... B.COM. Computer Application a (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 LW gestatocked 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 Sub P | 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 Application SEES 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 Application SOFTWARE 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 Application v 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 Application page |20 ADVANTAGES srecordset. 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 Application page 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 Zt SOFT WAIRIE REQUIUREMIENT Spec ification (SRS) 7.¥. 8.COM. Computer Application Meta ROM LAYOUT WITH CODING F i COM. computer Application sySTEMOVERVIEW 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 = False ans 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 pu page [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 Application page 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 Application Last 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 if wy 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 Application end 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 Application private 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. MoveFirst ACKNOWLEGEMENT 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 Application A 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 FoRM hone 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 Application private 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.Delete FORM STRUCTURE EeEy] | =m page 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 Application end 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 Application r 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 Application a 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 Application gp 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 = False page 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 Application end 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 Application Page tas ' ACTION BUTTON -LCOM. computer Application end 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

You might also like