Loading

How to Make Library System

Submitted by: 
admin
Friday, May 1, 2009 - 14:16
Language: 
Microsoft Access
Visitors have accessed this post 111374 times.


In this tutorial I will explain to you on how to make a library system out of the box. The model we used to create a sample program can be access at Library Management Software page.

In order to understand this tutorial, you must have a basic knowledge on how to open Microsoft access, its table, queries, forms, reports, macros and modules. Although this can be discuss somewhere in the tutorial I highly recommend you to play around the environment of ms access.

This tutorial is intended only for beginners who always ask common question. If you are an advance programmer please do suggest a topic that you like most that would be beneficial to the reader.

A topic will be listed below in chronological order according to its importance in making a library system. I will, however, change the order of the topic by adding or removing, if I found some topic to be useful as we go along.

Table of Contents

  1. Create a Library System Database
  2. Books Acquisition
    1. Creating a Table and Relationship
      • Books Acquisition
      • Books Copyright
      • Books Accession
      • Subject
    2. Creating a Form
      • Master/Parent Form
      • Detail/Child Form
  3. Library Members
    1. Creating a Table
      • Members
      • Member Type
      • Course
    2. Creating a Form
  4. Borrowing of Books
    1. Creating a Table
    2. Creating a Form
    3. Creating Queries
  5. Returning of Books
    1. Creating a Table
    2. Creating a Form
    3. Creating Queries

Although you can jump right away to the topic or sub topic but I suggest you follow the order to avoid confusion later.

Since this program has been created in year 1999, there are some tables or queries which do not follow the correct naming convention. In this case, I will try to change it in this tutorial. But still the output must be the same with the model.

If you found some topic that is missing or I forgot to include in which you think a must have tutorial please don’t forget to right a comment below.

Final Thoughts

At the end of this tutorial you will learn how to work with Microsoft Access including table, queries, forms, macros and modules.

Note: Due to my hectic schedule I may not able to finish this tutorial. If you wish to study the source code yourself please download a copy at this link:

Library System



Tags: 
ms access
tutorial
library system
admin's picture

Article by admin

admin has submitted 489 source code / articles.

If you like This post, you can follow SourceCodester on Twitter.

Subscribe to SourceCodester feed via RSS or EMAIL to receive instant updates.



Comments

Submitted by samanoze on Tue, 05/05/2009 - 21:25

I am currently preparing some MS Access tutorials and it will be available soon

Your may contact me to have a first hand access to the tutorial on +2348036434648 or samanoze@yahoo.com

SAMUEL A OJO

admin's picture

Submitted by admin on Tue, 05/05/2009 - 21:44

That would be great! Microsoft Access is also the best application for small to medium size business.

If I have time I will upload the MS Access version of my inventory system.

Your tutorial will help sourcecodester.com visitors in understand my source code better.

Thanks

Submitted by Anonymous on Fri, 10/23/2009 - 10:59

can u give me a sample of library system using vb express 2008??? mail me at airielyanna@yahoo.com

Submitted by Anonymous on Sat, 06/30/2012 - 09:39

That's great! Can I ask for a copy of the application? Thanks.

Submitted by Anonymous on Thu, 05/21/2009 - 19:31

wow programming made easy to understande thanks alot

Submitted by Anonymous on Tue, 05/26/2009 - 11:27

I really appreciate your grate efforts. A friend of mine referred me to this site, I visited the site and found a lot of wonders!!!

I have downloaded some of your work. I will try to review them and still get back to you ASAP.

You are really trying. Keep it up!!!

Aweda Akeem
+2347085287169

Submitted by Anonymous on Mon, 06/01/2009 - 01:08

hello i cant run it or access it.plz help me to run this project.

Submitted by Anonymous on Mon, 06/22/2009 - 19:38

good job!!!

Submitted by Anonymous on Fri, 06/26/2009 - 09:21

i learned a lot.. Thank you...now i can run my program...

Submitted by Anonymous on Sun, 06/28/2009 - 22:42

please help me to send the sourcecode and procedure.

Submitted by Anonymous on Tue, 07/28/2009 - 22:34

Hi im also developing a library system and im running into a lot of troubles, especially regarding the reports and roles, pls advice me on how to tackle the issue

Submitted by Anonymous on Thu, 07/30/2009 - 18:09

you havent finished it.

Submitted by Anonymous on Mon, 09/14/2009 - 21:57

we are having a group project making a library system and it is so hard when we create it because of lack of knowledge about it,,,can you help us in making a simple library system?

admin's picture

Submitted by admin on Thu, 09/17/2009 - 10:55

Please read Thesis Writing.

