Building a Searchable Document Index in Microsoft Access (Word Docs, PDF Files, Text Files, etc.)

In this Microsoft Access tutorial, I'm going to teach you how to build a document index in Microsoft Access. We will store the names of our files in a table, along with a link to each file. We will then copy the text of that file to Access so that we can search the full contents of each document from inside our database. I'll also show you how to make a button to open each file using the FollowHyperlink command. Then, I'll show you how to make a simple form to search for keywords in the text of each document. Catherine from Provo, Utah (a Platinum Member) asks: I have to keep track of hundreds of different documents for each client. Is there a simple way I could put these all in a database and possibly search within the text of each document using Access? Silver Members and up get access to an Extended Cut of this video. Members will learn how to use Microsoft Word automation to automatically open each document and copy the text directly into the database. We will also see how to browse and pick a file with the FilePicker function. MEMBERS VIDEO:    • Document Index EXTENDED CUT MEMBERS ONLY B...   BECOME A MEMBER: YouTube:    / @599cd   or My Site: https://599cd.com/THMember LEARN MORE: Document Index: https://599cd.com/DocumentIndex LINKS: Blank Template: https://599cd.com/Blank Images: https://599cd.com/Image Query Criteria: https://599cd.com/Criteria Concatenation: https://599cd.com/Concat Wildcard Search and LIKE: https://599cd.com/Like Parameter Query: https://599cd.com/Parameter Value From a Form: https://599cd.com/FormName Intro to VBA: https://599cd.com/IntroVBA Relationships: https://599cd.com/Relationships Invoicing: https://599cd.com/Invoicing RECOMMENDED COURSE: Access Developer 39: https://599cd.com/ACD39 FREE TEMPLATE DOWNLOADS: TechHelp Free Templates: https://599cd.com/THFree Blank Template: https://599cd.com/Blank Contact Management: https://599cd.com/Contacts Order Entry & Invoicing: https://599cd.com/Invoicing More Access Templates: https://599cd.com/AccessTemplates ADDITIONAL RESOURCES: FREE Access Beginner Level 1: https://599cd.com/Free1 $1 Access Level 2: https://599cd.com/1Dollar Donate to my Tip Jar: https://599cd.com/TipJar Get on my Mailing List: https://599cd.com/YTML Contact Me: https://599cd.com/Contact TechHelp: https://599cd.com/TechHelp Consulting Help: https://599cd.com/DevNet Twitter:   / learningaccess   https://en.wikipedia.org/wiki/Microso... https://products.office.com/en-us/access https://microsoft.com/en-us/microsoft... KEYWORDS: access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, Searchable Document Index, FollowHyperlink, Search Text Box, Assign Documents to Customers, Browse and Pick a File, Microsoft Word Automation, Convert PDF to Text, Convert DOCX to Text, VBA to Copy Text to Database QUESTIONS: Please feel free to post your questions or comments below. Thanks.