Constructing a database for patients with nasopharyngeal carcinoma by using microsoft access 97

Research output: Contribution to journalArticlepeer-review


One of the most laborious task that clinicians face in their research, is the management of clinical data for cancer patients, which involves repetitive collection, organization and comparison of excessive amount of information. To alleviate such burden, the establishment of a database for these patients is of importance. Through systematic storage procedure, large amount of information in a database can be integrated and analyzed both rapidly and effectively, which in turn will improve the efficiencies of research and clinical studies. Therefore, an attempt was made to set up a database for patients with nasopharyngeal carcinoma, using the Microsoft Access 97 software. The file structure of the database was first constructed before various clinical data of individual patient with nasopharyngeal carcinoma (NPC) being introduced. After a number of modifications on the database structure and input items, the database was completed in four months time. Results from field tests showed that the database could effectively integrate and analyze various clinical data for NPC patients. Information of individual patient could also be introduced or edited directly during outpatient visits, to keep the database up to date. Furthermore, the database could also help to keep track of patients who did not show up for regular follow up visits. All these features could help a physician to monitor both clinical and research studies more closely. In conclusion, the present database system provided satisfactory general performance. The software being used to set up the present database was a reasonable choice, because of its ease to learn and use, together with the fact that setting up the database required no programming language.

Original languageEnglish
Pages (from-to)394-398
Number of pages5
JournalJournal of Taiwan Otolaryngology - Head and Neck Surgery
Issue number5
Publication statusPublished - 1999

All Science Journal Classification (ASJC) codes

  • Otorhinolaryngology


Dive into the research topics of 'Constructing a database for patients with nasopharyngeal carcinoma by using microsoft access 97'. Together they form a unique fingerprint.

Cite this