How to Make Library System

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: