|I've been asked to organize a large (5,000+) collection of video clips in a searchable format. The person in charge of the videos would prefer to use excel because it's already installed. I'm afraid that given the large number of clips, it would be very difficult to search the collection.|
Proposed columns names are: Country name, Themes (aka departmental priorities), Specific Keywords, Date recorded, People, Partner organization, and File name/filepath
I see potential to limit the search by filtering the data before using CTRL+F. However, since there will be multiple keywords for each entry, the filter function will be basically useless for the keyword field, which is the most important one.
1. Is it possible to do multiple keyword searches using excel? I've looked at articles online, but most examples are for numerical data (inventories, employee numbers etc.), and my data is almost entirely text.
2. Would another program be more appropriate? I've looked at info on Microsoft Access and Filemaker Pro, but I have 0 experience with databases and I'm confused by the terminology.