Results 1 to 2 of 2

Changing Word Doc into Access Database

  1. #1
    rfschmeck is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2017
    Posts
    1

    Changing Word Doc into Access Database

    I have a rather long Word Document that everyone in my office updates on a monthly basis. It contains around 40 different active studies that the employees are working on. The format is: study title, short description of study, names of employees working on study, and a list of dates and actions taken on those dates.

    example:



    AQ CONFORMITY [Porta/Brooks]

    Conformity designation and 2033 Long Range Plan adopted by MPO Policy Committee.
    04/26/13 - EPA has concurred with conformity report.

    My question is can anyone think of a way to design an access database to keep track of this information? The Word doc is a problem b/c only one person can have it open at a time.

    I'm kind of stuck, Any thoughts would help

  2. #2
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,329
    Your description is a little hard to follow due to formatting in the forum. Perhaps if you uploaded a sample of your word document. Maybe 10-12 records so we could see how it lays out and the best way to offer a workable solution. Also, what data would you like to extract from the database once it has been created? This will require the building of queries that you should think about.

    Here is a link to a DB Schema on Projects that may be helpful

    http://www.databaseanswers.org/data_...ects/index.htm

Please reply to this thread with any new information or opinions.

Similar Threads

  1. linking word document with access database
    By Gadai in forum Import/Export Data
    Replies: 1
    Last Post: 07-08-2016, 01:37 PM
  2. Replies: 4
    Last Post: 03-05-2015, 07:50 PM
  3. Creating Word 2010 Charts using Access Database
    By tbelly82@gmail.com in forum Access
    Replies: 2
    Last Post: 05-28-2014, 05:16 AM
  4. Replies: 5
    Last Post: 04-01-2012, 11:50 AM
  5. Replies: 1
    Last Post: 07-12-2010, 07:49 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums