Planning Your Database - How To Design Forms Set Up Relationships And Build Appointment Forms In Microsoft Access Beginner 2


	Back to Access Beginner 2 Lessons Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Planning Your Database

Mohammad Abrar

6 years ago

We Manufacture Small Construction Equipment's

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

Richard Rost @Reply

6 years ago

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.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Beginner 2 Lessons.

Next Unseen

New Feature: Comment Live View