Results 1 to 6 of 6
  1. #1
    sanlen is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Feb 2012
    Posts
    5

    Inventory tracking with Ms Access (newbie)

    Hi,



    I am trying to create a database with Microsoft Access for my new setup small shop to track my inventory, product ordering to suppliers, customers ordering to me and reporting.

    At the end I would like to able to view/print reports as below:

    - Order to supplier:
    1. View/print reports by products code
    2. View/print reports by date I ordered to my suppliers
    3. View/print all ordering to suppliers based on the selected date
    4. View/print the specific products ordered by which customers

    - Order by customers
    1. View/print all orders by a specific customer
    2. View/print all orders by selected date

    - Inventory Checking


    1. View/print what are remaining in stock
    2. View/print if product ordered from suppliers already arrived
    3. View/print if product already delivered to customers

    I am trying to come up tables as below:

    1. Product
    2. Inventory
    3. Ordering
    4. Supplier
    5. Customer

    Since I am pretty new to this Microsoft Access, could you please advise if the 5 tables that I am trying to come up are good enough with the required reports about? Your comments on reporting requirements will also be very appreciated.

    Thanks,
    sanlen

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    Will probably need more tables. Check out this http://forums.aspfree.com/microsoft-...es-208217.html

    Have you looked at the template databases offered by Microsoft or other parties?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    sanlen is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Feb 2012
    Posts
    5
    Quote Originally Posted by June7 View Post
    Will probably need more tables. Check out this http://forums.aspfree.com/microsoft-...es-208217.html

    Have you looked at the template databases offered by Microsoft or other parties?
    Hi,

    Thanks you very much for your comments.

    I did look into the one from Microsoft and try to come up something that would meet my expectation. The enclosed attachment is the file that i am working on.

    Your further comments on file will be very much appreciated.

    Thanks,
    sanlen

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    What is the purpose of your db? Do you want to track the in and out flow of product - purchase and sales? Is this a retail operation?

    I have never built a sales/purchasing/inventory db so I am no authority and don't know your business model so can't say if this is an appropriate structure for you but some things do look odd to me.

    One is that Customers is related to PurchaseOrders. Customers would not normally be associated with specific inventory purchase order.

    I looked at your db and Access inventory template. That template isn't one of the better ones I've seen. You might download the Northwind database and explore it. It has been used for years in numerous tutorials.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    sanlen is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Feb 2012
    Posts
    5
    Hi,

    Thanks for your comments. Yes, it is the retail operation and what we are doing is to do the advertising on facebook and if someone interested then product ordering will be started. The flow within my business is as below:

    We only make the order to our suppliers only there are orders from our customers (we normally don't make order without the confirmation of ordering from our clients).
    We might make extra order of the items and keep some of those items in our stock if we found that product might also need by other people.

    i.e: customerA order 2 of item1, then we might order 4 of this item1 from our supplier and after item1 arrived and released to customerA then we will have 2 of item1 remaining in our stock.

    Further guidance will be very much appreciated.

    Thanks,
    sanlen

  6. #6
    Rainlover's Avatar
    Rainlover is offline Expert
    Windows 7 64bit Access 2003
    Join Date
    Nov 2009
    Location
    Queensland Australia
    Posts
    691
    With a little work I think you could adopt the attached to suit your needs.
    Attached Files Attached Files

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

Similar Threads

  1. Inventory Tracking
    By PUDrummer in forum Access
    Replies: 3
    Last Post: 10-10-2012, 05:42 AM
  2. Managing Inventory in Access
    By bushkanaka86 in forum Access
    Replies: 1
    Last Post: 11-25-2011, 08:31 PM
  3. Replies: 1
    Last Post: 11-08-2011, 07:44 PM
  4. Access for tracking statistics
    By rjbeck52 in forum Access
    Replies: 2
    Last Post: 07-06-2011, 05:48 PM
  5. Replies: 1
    Last Post: 06-06-2011, 06:50 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