Clinical Database Design Real-World Demonstration
Rework Excel File into sheets for each table with field names and values.
This should be done only after 2-3 cuts at Excel file, screening form and flow sheets.
Import sheets for demographics and study measurements into Access.
Clean and check results.
Set up relationships.