How do you create library system in MS Access?

Answer 1

To answer that is really beyond the scope of a simple answer. To design a library system take a lot of detailed work in planning, designing and then creating it. Every library system would have its own particular characteristics that are different to others, so there is also not a single way of doing it or a single result. You would need to establish exactly what you want the system to be able to do and that will influence your design too. You would have many tables and would need to set them up correctly with the right fields of your choice. You would need to know what relationships are needed and how to set them up. You would need to know what queries you need, what reports you need and what forms you need. So as you can see, there is a lot of work involved and it is impossible to give a simple answer.