No abstract

Background Data management is the key to the success of all projects and research. The ability to safely store, manipulate, and decipher data in real time is invaluable. Currently data management standards in public health are non‐existent. Since the invention of computers real‐time data retrieval and analysis has been possible but underutilized by researchers in the field. Historically, most small research studies and field‐based projects have utilized spreadsheets for data management, which often proves problematic as the project grows. However, a viable and superior alternative exists in relational databases, such as REDCap. Relational databases allow for easier concatenation of multiple legacy datasets, facilitate data entry with surveys that incorporate branching logic, and allow for real time data entry in the field without the need for WIFI. Methods One example of a public health project being transitioned from spreadsheet data management to a relational database is the Farmworker Family Health Program based out of the Lillian Carter Center for Global Health & Social Responsibility at Emory University's Nell Hodgson Woodruff School of Nursing. The data management transition from spreadsheets to REDCap has provided the team with unique insight into the data that has been collected in the 30 years the program has been running. Conclusion Through this case study, we identify the need for and recommend that those in public health nursing utilize relational databases when collecting data during research studies or as electronic medical records for field clinics.

No abstract