Results 1 to 2 of 2
  1. #1
    abdulhafiz is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Nov 2016
    Location
    lebanon
    Posts
    1

    need help ebboks database design

    Dear forum members. i would like to tell you that i have no experience in MS Access. but i would really appreciate your help. my pc runs windows 7 with MS 2007.

    i am a pharmacist and in my field i use references books at work. so my pc has hundreds of refernce books in pdf formats and word files and articles also.
    the question is : 1- Is it possible that i can place all these e books in one database and do sub categories?
    2- the more difficult part: Is it possible to design a form that i can input a text search and MS Access does the text search i queried inside the pdf files or word files and display search results?

    your help is appreciated.
    thanks a lot

  2. #2
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    answer to Q1 - yes, but rather than store the files in a db, store them in a directory and have a record in access which stores the path to the file together with some relevant data such as date of publication, author etc, plus probably a related table with keywords for an initial search.

    Answer to Q2 - yes for word, and yes for pdf providing you have the appropriate software such as Adobe Acrobat - see this link, it relates to using excel rather than access but the code principle remains the same.
    http://stackoverflow.com/questions/2...sing-excel-vba

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

Similar Threads

  1. PTO database design
    By ladyrider696 in forum Database Design
    Replies: 3
    Last Post: 06-11-2015, 04:43 PM
  2. Database Design
    By Trek9635 in forum Access
    Replies: 4
    Last Post: 01-31-2015, 12:19 PM
  3. Replies: 2
    Last Post: 01-28-2013, 04:42 PM
  4. Database Design for Specification Database
    By khwaja in forum Database Design
    Replies: 2
    Last Post: 11-24-2011, 03:58 AM
  5. Database Design
    By shutout14cf in forum Database Design
    Replies: 10
    Last Post: 12-20-2010, 11:04 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
  •  
Other Forums: Microsoft Office Forums