Innovation

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

The Microsoft Access template provides data structures that facilitate the organization and analysis of oncology clinical research data.

Advantages

The template provides user defined data fields and simplifies collection and retrieval of data.

Innovation Details
 

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

Template may not be used in the clinical management or diagnosis of humans.

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).


IP Protection


License Online

Thoracic Oncology MS Access Template and Associated SOP

Item type: Software
view license

Access template file and associated Standard Operating Procedure (PDF).
[more information...]

[Edit] [Delete] [Test]

$0.00

License Now

People

Principal Investigator:

Ravi Salgia Ravi Salgia

Innovations (3)


Case Manager:

Adam Conway Adam Conway

Innovations (14)


Download Technology Brief (PDF)


Followed By

Follow this innovation

Icon_avatar

Angelo Gámez

Member since
Oct 2010

Icon_avatar

James Wallace

Member since
Oct 2010

Icon_avatar

Devanand Pinto

Member since
Nov 2010

Icon_avatar

breastcancerdoc

Member since
Nov 2010

Icon_avatar

Ramzi Amri

Member since
Jul 2011

Icon_avatar

mlincoln74

Member since
Oct 2011

Organization
Communities
Profile
Related Tags

Find more innovations


February 11, 2009

7,868 members 17,196 innovations 152 organizations

Browse

Patrick Jones, Ph.D. Director, Technology Transfer - University of Arizona

"The iBridge Network nicely embodies the ideals of a well-designed, non-profit mechanism for aggregating, searching, and disseminating innovations from multiple research institutions."  read more...