Hi, I am a complete Access novice and have been tasked with re-organising an existing database. We are an art gallery with a lot of collectors, and we mail out to either all the collectors or those who collect a specific artist. At the moment we just have tables and tables of the same data being repeated. Ideally I want a master table 'Collectors All' and then a way of getting all the email addresses and postal addressed from that database for those who have collected a particular artist. I've been watching a lot of tutorials but none have the same business case as mine, it's all suppliers and vendors, I think I need to use queries as I have tried relationships and that seems overly confusing.
Please help me I have no idea what I am doing, what is the best way of organising this with Access?
GalleryGirl