Question: I want to establish an archive with a keyword search facility. Which software is best? Where can I obtain it? I make short video features.\nI want to archive written notes on each shot, interview clip etc.\nI want to be able to tap in a keyword and for the corresponding entries to appear.\nIf possible, the archive could also contain still photos with their descriptions.

Answer: Microsoft Access is excellent at creating databases in a simple home based environment. You can buy at through any Windows Office package (the later, the more advanced). There you can go through a Database Wizard that gives you a step by step on how to create your own Database. With this database, you can literally store all your documents, videos, and pictures in one thing and can be accessed through one search. Though this will take some time as you must locate all file locations and provide descriptions / keywords for each.
This question from the Yahoo Q&A forum is categorized in the topic: Society & Culture