Results 1 to 4 of 4
  1. #1
    gallery is offline Novice
    Windows 10 Access 2016
    Join Date
    Mar 2020
    Posts
    1

    Gallery: Art collectors database design problems.

    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

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    the tClient table, would have a [clientType] field.
    values: supplier, vendor

    the queries ; qsVendors and qsSupplies would pull only those people.
    select * from tClient where [clienttype]='supplier'

    emails would come out of these queries.

  3. #3
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2016
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    The Database Planning and Design link in my signature has many articles and tutorials relevant to your situation. Before jumping in to physical Access, spend some time and work through 1 or 2 of the tutorials from RogersAccessLibrary mentioned in the link. Also, the various videos on relational database and/or Access may be helpful to you. The videos from BA-Experts are short and humorous, and deal with many analysis topics (related to your fact gathering/decisions).

    You may get some ideas from these draft models:
    Art Gallery
    Collections

    You may get some focused responses if you provide a graphic/screen capture(s) of your current database tables and relationships (relationship window). It will provide context for your requirements and concerns.

    Good luck with your project.

  4. #4
    Bullschmidt's Avatar
    Bullschmidt is offline Freelance DB Developer
    Windows 10 Office 365
    Join Date
    Mar 2020
    Location
    USA
    Posts
    64
    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.
    How about setting up tables something like this...

    Collectors Table:
    CollectorID
    CollectorLName
    CollectorFName
    CollectorEmail

    Collector Favorite Artists Table:
    ColFavArtID
    CollectorID
    ArtistID

    Artists Table:
    ArtistID
    ArtistLName
    ArtistFName

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 05-16-2014, 12:32 AM
  2. Relationship Problems (regarding tables and database design)
    By lugnutmonkey in forum Database Design
    Replies: 1
    Last Post: 01-04-2013, 12:33 PM
  3. Late Database Design - Problems
    By Yesideez in forum Access
    Replies: 2
    Last Post: 06-26-2011, 05:20 PM
  4. Design problems
    By TracyBell in forum Database Design
    Replies: 20
    Last Post: 04-11-2011, 08:53 AM
  5. Database Design Problems
    By trini in forum Access
    Replies: 0
    Last Post: 03-05-2011, 11:24 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums