Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2006
    Posts
    1

    Is Access right for what I trying to do? New user.

    I am trying to accomplish a fairly straightforward task and I am new to Access. I am looking for feedback as to whether my objective is best suited by Access or whether an easier application will work.



    I want to enter person-specific information such as address, marital status, etc. (about 35 topics), into a form and then have the input information inserted into a Microsoft Word document as a sort of fill-in-the-blanks. To re-state this, I have a Word document that contains standard wording that, for the most part, will not change and I only want the person-specific information I input to be inserted at specific locations within the text of the Word document.

    I have already designed an Access "master form" and have created basic macros that will cause other forms to pop-up if I select certain options on the master form. However, I am lost on how to link the input from the Access forms to the Word document.

    I am prepared to dive into Access to learn the application, but I don't want to invest the immense self-training time if Access will not accomplish my objective or if there is a simpler way to do it. My understanding is that Access is great for storing information in a database, however storage of the information is not overly important to me. I primarily like the versitility of Access's form design capabilities.

    Sorry to ask such a basic question, but I am new to Access and the little bit I have learned so far made me realize the complexity of Access and I don't want to get side-tracked. Thanks for any help or advice.

  2. #2
    Join Date
    Dec 2005
    Location
    Wilmington, DE - USA
    Posts
    275
    redsled,

    Welcome as an Access user. As with you, I think one of Access's great strengths is that it enables you to quickly put a nice UI on top of a data store; SQL Server and MySQL are superior data stores, but neither offers that UI.

    In my opinion, you should go one of two routes: either use a Word MailMerge to create your Word docs, drawing on data contained in your Access database, or not use Word at all, and instead build an Access report that meets your document needs.

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

Similar Threads

  1. New Access User
    By Mermaid in forum Access
    Replies: 0
    Last Post: 11-07-2008, 02:28 PM
  2. user formula setup
    By elios115 in forum Access
    Replies: 2
    Last Post: 08-09-2008, 06:40 AM
  3. New Database - New User
    By mcarrigg in forum Database Design
    Replies: 1
    Last Post: 06-21-2008, 04:56 PM
  4. Problem with Read Only User
    By admaldo in forum Security
    Replies: 0
    Last Post: 04-24-2006, 11:51 AM
  5. knock off idling user
    By favor08 in forum Database Design
    Replies: 0
    Last Post: 02-24-2006, 12:14 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