Good afternoon. I am an avid user of Microsoft Excel, but I am just now beginning to dabble in Access. This is a tool that I MUST learn to use. However, my level of knowledge and experience in Access is super limited. Below, I have some excel data showing the scrap that our company throws away each month. For this example, I am using September's data. Here's a breakdown of the data. I'll walk you thru the first line. The month is September; the line is just the name of the production line that we have (P2 means Paint Line #2); the program is just another name for the car (it could say dodge ram, or ford escape...and so on, but these are the codes we use); the item is the part that was thrown away or scrapped; the color is the color; RL is either a right hand part or a left hand part; total is spray is the qty of pieces that were painted; the qty scrap is the qty thrown away; scrap cost is the dollar amount that we threw away. For example, a 120N Cover might cost 5.00. If we scrapped 10, then the total cost of the scrap is 50.00.
Anyways, here's what my data looks like. This is not all of it (obviously). I have TONS of data and for every month. That's why I need Access lol.
Line Program Item Color RL Total Spray Qty Scrap Scrap Cost P2 120N COVER 4Q2 L 98 10 27.3 P2 2QM VISOR 536 L 101 53 237.44 P2 2QM HOUS 536 L 107 44 199.32 P2 120N COVER 202 L 110 25 68.25 P2 120N COVER 1D6 L 112 11 30.03 P2 120N COVER 202 R 112 40 109.2 P2 483N BODY 6T1 R 114 29 122.96 P2 120N COVER 056 L 116 19 51.87 P2 2QM HOUS 536 R 116 73 330.69 P2 483N BODY 062 L 116 69 292.56 P2 483N BODY 1C0 L 116 41 173.84 P2 483N BODY 202 R 116 58 245.92 P2 635N BODY 6T1 R 117 13 55.12 P2 SJC BODY 529P R 117 51 216.24
Every month, my executives ask me things like:
1. what are the top 5 120N pieces scrapped and how much did those cost us?
2. what color of the 2QM cover was scrapped the most?
3. what line are we scrapping the most of?
and so forth. With excel, this data is sooooo difficult and time-consuming to obtain. I know Access can do this for me. I just don't know how. I am not looking for someone to just give me the answer. I am willing to do all the leg work. I just don't even know where to begin. Thanks so much for your time. I can send you my excel data also if you wish.