Logged out
Access All our Essays in an Instant
Swap your work for FREE access, or pay £4.99 for instant access
Design of solution - In solution to the doctors surgery system that I am implementing, I will be using Microsoft Access.
Member rating: No Rating | Words: | Submitted: Mon Aug 18 2003
Page Preview
On the left is an image preview of every page of this document, and below are the first 150 words with formatting removed:
Design of solution In solution to the doctors surgery system that I am implementing, I will be using Microsoft Access. After studying the alternatives I feel that Access is the best solution since it will allow me to make databases with relationships and queries unlike other alternatives like Excel, hence this choice. This system will need to be based upon three tables- * Patients Details * Doctors Details * Appointment Details My implementation will begin with the design of the database before considering data collection, data capture and the various outputs required. On completion I will need to thoroughly test the system to ensure that it works as expected by using both valid and invalid data. I will then write user documentation to allow the staff to use the system. Below I will show the table design, firstly with the patients details table Keyfield Field Name Type Size Validation Description ( Patient_no Autonumber LI Autonumber Key field and specific to each patient ( Title Text 4 ? The title of a patient ( Surname Text 20 ( The Surname of a...
Get instant access
- Instant, unlimited access to our documents in full
- Swap your work for free access, or pay £4.99
- To see the full version of this document and 149,430 others
