featured_spectre Posted March 25, 2009 Posted March 25, 2009 (edited) Due to a whole heap of budget cuts in our area, our Library has had to drastically reduce its outgoings, and one of the ways it wants to do that is by changing from the current library program (Micro Librarian) which is costing £550 a year to an Access Database which would cost us £0. I am trying to set up a database that would work not for us, but for other schools also, which will be freely available for download when ALPHAs and BETAs are ready and when finished, but I was wondering what would actually be needed. I know a Students Database, Staff Database and a Book Database would be needed, but what else? Also if anyone is good with access that would be fantastic if they could offer some help as I am trying to remember my Oracle Databasing days but failing! Oh and it will be for Access 2003 as thats what we are running Edited March 25, 2009 by featured_spectre
Ric_ Posted March 25, 2009 Posted March 25, 2009 There are some open source solutions out there which it might be worth hunting down and trying out. Some I found: * Koha - Open Source ILS - Integrated Library System * Welcome: Evergreen open source library system * emilda.org | Open Source Library Management There's no point re-inventing the wheel after all. 1
elsiegee40 Posted March 25, 2009 Posted March 25, 2009 Due to a whole heap of budget cuts in our area, our Library has had to drastically reduce its outgoings, and one of the ways it wants to do that is by changing from the current library program (Micro Librarian) which is costing £550 a year to an Access Database which would cost us £0. I am trying to set up a database that would work not for us, but for other schools also, which will be freely available for download when ALPHAs and BETAs are ready and when finished, but I was wondering what would actually be needed. I know a Students Database, Staff Database and a Book Database would be needed, but what else? Also if anyone is good with access that would be fantastic if they could offer some help as I am trying to remember my Oracle Databasing days but failing! Oh and it will be for Access 2003 as thats what we are running I inherited a very rough and ready access database from a predecessor. It's only for cataloging books and doesn't do the issue part. I'll happily email it to you as a starter if you PM your email address to me. It really needs some work doing to do it, but I haven't had time to sort it out and tend to manage it with ad-hoc sql queries as my sql ids good! 1
featured_spectre Posted March 25, 2009 Author Posted March 25, 2009 I have taken yours Elsiegee and I am going to expand it. I will try to add in the following: Add pupils Pupil Loans Overdue Books and Fee's. (This will be done with an SQL Query) When its ready for an Alpha test, who would like to test run the system?
elsiegee40 Posted March 25, 2009 Posted March 25, 2009 I have taken yours Elsiegee and I am going to expand it. I will try to add in the following: Add pupils Pupil Loans Overdue Books and Fee's. (This will be done with an SQL Query) When its ready for an Alpha test, who would like to test run the system? I'll give it a go! It'll be ages until I get the money for Junior Librarian!
Sylv3r Posted March 25, 2009 Posted March 25, 2009 I guess we are lucky in this respect - we don't have a library!
jcollings Posted March 25, 2009 Posted March 25, 2009 I guess we are lucky in this respect - we don't have a library! Blimey that's terrible - how big are school are you?
Sylv3r Posted March 25, 2009 Posted March 25, 2009 Blimey that's terrible - how big are school are you? 1400 students. OfSTED felt it was a cause for concern when we were inspected recently, the students don't seem to miss the library.... well they certainly don't miss the librarian!
john Posted March 25, 2009 Posted March 25, 2009 I guess we are lucky in this respect - we don't have a library! Must admit I did know of a couple of schools down south that had got rid of librarys and must admit that the use of them in the schools ive worked at is so low if it was a teaching subject that wasn't core / a specialist room that got that little use it would have been dropped or re-allocated they are very much a dying thing now a days with everyone loving PCs. English departments can get the Fiction books and the reference stuff split between departments and then Google seems to cover the rest.
elsiegee40 Posted March 25, 2009 Posted March 25, 2009 My daughter says her Grammar school library is awful. A large number of rather dated books... both fiction and non-fiction. She says they rarely seem to get new stock in. as a result she never uses it. In my small school, I have nearly 6000 books in the Library. As our age range is 3 months to 11 years, they cover a pretty large range! Everything from board books up. I have to admit that while most of the kids are pretty keen up to Year 5, in Year 6 they are reluctant borrowers. i think there are toomany other interests. My daughter (15) loves reading, but uses the public library not the school one. My teenage son, reads but again never borrows from the school library.
jcollings Posted March 25, 2009 Posted March 25, 2009 Must admit I did know of a couple of schools down south that had got rid of librarys and must admit that the use of them in the schools ive worked at is so low if it was a teaching subject that wasn't core / a specialist room that got that little use it would have been dropped or re-allocated they are very much a dying thing now a days with everyone loving PCs. English departments can get the Fiction books and the reference stuff split between departments and then Google seems to cover the rest. I guess we're lucky then because our library is used all the time and we have a fantastic LRC manager. It's open from 8.15 in the morning to 6 in the evening and whenever I go in there are groups using it for ICT, homework, reading etc. Our students would certainly miss it if we were to shut it down. I disagree that you can redistriubute it - our LRC manager runs many initiatives that English simply would not have time to do which really pull students in. Having somewhere in school where students can hang out and be encouraged to read (something many boys particularly don't do) is an excellent facility and one we'd really struggle without.
featured_spectre Posted March 25, 2009 Author Posted March 25, 2009 Right I have added the main parts in, its now a case of getting it all to link, Also trying to work out how to return books on the system. Lol When its done it will be ready to go! PM Me for email addresses to start sending it out too for Alpha testing and possible re-coding!
elsiegee40 Posted March 26, 2009 Posted March 26, 2009 I assume you've "lost" our school logo... you can lose that awful bright yellow front end too!
p858snake Posted March 26, 2009 Posted March 26, 2009 Won't using a access database cause issue when multiple people access it at once...
featured_spectre Posted March 26, 2009 Author Posted March 26, 2009 Ok, its ready for testing. I have changed the base program that elsiegee sent me. It is available for download and testing Here. Feel free to tell me of any bugs or errors you spot as you come along them! Regards Carl
featured_spectre Posted March 26, 2009 Author Posted March 26, 2009 Won't using a access database cause issue when multiple people access it at once... If only one person uses it, as is the case in our school, then there shouldnt be an issue. But regardless of the program, micro/junior librarian, because as far as I know only one person can use the database at one time as it will cause errors otherwise. Its a hassle but its a system that works
featured_spectre Posted March 26, 2009 Author Posted March 26, 2009 (edited) Anyone found any bugs other than elsiegee??? Edited March 26, 2009 by featured_spectre 1
elsiegee40 Posted March 26, 2009 Posted March 26, 2009 Can I use the edugeek logo for this library program? You might have to stick a message on here: http://www.edugeek.net/forums/message-admins/ eduLibrary!
featured_spectre Posted March 26, 2009 Author Posted March 26, 2009 its ok, I wont use it. I have fixed many of the bugs, a few more to fix and it should be good to go!
featured_spectre Posted March 27, 2009 Author Posted March 27, 2009 Ok guys. Having been in touch with a few people, alot of updates have happened. Here is the current version (1.04) CLICK HERE FOR DOWNLOAD Please do not modify any of the code or macro's etc as it is finely tuned now, but feel free to fiddle with the front page asthetics to suit your needs.
featured_spectre Posted February 7, 2014 Author Posted February 7, 2014 Thread necromancy! Does anyone still have a copy of this at all? Want to use it here for the various books we have so we can keep an accurate record. @elsiegee40 maybe? *edit* old links no longer work and I definitely do not have a copy at home.
elsiegee40 Posted February 7, 2014 Posted February 7, 2014 Thread necromancy! Does anyone still have a copy of this at all? Want to use it here for the various books we have so we can keep an accurate record. @elsiegee40 maybe? *edit* old links no longer work and I definitely do not have a copy at home. I have no idea @nephilim. I will have arummage when I am in school next
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now