Thoracic Oncology Research Program Microsoft Access Template
University of Chicago
posted on 09/03/2010
Access template for the preparation of an oncology database that integrates data from the clinic, clinical research, translational research, and basic science research.
Suggested Uses
Advantages
Detailed Description
Ravi Salgia and colleagues at the University of Chicago have developed a Microsoft Access Database Template specifically formatted for use in thoracic oncology clinical research. This ready-to-use template contains five tables comparing Patient, Sample Data, Tissue Microarray, Genomic and Literature fields. Users can readily customize the fields for their specific area of study, although the existing template has a highly detailed taxonomy that is easy to navigate and provides powerful data pivoting and graphing functions that simplifies the management and presentation of clinical, preclinical and other types of experimental data. The template is fully compatible with Microsoft Excel and Sharepoint as well as any Access-enabled application software which simplifies data sharing. The template can be licensed through this iBridge portal.
Template Features and Potential Applications:
- Detailed proteomic biomarker data
- SNP information and mutation status
- Detailed patient biometric data, medical history and environmental exposure information.
- Clinical diagnostic data fields
- Seamless data transfer to and from Excel files.
- Query patient information against tumor microarray, genetic and biomarker data fields.
- Template includes a Standard Operating Procedure (SOP) for data entry.
Potential Applications
- Map proteomic and genetic profiles to patient survival statistics
- Multi-investigator data-sharing of clinical and experimental information.
- Rapid report generation through user-developed queries.
Patient Data: cancer stage, histology/pathology data, drug treatment history, radiotherapy status, clinical trial identifiers, smoker status.
Sample Data Table: Specimen type, initial, recurrent or autopsy tumor.
Tumor Microarray Table: Biomarkers (EGF, c-Cbl, c-Met, Paxillin, pFak, etc) expression status, protein phosphorylation information, organ source, Tumor histology and tumor characterization.
The use of the Thoracic Oncology Database Tool is described in Surati et al Journal of Visualized Experiments Jan 22, 2011.A related SOP for use with the eVelos system is now available: Thoracic Oncology Program Database Project (TOPDP) eVelos (Oracle) Database Standard Operating Procedure
Limitations
File Number: 1894
Disease: Cancer
Other Information:
ACKNOWLEDGEMENTS
We would like to thank all of our colleagues at the University of Chicago who have given us invaluable advice. Also, this work is in honor of our thoracic oncology patients at the University of Chicago. In part, this was supported by Grants from: NIH/NCI (3R01CA129501-02S1 & 5R01-CA129501-03 [especially supplemental award which was specifically geared to generate this large database]; 5R01CA125541-04 (especially for non-small cell lung cancer); 5R01CA100750-07 (especially for small cell lung cancer), Guy Geleerd Memorial Foundation with the V Foundation, Respiratory Health Association of Metropolitan Chicago, Cancer Research Foundation (Goldblatt Award), and University of Chicago Thoracic Oncology Program Initiative (to Ravi Salgia).
|
Thoracic Oncology MS Access Template and Associated SOP Item type: Softwareview license
Access template file and associated Standard Operating Procedure (PDF).
|
[Edit] [Delete] [Test] |
|---|
Find more innovations
