Inventory Database (A2k)

Topic

New Reply

I’m embarking on a new quest, since personnel databases make me want to … 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

Reply | Quote

Replies

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

Reply | Quote

If you still want to go ahead, you can look back on some of the threads started by AGMCon 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!

Reply | Quote

Check out:

Inventory Concept Question (A2K) post 526,829

HTH

John

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote

Right now I’m working on table setup…I think I’ll need a separate table to handle backorders….how do you handle it?

Reply | Quote

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.

Reply | Quote

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…

Reply | Quote

Sounds good, I’ll keep an eye/ear open.

Reply | Quote