I have been asked to help with a charity library. I have already listed all the stock by author, title & number, on an Excel spreadsheet. That works very well. However, they now want to automate the ins and outs of books, and who has them.
The people who operate the library are sadly not computer literate
I have been searching all over the web for something accurate, but very simple to use. I have found oodles of stuff, but nothing quite suitable.
Anyone got any ideas, or better still, the talent to write a suitable, simple database for booking in and out by reference number and borrower? TIA Kim (Mrs Almost-Library-Designer)
I had exactly the same problem and lack of resources! There is a brilliant database that you can scan the ISDN code and have it insert all relevant details into the database. It's free but you have to buy the scanner so just store that away for future use! I borrowed what we used to call a "numerater" - a device that stamps a number onto things and automatically moves on to the next. The number became the "stock number" and was entered into the Excel spreadsheet. We sorted the sheet into this number sequence. When a book was taken out, the item was found from its number and a "date out" was entered. (see another query I've raised). Similarly date entered when brought back. As required, sort where date out is present and date in is blank. Alternatively, when coming in, just delete date out. You will need also a "borrower" column to enter initials or perhaps issue a library card with a name & number which is listed in another spreadsheet. I hope this has given you some ideas. It is not "automated" but requires little effort