I was going to try and edit your relationships but the tables were too far departed from one and another. For instance, there was not any mention of the data found in the Supplier field to be found in the Suppliers table.



You could possibly salvage the existing DB using your insight to suppliers and their products. That is something you will have to work through and something I do not really know. The answer may be a combination of both; start to fix what you have and then import the good stuff to a new blank DB.

I would start by looking for tutorials. Use the keywords provided to start your search in forums. Discover new keywords and do further searches.