New evaluations of the patient data from an application database are created in MS Excel. The goal is to combine the attributes of the patients with specific laboratory data and thereby to detect any trends. The evaluations are configured on the basis of the patients’ blood values, diagnoses, medications, or consanguinity. Also, the application database was migrated from MS SQL Server 6.5 to the 2000 version.
Supplement
The relevant views of the data are created using database views. There is further processing (e.g. manual plausibility check, creation of cross queries) in Microsoft Access. The Excel reports are generated from Access: An online connection with the original SQL Server database is not required. The application database is migrated by creating a backup under MS SQL Server 6.5, which is recovered in SQL Server 2000.