Submitted by Anonymous on Sun, 03/13/2011 - 09:54

i also creating library system,,,and haven't so much time to create a database file, codes.....but i am done designing my system.this coming march 18 2011,is my defense day..for my running system.please help me and my group.

my email : bibat.john@yahoo.com,thanks.

Submitted by Anonymous on Fri, 09/18/2009 - 09:16

hey, please help me how can i make my own codes???? please send some examples to my email cayleg15@yahoo.com
tnx to your kindness

please because i need my project in vb6 this comming weeek

Submitted by Anonymous on Tue, 09/22/2009 - 15:22

sir do u know how to make library system using SQl??!!

admin's picture

Submitted by admin on Mon, 09/28/2009 - 22:10

You mean SQL Server database?

Submitted by Anonymous on Wed, 10/28/2009 - 03:05

hi...
i need source code for online librarry management system...
It should have log in facility and fine records too other than issueing and returning a book..
all i need is complete code in SQL........With ER diagram

mail me to
chander.sharma007@gmail.com

plz help me

Submitted by Anonymous on Fri, 09/25/2009 - 01:52

plzz mail me d source code for library management
mini project in java
my email id is shahtanvisweet@yahoo.co.in

Submitted by Anonymous on Tue, 10/06/2009 - 13:38

sir can you do it for me?

Submitted by Anonymous on Tue, 10/06/2009 - 17:31

hello there can u please help me in my special project,,,create library system in visual basic,,,,please..can give me the codes.. more eligible to use..thank you.here is my email emo_girlcute31@yahoo.com

Submitted by Anonymous on Sun, 10/11/2009 - 20:18

can u plz give me a sample of a library system using visual basic 2008......
tnx...
this is my email....
juzz_tomoko@yahoo.com

Submitted by Anonymous on Thu, 10/15/2009 - 10:10

hi im raymond...would you please,,can you give me a sample of a library system used by visual basic 6.0 combined with microsoft access 2003.. together with the code..if it is just okay for you..please send to my e-mail at nheo17@yahoo.com...thanks for kindness...

Submitted by Anonymous on Mon, 10/26/2009 - 20:27

Hello i'm Jhane..and i really want to learn on how to make a library system, can you please help me? How can i apply it to visual basic 6.0?

Like others, i also want to have your sample of Library system. Please, and please help me..

Thank's
jhane025

Submitted by Anonymous on Sun, 11/01/2009 - 18:14

sir please send me source code for online library management system in JSP.
my email address is mr.sanjaybhansali@rediffmail.com

Submitted by Anonymous on Wed, 11/04/2009 - 09:16

Hi

I am kenneth. I really love the program that u have done.. Could u send me the source code, I would love to learn the ropes.

Could u pls send it to my e-mail at kenyong87@hotmail.com

Thanks man

Cheers
Kenneth

admin's picture

Submitted by admin on Thu, 11/05/2009 - 12:03

Just released it yesterday. Download it anytime.

Submitted by Anonymous on Mon, 01/18/2010 - 15:45

hey

i need th elibrary source code.... i really amnot able to find it... can you please mail to me at varshini.bala@gmail.com...

thanks a million

Submitted by Anonymous on Fri, 11/20/2009 - 20:56

can u send to me the source code on it . . and guide on how to make a library system ? please send sent it to my email slamguy20@y.c

Submitted by Anonymous on Fri, 11/27/2009 - 01:50

sir may u pls send the system of ur program coz i wll just get some base how to make a system...coz im trying to make a video rental system....

really thank u sir...and good job...

uzienki@rocketmail.com

From: Joery

Submitted by Anonymous on Mon, 01/04/2010 - 13:59

Hi there, Am trying to make a library database for a small library in an orphanage in Manila, Philippines. Please could you send me the source code. my email is naomicl22@yahoo.co.uk
many thanks

Submitted by Anonymous on Mon, 01/25/2010 - 20:45

can u give me the sorce code for library managment system project and technologies should be backend as oracle i.e sql and frontend is java

Submitted by bunthoeurn on Sun, 01/31/2010 - 14:45

please you kind send me the source code for java in hotel management i really want it because this is my assignment for my teacher it deadline in 8-feb-2010
E-mail: bunthoeurna@gmail.com
Thank a million !

Submitted by Anonymous on Fri, 02/12/2010 - 23:57

hey hi!!.....

I want a code or ready made project for library management system with the front-end as c#.NET & back-end as MS Access.

I am finding it very difficult to make forms save the data properly into the database. while saving any record , the record gets inserted but after refreshing the database the record saved recently gets deleted automatically. And even no previous records are getting added.
There is no problem with the code. I checked it. please help me.......

send me the project application or demo programm or ready made project.

mail me at-
mmahajan9@gmail.com

Submitted by Anonymous on Tue, 02/16/2010 - 19:55

Can U please help me to do Library system. I am having a look at your project tutorial at the moment. Can you please send complete turorial to my email (myohtut.oo@gmail.com) or links to video.

Thanks....

Submitted by Anonymous on Thu, 03/11/2010 - 16:56

my name is himanshu verma. i need a project of visual foxpro. can you plz help me???

my e-mail id is "himanshu_verma52@yahoo.com"

Submitted by Anonymous on Sun, 03/14/2010 - 01:26

hi
i am doing this project in asp.net with c# but in between i get injured and the problem of tailbone subluxation takes place . i am unable to continue my project, & exam is on head. plz help me for giving source code. my id is sinha_surbhi2007@rediffmail.com

Submitted by Anonymous on Tue, 03/16/2010 - 15:47

Hi sir
Pls show mi the code of this system because Im making my project and I need your help.

Thanks and God Bless

Submitted by Anonymous on Wed, 03/17/2010 - 20:01

Uhm..I'm an Information Technology Student and we are required to create a system using C.. could u help me with this?..
I'm looking forward to a positive answer!..thanks!

email me...chinmcz@yahoo.com

Submitted by Anonymous on Wed, 03/24/2010 - 08:44

can u give give me a sample to make a library system by using ms acces 2003..

plz.
my email: reyianzs@yahoo.com

Submitted by Anonymous on Tue, 04/20/2010 - 14:09

THIS SITE HAS BEEN VERY USEFUL TO THE STUDENT AS WELL AS PROGRAMMERS TO WORK WITH BY PROVIDING THE SOFTWARE AND CODE
OF FREE CHARGE !

HENCE I AM SO MUCH THANKFUL TO THE PROVIDERS OF SOURCECODESTER.COM

YOURS SINCERELY

ANIL.CH

Submitted by Anonymous on Wed, 05/12/2010 - 11:03

sir i will take my exam tomorrow regarding the library system.. pls parang awa nyo na po pasend naman yung source code ng inyong library system.. kahit konti lang po... pls po parang awa nyo na.. kindly send it at apionne2003@yahoo.com thanks po. pag nakapasa ako ililibre kita kahit saan. ehehe. salamat po ulit!

Submitted by Anonymous on Sat, 05/15/2010 - 20:45

sIR I WANT TO MAKE A PROJECT ON VB 6.0 ABOUT DISTRIBUTOR OUTLET WHICH DEAL WITH SUPPLYING OF GOODS TO CUSTOMER ACCORING TO THEIIR ORDER. PLEASE GIVE ME SOME HELP SIR

Submitted by Anonymous on Wed, 06/02/2010 - 20:40

the blog has really helped me and i can now say with a degree of confidence that VB.net is the thing.
do you have any code samples for a hospital? or just a logical design.
email to matemostan@yahoo.com

Submitted by Anonymous on Thu, 06/10/2010 - 18:40

i have to make a program for library management system using java.can u plz hlp m with the source code..
i will b rly grateful 2 u
my id anushkaawasthi107@gmail.com?

Submitted by Anonymous on Thu, 07/22/2010 - 09:26

I need help sir in making a lib system using vb6, can you help me sir for the source code.
is your library system using access has an available source code for vb6?
i was new in using vb6 sir
I will surely appreciate it if you can help me and send the code in my email.
daenjo_9@yahoo.com

thank you sir

--Flippy

Submitted by Anonymous on Fri, 07/23/2010 - 11:16

Hello Im richmon Pañares.,., please help me to make a library System please send me your codes in my email,,graceyrich_jan07@yahoo.com Im student of Zamboanga del sur in Phl.can you help me sir???

Submitted by Anonymous on Sat, 07/24/2010 - 18:45

can you help me on how to create a simple code on library system using visual basic 6.0..
mail me at ram_asawaq@yahoo.com

Submitted by Anonymous on Tue, 08/03/2010 - 17:58

can you give me a source code regarding library system.
mail me at
vhanez_kitty04@yahoo.com

thank you

Pages

Add new comment

More information about text formats

Filtered HTML

  • You may insert videos with [video:URL]
  • You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>, <asp>, <c>, <cpp>, <csharp>, <css>, <html4strict>, <java>, <javascript>, <mysql>, <php>, <python>, <sql>, <vb>, <vbnet>. The supported tag styles are: <foo>, [foo].
  • Lines and paragraphs break automatically.

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.