Results 1 to 4 of 4
  1. #1
    bslarch is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Feb 2015
    Posts
    1

    Database With Tags for Images

    Hi All,



    I produce visualisations for architecture companies and use a lot of 2d images of people, cars, trees, skies, etc. As it stands now, I have a folder that contains a huge amount of images that I flip through when I create a new image. I have seen that some websites, such as http://www.gobotree.com/ allow you to filter through an image database based on different tags. I would like to create a similar database, but stored locally on my computer. I have actually never used Microsoft Access before, but I'm thinking that this might be the best program for me to use. Is this true? Any other recommendations to search through a personal database based on specific requirements?
    My second question, if Microsoft Access is the best software to use, is how would I actually go about doing this? Are there any specific tutorials that would help me with this? Essentially I would like to organize my library of images of 2D people based on things like: 'staring', 'bicycle', 'looking up', 'back view', 'crowds', 'pointing', 'sitting' etc.

    Any help would be greatly appreciated. Thanks!

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,930
    Access should be able to do what you want. It has an Image control that is very versatile for dynamically displaying various image file types (not PDF).
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    in terms of table structure you could have something like

    Code:
    tblImages
    ImageID  ImagePath  ImageName
    1        c:\test\xx\ Image1.jpg
    2        c:\test\yy\ Image2.jpg
    
    tblTags
    TagID  TagName
    1      Bicycle
    2      Staring
    3      Looking Up
    4      Back View
    5      Crowds
    6      Pointing
    
    tblImageTags
    IT_ID  ImageID  TagID
    1      1        1
    2      1        5
    3      1        6
    4      2        2
    5      2        3 
    6      2        5
    the table tblImageTags would be a junction table linking your image to your descriptors. Then searching for images with a particular tag becomes simple.

  4. #4
    orange's Avatar
    orange is online now Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,726
    Further to comments so far, you could have some categories of Tags to make searching more levels of detail for precision. Perhaps not in your specific case, but from a concepts point of view.

    Season
    TimeOfDay
    CityScape
    SeaScape
    Rural
    Geography
    People
    Animals
    ...etc
    Just looking to expand Tag concept.

    Good luck.

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

Similar Threads

  1. Help with adding tags to a database design
    By richardcb in forum Database Design
    Replies: 11
    Last Post: 06-19-2014, 03:37 PM
  2. Removing images from the database
    By ksammie01 in forum Access
    Replies: 4
    Last Post: 01-15-2013, 12:50 AM
  3. How to view images in a database.
    By Samari in forum Access
    Replies: 1
    Last Post: 04-03-2012, 06:16 AM
  4. Replies: 17
    Last Post: 08-26-2009, 11:27 AM
  5. Images per record, database form OCX
    By lochie360 in forum Forms
    Replies: 3
    Last Post: 07-26-2009, 03:50 AM

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