Creation of a searchable document index in Microsoft Access (Word documents, PDF files, text files, etc.)

In this Microsoft Access tutorial, I will teach you how to create a document index in Microsoft Access. We'll store our file names in a table, along with a link to each file. We will then copy the text from this file into Access so that we can search the full contents of each document from our database. I'll also show you how to create a button to open each file using the FollowHyperlink command. Next, I'll show you how to create a simple form to search for keywords in the text of each document.

Catherine from Provo, Utah (Platinum member) asks: I have to keep track of hundreds of different documents for each client. Is there an easy way to put everything in a database and optionally search the text of each document using Access?

Silver members and above have access to an extended version 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 select a file with the FilePicker function.

MEMBER VIDEO:
https://youtu.be/HkfCuRZUtvM

BECOME A MEMBER:
YouTube: https://youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/join
or My site: https://599cd.com/THMember

LEARN MORE:
Document Index: https://599cd.com/DocumentIndex

CONNECTIONS:
Blank template: https://599cd.com/Blank
Images: https://599cd.com/Image
Query criteria: https://599cd.com/Criteria
Concatenation: https://599cd.com/Concat
Search by wildcard and LIKE: https://599cd.com/Like
Parameter query: https://599cd.com/Parameter
Value of a form: https://599cd.com/FormName
Introduction to VBA: https://599cd.com/IntroVBA
Relationships: https://599cd.com/Relationships
Invoicing: https://599cd.com/Invoicing

RECOMMENDED COURSE:
Go to Developer 39: https://599cd.com/ACD39

FREE TEMPLATE DOWNLOADS:
Free TechHelp templates: https://599cd.com/THFree
Blank template: https://599cd.com/Blank
Contact management: https://599cd.com/Contacts
Order entry and invoicing: https://599cd.com/Invoicing
More Access Templates: https://599cd.com/AccessTemplates

ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: https://599cd.com/Free1
1 Level 2 access: https://599cd.com/1Dollar
Donate to my Tip Jar: https://599cd.com/TipJar
Subscribe to my mailing list: https://599cd.com/YTML
Contact me: https://599cd.com/Contact
Tech Help: https://599cd.com/TechHelp
Consultation help: https://599cd.com/DevNet
Twitter: https://twitter.com/LearningAccess
https://en.wikipedia.org/wiki/Microsoft_Access
https://products.office.com/en-us/access
https://microsoft.com/en-us/microsoft-365/blog/access/

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 Clients, Browse and Select 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.

Please take the opportunity to connect and share this video with your friends and family if you find it useful.