Data Management & Storage/Forms & Database

Advertisement


Question
Hello -

I work for a small non-profit office that requires that clients complete a form before arrival.  I want them to be able to complete the form online, have the info go into a database, and be able to call up individual entries on their own, to add more information. Or even email the form back to the office for us to somehow easily import. I've played around with google forms, which is great - but I can't pull individual records (all the info just goes into a spreadsheet). I wouldn't mind extrapolating the data, but I work with someone who isn't as tech savvy, and this wouldn't be an easy solution. Is this something that I can do in Microsoft Access?  I am pretty quick study with new software, and can probably master the basics and even intermediate levels of the application.  But if this is do-able, would it be something that would require more advanced programming, etc? Or can your above average (but not expert!) user take on something like this?  Or is there some other application you'd suggest?  I've toyed with Adobe Forms Central, but I hear they're phasing it out soon.

Thanks so much in advance for your help!

Answer
Its something that can be done with Access 2013 and an Office 365 account. This is called a hybrid application where data is entered through a web form then stored in a SQL Azure database. You can then create a reguklar desktop app in Access that would also link to the SQL Azure database.

But yes, this is something that someone more advanced would need to do.

Any decent WEB programmer can create a WEB site to collect data, then export that data so it can be input to a local Access database.

Hope this helps,
Scott<>

Data Management & Storage

All Answers


Answers by Expert:


Ask Experts

Volunteer


ScottGem

Expertise

I have been an IT professional for over 16 years. During that time I have accumulated a large store of knowledge and experience. This allows me to assist with a large variety of technology issues. My specialty is Database design primarily with MS Access. However, I can answer questions on many different IT related topics.

Experience

I have worked in IT support for over 16 years. I have also helped people in cyberspace for a good portion of that time. I have been a volunteer staffer on Prodigy and AOL. I was the #2 ranked expert at AskMe.com (#1 in Technology) and am currently ranked at or near the top at Answerway.com and PointAsk.com.

©2016 About.com. All rights reserved.