Database Design for Inventory Control

[A P]

I am task to design an inventory control database for raw materials and
partly assembled goods. It includes different stations & location. For the
Warehouse, raw materials are only being counted but for Production which
consists of different stations, where in per station, a raw material is
being added until it makes the finish product. The idea of the database is
to generate a report that will give a summary of all raw materials on the
location stated (warehouse & Production). Hope you could help me.

 

[Nick Coe \(UK\)]

Look here:-

http://members.iinet.net.au/~allenbrowne/AppInventory.html

 

[Brett Collings [429338]]

I am task to design an inventory control database for raw materials and
partly assembled goods. It includes different stations & location. For the
Warehouse, raw materials are only being counted but for Production which
consists of different stations, where in per station, a raw material is
being added until it makes the finish product. The idea of the database is
to generate a report that will give a summary of all raw materials on the
location stated (warehouse & Production). Hope you could help me.

AP, netiquette asks that you don't cross-post until you haven't had a
response to your first one.

The task you outline is huge. It is not for a novice so be aware that
there is a very steep learning curve. Unlike Word. Powerpoint or
Excel, Access isn't a pick-it-up-and-use-it type of application. An
understanding of data desgn is the first skill to get up to speed on.

Don't let this discourage you, many on these groups have never been
trained either and got here just by grafting at it. It usually takes
at least 3 years to get proficient that way, mostly by making lots and
lots of mistakes from mistaken assumptions and particularly from
looking at an Access table as a spreadsheet.

To help you shorten the learning curve, here's some critical
reading...
(these are the buzzwords)
- Relational data design
http://support.microsoft.com/default.aspx?scid=kb;en-us;q175939
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q209534
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q234208
http://support.microsoft.com/default.aspx?scid=KB;EN-US;q288947&
http://support.microsoft.com/default.aspx?scid=kb;en-us;288947


- Normalization
http://databases.about.com/library/weekly/aa080501a.htm
http://www.datamodel.org/NormalizationRules.html
http://userpages.aug.com/frodo/filenorm.html
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q209534


- Naming Conventions
http://www.acc-technology.com/namconv.htm
http://www.mvps.org/access/general/gen0012.htm
http://msdn.microsoft.com/library/default.asp?url=/ARCHIVE/en-us/dnaraccgen/html/msdn_20naming.asp>
http://msdn.microsoft.com/archive/default.asp?url=/archive/en-us/dnaraccess/html/msdn_20naming.asp
http://www.xoc.net/standards/rvbanc.asp


- Queries (why and how they work)
http://support.microsoft.com/default.aspx?scid=kb;en-us;304325
http://support.microsoft.com/default.aspx?scid=kb;en-us;304352
http://support.microsoft.com/default.aspx?scid=kb;en-us;182568


- Subforms (why and how they work)
http://office.microsoft.com/en-au/assistance/HP051883951033.aspx
http://office.microsoft.com/en-au/assistance/HP051878031033.aspx
http://support.microsoft.com/default.aspx?scid=kb;en-us;209113
http://support.microsoft.com/default.aspx?scid=kb;en-us;209099
http://support.microsoft.com/default.aspx?scid=kb;en-us;113548


- Tab Controls
http://support.microsoft.com/default.aspx?scid=kb;en-us;171222
http://support.microsoft.com/default.aspx?scid=kb;en-us;198502
http://support.microsoft.com/default.aspx?scid=kb;EN-US;208785
http://support.microsoft.com/default.aspx?scid=kb;en-us;208750

Good kluck and good huinting ... we're your 24/7 Helpine ... drop by
again
Cheers,
Brett