I've had a look at your relationship diagram and I think you need to re-structure your database. A good example of the problem is that the "Artist" table contains the same information as the "Title" table and, because you've defined relationships with both of them and the "product" table, you've then got a circular set of relationships which can give you all sorts of trouble. You really need to think about what the actual data "entities" are. I would suggest "Artist" just contains information about artists, "Title" contains information about the works (including the id of the Artist who produced each one) and "product" contains details of the products (I assume that the product is something different from the work, say mugs, T shirts etc bearing a relationship to artisitc works). The id of the "Artist" would then be an attribute of each work (eg both "Mona Lisa" and "Last Supper" would have the id of Leonardo Da Vinci as the artist) and you wouldn't need to have a relationship between "Product" and "Artist" because anything with the Mona Lisa or the Last Supper printed on would have a link to Leonardo via the "Title"
If you really want to understand data analysis I suggest you read a bit about Codd Normalisation and the various Normal Forms which you will find on the web and in the help in Access. It'll drive you mad at first but it clicks eventually.
If you get the data structure right the forms, queries and reports are usually quite easy, if you get the data structure wrong they're often well nigh impossible!!
