Dec 08 2022 03:02 PM
Dec 08 2022 03:02 PM
I am an amateur at using Excel and now it appears that I am going to be tasked with creating a data abstraction tool for my company that abstracts medical charts. I need to create an abstraction tool that acts very similar to Google Forms to prevent data entry errors when abstractors are entering patient information and the applicable data. I cannot really find much help on Google. Does anyone have a guide that they would like to share? Preferably a guide for dummies lol. I did find this; it is very similar to what I will probably need. However, this is from a guide on how to use an already created tool, not a guide on how to create it. Does anyone have any ideas on how to help?
Dec 10 2022 03:44 AM
Questions to ask yourself:
If you determine that you will use Excel…
Realize that you can write Excel formulas that are excellent at manipulating cell information (and this community can certainly help), but if your forms need to respond to user actions in ways other than formula recalculation, you will very likely need to write code in the procedural language VBA (Visual Basic for Applications; it's very similar to classic Visual Basic, less similar to VB.NET). Both Excel and Access and even Word rely on VBA for advanced custom capabilities.
You can browse your local library, which is very likely to have books on VBA, or even a used bookstore. The language has not changed (to my knowledge) for many years, so even an older book will be useful. If you are not already familiar with classes, objects, properties, methods, and events, start by learning a little about them – they apply for most modern computer languages, and there are probably YouTube videos with a good introduction.
Aside from learning VBA, do your initial design work: both sketch out the appearance of your forms and determine what features/capabilities (record search, retrieval, security…) and behavior (validation and data flagging, data storage…) they must have. Once you have more specific questions, ask again (in a separate post(s); identify which version of Excel you are using).