A Custom Relational Database For Under $1000.00!  A Microsoft Access Project   From the moment we were contacted by Hudson Hospital's Medical Imaging Department with the idea for the Birthcard Project, we knew we could help.  The department was in the middle of moving to a new campus on I-94.  And, while the department was strapped for time and money, (who isn't?), the Medical Imaging Manager wanted to update the manual 3" X 5" file card system with its heavy, side by side cabinets dating back to the 1950's, with an electronic system more in synch with the new facility.   Several factors acted as an impetus to move forward: The planned department was larger, spanning two floors.  The solution needed to allow users to access data from all of the PCs in the department and provide inter-departmental access to authorized users throughout the facility. While the new department was scheduled to receive a Radiology Information System in conjunction with new hospital-wide software, the software vendor did not have a way of incorporating old patient information.     They needed a solution now!  The typewriters used to record patient data on file cards were old, and hard to maintain. The fifty (50) year old card files used for data storage used precious floor space, were an eye-sore, and not in step with the new facility's decor. "File Card" Solution1 "In-House" Solution1 "In-House" Solution1 Incisive Access Solution1 Users opened the app by double clicking the back-end "x-ray" table Users wrote "free form" directly into the back-end table Developed a user-friendly input form for efficient data entry  (1) Note:  Click thumbnail to see larger graphic...   The first attempt at moving forward was a crude "in-house" solution requiring users to write directly into a back-end table.  The solution did not enforce data quality.  Entering data was slow and cumbersome.  Each user invented his or her own abbreviations for exams as they went along.  For example, in the case of bilateral mammography, sixteen (16) different codes were created for patient's with names beginning with A through C:   BIL MAM... BIL MAMMO.. BIL. MAMMO BILAT MAMMO... BIL MAMM BIL MAMMO... BIL. MAMMO... BILMAMMNO BIL MAMM.. BIL MAMMOLLL BIL.MAMMO BILMAMMO BIL MAMMO BIL MMAMO... BILAT MAMMO BILMAMMO...   Moreover, the table did not use relational database design.  For example, there was nothing preventing exams from being related to the same patient with multiple spellings of their last name.   Incisive delivered the solution in less than ten (10) days from the order date at a cost of less than $1,000.00!     The delivered product met all of the clients' requirements: Enterprise-wide database access from all PCs on the LAN Electronic solution that replaced the file cards, cabinets and typewriters Smooth, efficient work-flow that improved department data quality and morale'     Note:  Patient data is fictional.  This display fully complies with HIPPA confidentiality guidelines.

Incisive applies its rare blend of programming skill and business savvy to every project.  We understand your challenges and can assist you in identifying problems and delivering effective, user-friendly solutions to problems at a reasonable cost.