+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 23
New Project Ideas Thread, Library Management Database in EduGeek Projects; Due to a whole heap of budget cuts in our area, our Library has had to drastically reduce its outgoings, ...
  1. #1

    nephilim's Avatar
    Join Date
    Nov 2008
    Location
    Dunstable
    Posts
    11,828
    Thank Post
    1,624
    Thanked 1,880 Times in 1,397 Posts
    Blog Entries
    2
    Rep Power
    426

    Library Management Database

    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
    Last edited by nephilim; 25th March 2009 at 11:38 AM.

  2. #2

    Ric_'s Avatar
    Join Date
    Jun 2005
    Location
    London
    Posts
    7,590
    Thank Post
    109
    Thanked 762 Times in 593 Posts
    Rep Power
    180
    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.

  3. Thanks to Ric_ from:

    nephilim (25th March 2009)

  4. #3

    elsiegee40's Avatar
    Join Date
    Jan 2007
    Location
    Kent
    Posts
    10,718
    Thank Post
    1,784
    Thanked 2,170 Times in 1,605 Posts
    Rep Power
    770
    Quote Originally Posted by nephilim View Post
    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!

  5. Thanks to elsiegee40 from:

    nephilim (25th March 2009)

  6. #4

    nephilim's Avatar
    Join Date
    Nov 2008
    Location
    Dunstable
    Posts
    11,828
    Thank Post
    1,624
    Thanked 1,880 Times in 1,397 Posts
    Blog Entries
    2
    Rep Power
    426
    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?

  7. #5

    elsiegee40's Avatar
    Join Date
    Jan 2007
    Location
    Kent
    Posts
    10,718
    Thank Post
    1,784
    Thanked 2,170 Times in 1,605 Posts
    Rep Power
    770
    Quote Originally Posted by nephilim View Post
    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!

  8. #6

    Sylv3r's Avatar
    Join Date
    Jul 2005
    Location
    Co. Durham
    Posts
    3,204
    Thank Post
    372
    Thanked 376 Times in 334 Posts
    Rep Power
    147
    I guess we are lucky in this respect - we don't have a library!

  9. #7

    Join Date
    Nov 2006
    Location
    Kendal
    Posts
    1,555
    Thank Post
    112
    Thanked 177 Times in 144 Posts
    Rep Power
    71
    Quote Originally Posted by Sylv3r View Post
    I guess we are lucky in this respect - we don't have a library!
    Blimey that's terrible - how big are school are you?

  10. #8

    Sylv3r's Avatar
    Join Date
    Jul 2005
    Location
    Co. Durham
    Posts
    3,204
    Thank Post
    372
    Thanked 376 Times in 334 Posts
    Rep Power
    147
    Quote Originally Posted by jcollings View Post
    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!

  11. #9

    john's Avatar
    Join Date
    Sep 2005
    Location
    London
    Posts
    10,517
    Thank Post
    1,494
    Thanked 1,050 Times in 919 Posts
    Rep Power
    302
    Quote Originally Posted by Sylv3r View Post
    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.

  12. #10

    elsiegee40's Avatar
    Join Date
    Jan 2007
    Location
    Kent
    Posts
    10,718
    Thank Post
    1,784
    Thanked 2,170 Times in 1,605 Posts
    Rep Power
    770
    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.

  13. #11

    Join Date
    Nov 2006
    Location
    Kendal
    Posts
    1,555
    Thank Post
    112
    Thanked 177 Times in 144 Posts
    Rep Power
    71
    Quote Originally Posted by john View Post
    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.

  14. #12

    nephilim's Avatar
    Join Date
    Nov 2008
    Location
    Dunstable
    Posts
    11,828
    Thank Post
    1,624
    Thanked 1,880 Times in 1,397 Posts
    Blog Entries
    2
    Rep Power
    426
    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!

  15. #13

    elsiegee40's Avatar
    Join Date
    Jan 2007
    Location
    Kent
    Posts
    10,718
    Thank Post
    1,784
    Thanked 2,170 Times in 1,605 Posts
    Rep Power
    770
    I assume you've "lost" our school logo... you can lose that awful bright yellow front end too!

  16. #14
    p858snake's Avatar
    Join Date
    Dec 2008
    Location
    Queensland
    Posts
    1,490
    Thank Post
    37
    Thanked 175 Times in 151 Posts
    Blog Entries
    2
    Rep Power
    51
    Won't using a access database cause issue when multiple people access it at once...

  17. #15

    nephilim's Avatar
    Join Date
    Nov 2008
    Location
    Dunstable
    Posts
    11,828
    Thank Post
    1,624
    Thanked 1,880 Times in 1,397 Posts
    Blog Entries
    2
    Rep Power
    426
    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

SHARE:
+ Post New Thread
Page 1 of 2 12 LastLast

Similar Threads

  1. Library Management System - SQL Problem
    By AnnDroyd in forum Network and Classroom Management
    Replies: 0
    Last Post: 2nd October 2007, 08:45 AM
  2. Replies: 4
    Last Post: 28th February 2007, 09:37 AM
  3. Sophos EM Library
    By wesleyw in forum Windows
    Replies: 3
    Last Post: 20th July 2006, 01:22 PM
  4. Access It Library Management
    By TechMonkey in forum MIS Systems
    Replies: 7
    Last Post: 8th March 2006, 10:26 PM
  5. Eclipse 2 - Library management system
    By OverWorked in forum MIS Systems
    Replies: 18
    Last Post: 23rd January 2006, 11:51 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •