Results 1 to 6 of 6
  1. #1
    sandiego5 is offline Novice
    Windows XP Access 2007
    Join Date
    Nov 2011
    Posts
    2

    Can I use Access for this Idea?

    I have a job where I need to write a narrative or summary regarding my interview with a client. I hate to write. I always basically say the same thing with already made statements. Demorgrahpics usually change with the client. I have about 40 set statements already written out, I just copy and paste to make my narrative as appropriate using Word. Is there any way I can just point and click at the statements and the narrative will automatically be a paragraph. This would help me a lot and I can catch up with my workload. What program would I use, Access? Who could do this for me? Hopefully I am making sense. Thanks

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,948
    Access could do this. Aside from the table of 40 statements, need a table where you store the selections for a particular summary. Do you want them to show as bullets or as a paragraph? Bullets would be easier. Paragraphing will probably involve code or multiple queries to achieve.

    Could there be more than one summary per client?
    TABLE: Summary
    FIELDS: SummaryID (not unique), ClientID, StatementID
    Last edited by June7; 11-09-2011 at 11:27 AM.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    A S MANN is offline Advanced System Analyst
    Windows XP Access 2007
    Join Date
    Oct 2010
    Location
    India
    Posts
    161
    you need to create a small database to program the activity automatically.
    This involve Creating Table , Query to pick up statemente etc, Form where you select statements to clents, reports and lastly log file to records activity.

  4. #4
    sandiego5 is offline Novice
    Windows XP Access 2007
    Join Date
    Nov 2011
    Posts
    2
    I need to have it in paragraph form, not bullets

  5. #5
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,948
    That is possible, just more complicated to produce that output with the data structure I suggested. Build your database and when you encounter specific issue, post question.

    Review 'sticky' thread tutorials at http://forums.aspfree.com/microsoft-access-help-18/
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  6. #6
    DerFarm is offline Novice
    Windows Vista Access 2010 64bit
    Join Date
    May 2011
    Posts
    8
    Have you considered using macros in Word? It would probably be somewhat of pain to get them in, but once they are there ....

    I should think you could treat them as it they were different signatures

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

Similar Threads

  1. Ok .. need to bounce an idea off your head!
    By Phoenyxsgirl in forum Database Design
    Replies: 8
    Last Post: 10-07-2011, 05:31 PM
  2. any idea on calculating average?
    By sk88 in forum Access
    Replies: 3
    Last Post: 08-30-2011, 11:32 PM
  3. Password Idea (how to implement?)
    By dinorbaccess in forum Access
    Replies: 2
    Last Post: 02-17-2011, 07:45 AM
  4. Idea's on how to create a database
    By Bentley68 in forum Access
    Replies: 5
    Last Post: 08-23-2010, 09:33 PM
  5. Need help with 'note book' idea.
    By Luk3y in forum Access
    Replies: 0
    Last Post: 06-26-2009, 09:54 PM

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