creating simple Inventory management software

[Ziauddin Ahmed]

Hello guys I am a new-bee in MS Access programming from Bangladesh. Presently I am trying to make a simple stock management software for my company, but facing some problems to do that. I attach herewith 2 tables (in Excel format) I am working with. Table 1 is 'Stock Book" having several products and Table 2 represents an Invoice having few products as in Stock Book. How can I make tables/forms and how to make relationship both the tables as well as update the stock automatically ? Would you please help me to solve it.

 

[CJ_London]

you need to zip a file in order to be able to upload it. But before you do, take a look at some of the examples provided by access.

I can tell from your description that you have not yet grasped the principles of normalisation so also google 'normalisation' to gain an understanding.

I would expect you to have more than two tables - as a minimum

products
customers
invoice headers
invoice rows

more, if you have discounting, need a history of price changes (required for valuing stock), need to track purchases, customers have multiple addresses, etc

 

[gemma-the-husky]

Try this

http://access-templates.com/access+...ompany+inventory+management+database-562.html

[edit.
this is the A2003 "Dharamsala tea" database that used to be on the MS database samples page. It's the best inventory database I have seen by far. (I changed it to record sales as negative inventory to facilitate summing movements, but other than that, it's good to go)

I think this website now has all of the A2003 solutions which MS removed. MS now have later samples only (accdb's, not mdb's), with recent facilities such as embedded macros, and so on, which I find much harder to analyse then pure VBA code.]

 

[HiTechCoach]

Hello guys I am a new-bee in MS Access programming from Bangladesh. Presently I am trying to make a simple stock management software for my company, but facing some problems to do that.

As you are learning, it is very difficult to make simple stock management software. In database programming, Inventory Control/Stock Management requires the highest level of database design skills. This is true for every database /software development platform. The difficulty is not limited to Access.

It is understandable that you are struggling. It can stump even experienced programmers the first time they attempt it.

The good news is there are people here that will help you get started down the path of Best Practices.

I would recommend reading this primer before you do much more:

Inventory Control: Quantity on Hand


The key to creating a functioning Inventory Control/Stock Management solution is to build it on a foundation of a properly designed (normalized) set of tables.

I attach herewith 2 tables (in Excel format) I am working with. Table 1 is 'Stock Book" having several products and Table 2 represents an Invoice having few products as in Stock Book. How can I make tables/forms and how to make relationship both the tables as well as update the stock automatically ? Would you please help me to solve it.

Excel is NOT a Relational Database Management System (RDBMS).

I have yet to see an Inventory Control/Stock Management "Database" created in Excel that is very close to how it would be done in an RDBMS, like Access.

I urge you to create a working solution in Access without modeling anything from a spreadsheet. Only use a real RDBMS as a design guide.

Once you have a working solution in Access you can import the stock list from Excel.