Home > Small Library Pro > Library Software, FAQ :

   How to build customized library or renting software system?

   

Our Small Library Organizer Pro consists of four databases: Borrowers database, SmallLibrary(items) database, Loans (check-in and check-out transactions) database, Fines database.

  • Borrowers database allows you to maintain information about users of the renting facility.
  • SmallLibrary (Items) database allows you to maintain information about objects that will be rented (books, videos, tools) and register check-out and check-in transaction.
  • Loans (Transactions) database is created automatically and this database keeps track of all activities in the renting facility.
  • Fines database automatically records fine related transactions: late return fine, fine payment.

Build you own library/renting software solution.
To build your library or renting system you need 4 databases with the minimum number of required data fields, additionally you add data fields that you need.


We already created a package with four databases and with the minimum number of required fields. If you are satisfied with the functionality of the software (Small Library Pro) but not with data fields included in our databases then:

  1. Download Check In/Out Organizer Pro Software Package (Minimum).
  2. Install Check In/Out Organizer Pro on your computer.
  3. Start Designer, click Modify Database.
  4. In the Select Database windows select Items and click OK.
  5. In the Modify Database window click New Field.
  6. In the New Database Field enter field name, select field type, and enter field size.
    7. Click OK. Repeat this procedure for all your fields.
  7. Click Save to save all your changes.
  8. The Field Layout Designer is displayed with the list of old and new data fields.
  9. Click check box in front of your fields to insert and define functionality of the field. Important: Do not click check boxes of the already listed fields (TITLE, BARCODE, LOAN). Repeat this procedure for all your fields.
  10. Repeat 4 - 9 procedures for Borrowers database.

Example: Modify Database window with new data fields:



Example: Field Layout Designer window



Library/Renting Software Package, databases

  • SmallLibrary database structure:
    TITLE, character, size: 220 (enter item title)
    BARCODE, character, size: 60 (enter item bar code)
    LOAN, character, size: 1 (specialized field)
    add more data fields that you need.
  • Borrowers database structure:
    NAME, character, size: 100 (enter person name)
    ID_BARCODE, character, size: 60 (enter person bar code)
    FINES, character, size: 1 (specialized field, displays items from the Fines database)
    DUE, numeric (specialized field, automatically calculates total due amount)
    add more data fields that you need.
  • Fines database structure:
    NAME, character, size: 100 (person name)
    DATE, date type (fine date)
    AMOUNT, numerical (transaction amount)
    WHAT, character, size: 10 (transaction type)
    NOTE, character, size: 80 (transaction notes)
    Our library/renting software makes automatic entries to this database.
  • Loan database structure:
    Item, character, size: 220 (item title)
    LoanedTo, character, size: 100 (person name)
    LoanDate, date (loan date)
    DueDate, date (due date)
    ReturnDate, date (return date)
    Notes, character, size: 80 (notes)
    Our library/renting software makes automatic entries to this database.


    • Small Library Software, FAQ:
    How to define bar coding and fine processing functionality?
    How to process loans (check-out transactions)?
    How to process returns (check-in transactions)?
    How to build customized library or renting software system?
    How to upgrade?
    How to create bar code entries for existing records?
    How to print bar code labels (book labels)?