We have 9 Unique Machines(BOM's) and 5 Variants of Each Machines (BOM),Each BOM consists of Raw Material, Semi Finished Goods & Components
Component are purchased with or without Serial No from Multiple Vendors , Which are then used in Different Machines (BOM`s)
Inventory Management of Raw Materials, Semi Finished Goods, Components, Finished Goods (Machines Manufactured) are maintained
Manufacturing of Finished Goods are done at 2 Different Units and 2 Different Warehouses
Quotes(Reports) are provided to Prospective Customers, Need to Track Marketing Data like Prospect,Closed,Lost Customers, Sales Commission.
I Have Customers with Multiple Branches,Customers Shift Machines to Different Branches
For Each Machine Sold Need to Track Dispatch Details (Packing Labels) Serials of Components Warranty Status Service History (Spares/Service provided in Warrantee/Out of Warrantee Period)
How do I Plan my Database like Tables and its Relations
For now, keep a list of every type of THING you need to track. In your case: machines, materials, components, vendors, etc. Once you get to Expert Level 1 and 2 and finish the lessons on relationships, you'll have a much better understanding of how these things will relate together. For now, start building your tables keeping in mind that each of these is going to have an ID field to link them to something else.
Products and Vendors, for example: each Product will have a VendorID to tell you who you buy that product from. That's a one to many relationship. Or, you may have a situation where you have multiple vendors that supply the same products. That gets into many to many relationships, which are a little tougher.
I see you've only finished Access Beginner 6. Keep learning. You'll get there soon. The Expert Series starts relationships.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Beginner 2.
