I am interested in a creating (for personal professional use) a database that can manage all my powerpoint content. The solution design I am thinking of is:
- Using Microsoft Access as database for the custom built-application - including it's forms, programming and querying capability
- Having the ability to upload powerpoint presentations to this application
- Having the ability to segment presentations uploaded into individual slides
- Having the slides / presentations stored in a repository locally (as I guess in db itself it would snowball the size of access db)
- Having a GUI to control metadata for each slide to enable easy searching
- Having a 'shopping basket' approach to downloading content - e.g. you can search multiple slides and it will show a gallery of the slides and you can select the ones you want to download and this will then dynamically create a ppt for you
- Having the ability to 'flag for duplicates' in slides so you only see relevant slides as well as favourite slides,
- Having ability to have a metadata export whenever downloading slides to know exactly where downloaded slides reside on file directory including slide number.
A big part of the feasibility of this is how the Powerpoint controllability works in VBA (e.g. how do you write VBA to access files and slides) and how to manage the file storage, metadata and search functionality.
I am interested in any viewpoints with technical details as to how this can be done including understanding how the VBA model within Access or across the MS Office platform will support this application.
Note there are some cloud based off-the shelf solutions but I want to build my own as I believe I can do it better and cheaper.
The objective I have here is to be able to rapidly search for content and presentations and avoid the process of always digging around for things. The Metadata layer gives a low maintenance way of controlling access to the presentation content.
I have some background in building Microsoft Access databases and conceptual understanding of VBA having used many years ago now. So I know in 'theory' this is possible. Just want to understand practical guidance on how this can be achieved.