Results 1 to 10 of 10
  1. #1
    5 Star Lounger
    Join Date
    Nov 2004
    Location
    Wilmington, North Carolina, USA
    Posts
    1,196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Inventory Database (A2k)

    I'm embarking on a new quest, since personnel databases make me want to <img src=/S/puke.gif border=0 alt=puke width=60 height=15>... I have no goal for this program, I just want to try to build one... What are some common requests out of inventory databases (what would you include?) I'm looking to challenge myself... any suggestions would be greatly appreciated <img src=/S/yep.gif border=0 alt=yep width=15 height=15>
    ____________________________
    Jeremy
    "If you spend more on coffee than on IT security, then you will be hacked. What&#39;s more, you deserve to be hacked." -Richard Clarke

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Inventory Database (A2k)

    This newsgroup thread may give you an idea of the complexities you're up against.

  3. #3
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Inventory Database (A2k)

    If you still want to go ahead, you can look back on some of the threads started by <!profile=AGMCon>AGMCon<!/profile> as he raises a fair number of the typical issues. With your current employer, many of the trickier newsgroup thread issues are likely not to arise. As an experienced accountant, I can tell you that, in the business world, Access has been rarely seen as an inventory database front-end. (People use Excel - though all things change.) OTOH if you're looking to stretch yourself in your current environment, you've made a very good choice!
    Gre

  4. #4
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Inventory Database (A2k)

    Check out:

    Inventory Concept Question (A2K) <post#=526,829>post 526,829</post#>

    HTH

    John

  5. #5
    5 Star Lounger
    Join Date
    Nov 2004
    Location
    Wilmington, North Carolina, USA
    Posts
    1,196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Inventory Database (A2k)

    To all three of you, thank you for your advice. I've already bookmarked all of the threads started with AMGcon, I know he's dealt extensively with inventory databases.... (I've looked in and tried to help a few times). Since this is just a self-challenge, and not required by work, I don't think I'm "biting off more than I can chew"....it's just another way to give me new scenarios to work around, and learn a little bit more.
    ____________________________
    Jeremy
    "If you spend more on coffee than on IT security, then you will be hacked. What&#39;s more, you deserve to be hacked." -Richard Clarke

  6. #6
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Toronto Canada
    Posts
    920
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Inventory Database (A2k)

    Jeremy,

    Let me know how you make out or if you have any problems. I've managed to deal with 99% of my problems todate except for the diabolical Average Costing Scenario. If someone could give me the Devil's cell number, I might try and make a deal.
    Cheers,
    Andy

  7. #7
    5 Star Lounger
    Join Date
    Nov 2004
    Location
    Wilmington, North Carolina, USA
    Posts
    1,196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Inventory Database (A2k)

    <img src=/S/laugh.gif border=0 alt=laugh width=15 height=15>
    Right now I'm working on table setup...I think I'll need a separate table to handle backorders....how do you handle it?
    ____________________________
    Jeremy
    "If you spend more on coffee than on IT security, then you will be hacked. What&#39;s more, you deserve to be hacked." -Richard Clarke

  8. #8
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Toronto Canada
    Posts
    920
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Inventory Database (A2k)

    Jeremy,

    In 25 words or less (or more), I handle this via a related purchase order system that identifies the received goods, and items on back order are checked of individually on a detail line basis, and become part of a backorder report. Let me know if this is any help or not.
    Cheers,
    Andy

  9. #9
    5 Star Lounger
    Join Date
    Nov 2004
    Location
    Wilmington, North Carolina, USA
    Posts
    1,196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Inventory Database (A2k)

    Andy,
    I don't really understand that....as soon as I get the basics of this laid out, I will document and post for review before moving forward...
    ____________________________
    Jeremy
    "If you spend more on coffee than on IT security, then you will be hacked. What&#39;s more, you deserve to be hacked." -Richard Clarke

  10. #10
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Toronto Canada
    Posts
    920
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Inventory Database (A2k)

    Sounds good, I'll keep an eye/ear open.
    Cheers,
    Andy

Posting Permissions

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