Internosis - knowledge management,ecommerce and project consulting
*Home>>>Microsoft Project

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.

Tags
  Project Tools   Project Software   Project Planning   Project Consulting   Project Manager   Project Management   Microsoft Project   Knowledge Solution   Knowledge System   Knowledge Transfer   Knowledge Manager   Knowledge Sharing
Related information
  • Looking for a formula to subtract a range of cells on Microsoft Excel?

    If you need to subtract the total of a column or row, you can put a formula cell at the end of that column or row... ex. =sum(A1:A7) And then subtract that cell's value in the cell you'...

  • I need help. for a school project i downloaded a free 60 day trial of microsoft office 2007...?

    when you downloaded the 60 day trial it should have given you a product code that would unlock it for the 60 days. Check to see if you got any emails from Microsoft about it. Id you want to swi...

  • When ever I hit the backspace button in Microsoft word 2007 the save as screen appears?

    This is probably due to quickkeys or filterkeys as I think they're called. Go to your control panel and click accessibility options.Whle on the keyboard tab make sure none of the 3 choices ava...

  • I need a description of microsoft office 2007 visio ,office 2007 project and expression web?

    The following sites will give you all the information asked. Visio Home Page - Microsoft Office Online Microsoft Office Live. Microsoft Office Visio. Search. Search. Try Visio 2007. Buy Visio 2...

  • I have a microsoft word project and i have to make a fake company name and sell a creative product. any ideas?

    You could sale robots. You could go as simple as the little robot dogs and cats at the toy stores to big complicated robots that arent even out yet. You could probably even make some up.

    ...
  • Microsoft Project Server 2003 or Project Server 2007?

    for something like this at the enterprise level i would demand some answers from microsoft directly.. you may get some tips here but this is likely something ms is aware of.

    ...
  • Using Microsoft Project 2000 do you use the cost management features? In what ways do you use it?

    yes we use it to calculate the cost of resources which are included in the project. Good luck!!!

    ...
  • What is the microsoft project software?

    It lets you plan out projects. It contains a gantt chart so you can see what pieces of the project are assigned to whom, what dependencies each piece has and what timeframe each piece should be do...

  •  

    Categories--Copyright/IP Policy--Contact Webmaster