Is it possible to Use Microsoft access to database existing word documents?

I have been asked to create a database of my brothers school notes using his typed up notes on microsoft word. he insists that i can use microsoft access to do this. my question is asking if its possible to create a access database that can link you to whatever you need. for example, if i wanted 'biology' notes, i could use a query to find them and it would give a list of documents tagged with 'biology' and would allow me to open any of the files on the list.

im not convinced this is possible, and if it is, how? im an intermediate user and im using access 2007. if not, what else could i use? is it possible to construct a sort of web page for the project? help would be appreciated.

Anything is possible with Access. =)

I recommend starting by creating a table that has the path to all the Word Docs. I suggest you keep the full file name in there "C:\blah\blah.doc" as opposed to "blah.doc". I would add a description, and a key terms field as well. I then would build a form off of that table. You can add a search function to it, and you can also have a button that runs the below code to open the word doc.

I know I went over these quickly but this is just how I would do it. If you have access it would be the best tool. I am not good with the data access pages you find in Access (a web page option). I think it is simple enough to do in access.

Function OpenWodDoc(FileName As String)
Dim objword As Object
Set objword = CreateObject("Word.Application")
objword.Visible = True
objword.Documents.Open FileName
Set objword = Nothing
End Function

You can import it into access, the import wizard lets you customize the info and the look. If you have office 07 then you just need to find the right button and the wizard come up rather than searching for it on office 2003.