Results 1 to 3 of 3
  1. #1
    enb_eng is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    3

    How to create forms that others can use WITHOUT Access? (New to Access)

    Hi,

    I am trying to create an Access database for tracking. I have watched a ~6 hour intro on youtube on the basics of Access. I am 100% willing to spend the time learning some of the more advanced features, but need some guidance as to what to look for so as to best use my time.



    Everyone who will be filling out the form has access to Word, Excel, Sharepoint, and other office-type applications.

    But not everyone will have Access installed, and it would not be prudent to ask everyone to install it in order to fill out a form.

    Is there a method for a form created in Word, Excel, PDF, or any other generally available software to automatically fill an Access database?

    Or, is there a way, by creating a web database in access to be used with a Sharepoint, to create some kind of web-based form that will automatically fill the database?

    Thank-you

  2. #2
    NTC is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    Nov 2009
    Posts
    2,392
    in order of increasing complexity:

    a. set up a template in excel, users send their excel to an admin person who imports the data; not real time of course
    b. set up a template in excel, set up linking to Access table
    c. set up a run time version of your Access front end file
    d. develop a web form with Access/SharePoint

  3. #3
    enb_eng is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    3
    Thank-you for the help

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

Similar Threads

  1. Replies: 3
    Last Post: 10-31-2013, 02:36 PM
  2. Replies: 2
    Last Post: 11-21-2012, 09:57 AM
  3. Replies: 4
    Last Post: 04-26-2012, 08:25 PM
  4. Replies: 0
    Last Post: 02-08-2011, 02:34 PM
  5. Replies: 2
    Last Post: 02-10-2009, 12:02 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