Clinical Database Design Task #3 – Table Structure
Use information gained in the Excel exercise and in the question and answer session to determine the optimum table design structure.
Work on paper before committing time to programming. If the Excel file is in good shape, you can often manipulate and import rather than typing in Access.
After setting up tables, always set up formal relationships between tables to enforce referential integrity.
If possible, write queries to repackage and ask questions about your data before going on – this will ensure you have a table design that will eventually work (use dummy data for this exercise)