Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Can anone help me with a databae for monitoring books

Discussion in 'Information Technology' started by Daints, Nov 9, 2005.

  1. Daints

    Daints
    Expand Collapse
    Guest

    i am looking for a access databaes for me to input the books from my school
    and i want to be able to do a seach on things such as, title, author,
    subject, level, seris etc

    thnks john
     
  2. Loading...


  3. [MVP] S.Clark

    [MVP] S.Clark
    Expand Collapse
    Guest

    There's gotta be something in here that is close:
    http://office.microsoft.com/en-us/templates/default.aspx?Application=OF&Ver=11


    --
    Steve Clark, Access MVP
    http://www.fmsinc.com/consulting

    "Daints" <Daints@discussions.microsoft.com> wrote in message
    news:42F708BC-002A-41CF-8588-2668A3F1076A@microsoft.com...
    >i am looking for a access databaes for me to input the books from my school
    > and i want to be able to do a seach on things such as, title, author,
    > subject, level, seris etc
    >
    > thnks john
     
  4. tope12

    tope12
    Expand Collapse
    Guest

    I dont know if theres any around,but its easy to make. You can make a table
    called Book. You would put all of the fields that you noted in your question
    in that table. You can let Access make your primary key or you can make one
    of your own. If you plan to make your own primary key, remember that the
    primary key is the field that makes every record unique. In your case the
    ISBN number of the book may be a good choice for the primary key. As for
    searching, you can make quieries. You can either use the wizard or make it
    straight from the design view. If you make it straight from the design view,
    choose all of the fields that you want and set the criteria for the one that
    you want access to search by. For example, if you want to search by author,
    select all of the fields that you want to see. At the criteria section of the
    author field, type in [Enter Author:]. This will activate a prompt that will
    ask you for the name of the author. You can do the same thing for any other
    search. You can also make a form that operates just like the prompt. The only
    difference would just be the appearance of the window asking you for the
    certain field that you want to search by. I hope this helps you out.

    "Daints" wrote:

    > i am looking for a access databaes for me to input the books from my school
    > and i want to be able to do a seach on things such as, title, author,
    > subject, level, seris etc
    >
    > thnks john
     

Share This Page