Resources from

REDWrap

No Comments

Updated 9/12/23 REDWrap is a free utility for converting REDCap data exports to a normalized relational data format. It runs in Microsoft Access and converts the flat-file REDCap export into Access tables, created with a more logical (normalized) structure. It’s available in version 1.22. Download here. Requirements Since REDWrap uses Microsoft Access, it can only… (read more)

Safe end-user querying for Access

No Comments

When developing a new database, smart practice is to start from the reports and work backwards from there. It’s easy to get excited about all the interesting data that we want to put into the thing. But at the end of the day, what really matters is the data that somebody, someday, will need to… (read more)