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 a. Creating a Table and Relationship * Books Acquisition * Books Copyright * Books Accession * Subject b. Creating a Form * Master/Parent Form * Detail/Child Form 3. Library Members c. Creating a Table * Members * Member Type * Course d. Creating a Form 4. Borrowing of Books e. Creating a Table f. Creating a Form g. Creating Queries 5. Returning of Books h. Creating a Table i. Creating a Form j. 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