Results 1 to 3 of 3
  1. #1
    Indiangeek is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Oct 2016
    Location
    India
    Posts
    1

    Post want to create a library management project need complete guidance step by step I am new to access

    First help how to design database following fields i wish to have in my database
    bookID bookrefno booktitle bookedition(like 2000 2001 2002 so on) copynos(each edn will have 10 books) issue deatails receive details
    1001 ABC101 Indian History 2000 (1 to 10) for each edition Ms.Helen 01/01/16
    ,
    Second help
    i want to store data as
    ABC101 Indian History Edition 2000 copy no.1 issued Ms.Helen on 01/01/16


    ABC101 Indian History Edition 2001 copy no.2 issued Mr.David on 02/02/16
    ,
    Third held
    how to retrieve the same data

    ABC101 Indian History Edition 2000 copy no.1 issued Ms.Helen on 01/01/16
    ABC101 Indian History Edition 2001 copy no.2 issued Mr.David on 02/02/16

  2. #2
    Micron is offline Virtually Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,784
    Suggest you look here for some concepts on library databases. There is a whole section for libraries.
    Regret to say that your posts indicates you need some background information on database normalization since you are mixing book information with transactions and users.
    There is a nav pane here that covers this and many other design concepts http://www.fmsinc.com/free/newtips/primarykey.asp
    A bit of homework will save you a lot of aggravation later on.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  3. #3
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,722

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Create a 2 step query into 1
    By KingOf206 in forum Queries
    Replies: 10
    Last Post: 06-25-2014, 06:09 AM
  2. Northwind Database Tutorial step by step
    By AATQA in forum Access
    Replies: 1
    Last Post: 10-22-2013, 06:20 AM
  3. Replies: 5
    Last Post: 07-11-2013, 08:50 AM
  4. step and step proccess
    By toochic in forum Programming
    Replies: 5
    Last Post: 10-09-2011, 09:34 AM
  5. Replies: 4
    Last Post: 04-29-2009, 04:59 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums