troubleshooting Question

Powerpoint CMS Database

Avatar of hennanra3
hennanra3Flag for United Kingdom of Great Britain and Northern Ireland asked on
Visual Basic.NETMicrosoft AccessMicrosoft PowerPoint
7 Comments1 Solution397 ViewsLast Modified:
Hello,

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.
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 7 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros