Make this query:
SELECT RESTbl.RESTbl AS [Caused by], RESCrw.RESCrw AS Crew, RESAct.RESAct AS Act, MainEnt.[Part Nmber], PTName.[Part Name], PTDefects.PTDefect AS Defects, MainEnt.[Scrap Date], MainEnt.Qty
FROM PTDefects INNER JOIN (PTName INNER JOIN (RESAct INNER JOIN (RESCrw INNER JOIN (RESTbl INNER JOIN MainEnt ON RESTbl.ID = MainEnt.[Caused by]) ON RESCrw.ID = MainEnt.Crew) ON RESAct.ID = MainEnt.Act) ON PTName.ID = MainEnt.[Part Name]) ON PTDefects.ID = MainEnt.Defect;
Import the query into Excel.