I have a library of videos, and I made a database so that you can easily find a relevant video, but I want to start again and make a new database because it is not the best format, so it is not easy to update (i used merged cells, so editing or removing a "row" of data is really difficult and manual).
The trouble is, I am not too sure what the best way to layout the data would be.
Each video has a number of categories of data, such as Language, Subtitles, Industry, Use Case etc.
And for one video, each of these categories can have numerous entries. e.g. a video can have subtitles in more than one language, it can be in more than one industry, for more than one use case etc.
The purpsoe of this database is to quickly filter by whatever category to quickly find a video that matches your requirements.
So you are able to find a video that has:
Subtitles in English, Swedish and Danish
Use Cases of Internal Communication, External communication and Support
Industry etc. etc.
The original database I created works pretty well for this search and filter function, but as I said, it is not a sustainable format and does not support easy editing.
I have attached a dummy version of my database, so you can see how I have it now and you can see how it works with filtering the data to display only relevant videos.
Please suggest how I would layout my database as I need to start building it ASAP!
Thanks
Bookmarks