Microsoft Office Forums - View Single Post - [Solved] Create an index to 2700 audio files

Guessed · 05-13-2021, 03:29 PM

Word is not the right program for a database of 2700 entries. You should be looking towards Excel or Access instead.

Is the point of this so that you can filter the list based on tags like 'show me just the files with tag/keyword'?
Will there be only one timestamp per file or will there be a timestamp per tag?
If there is a timestamp per tag, can there be more than one timestamp per tag?

Note that when you tell me that my previously supplied solution is inelegant then you will find that I'm going to expect you to do a lot more of the pre-work. I expect you to post an Excel workbook containing sample data and a validation list of keywords (hint: learn about Data Validation in Excel). I'm not going to help with a Word solution because I can tell you that it will be far less elegant, slower and more labour intensive than can be achieved in other software.

Depending on your answers to questions 2 & 3, Excel may also not be the best solution as you should have a relational database like Access.