X hits on this document

Powerpoint document

Access Database Design for Clinical Research Studies - page 5 / 10

35 views

0 shares

0 downloads

0 comments

5 / 10

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)

Document info
Document views35
Page views37
Page last viewedSun Dec 04 02:33:13 UTC 2016
Pages10
Paragraphs48
Words704

Comments