2 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Simple data collection form?

Hi,
I work with a ... 'technologically challenged' group that would like a very simple data collection form where you just input someone's name , age, address etc and it will put it into a table or database. I would just use google forms but they require it to be offline, and with excel I could do it simply with some cell input linking to a table on another tab but ideally I would like to give it a bit more of a UI , maybe with macros, so they have a 'submit' button and it's harder to mess up input. Due to GDPR it would also need to be secure somehow too.

They had someone build them a database years ago using microsoft access but it's kind of outdated now and janky and we would all love to get them off that system.

Is there a way to do this in excel? Because there's no way they could handle a SQL database, but they basically only need a single table for the data because it's just for checking if someone has contacted them previously.
TIA!

submitted by /u/SirSeaSlug
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#data collection form
#Excel
#macros
#database
#UI
#GDPR
#security
#Microsoft Access
#SQL database
#offline form
#table
#data input
#submit button
#single table
#contact history
#address
#age
#name
#Google Forms
#technologically challenged