• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

Design of solution - In solution to the doctors surgery system that I am implementing, I will be using Microsoft Access.

Extracts from this document...

Introduction

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 patient ( Forename Text 20 ( The first name ...read more.

Middle

Likewise if I want to add a doctor I would use the doctors form to enter this data. Above is how I intent to set out each table within my system. This is my intention since they will then hold all the appropriate data and information for my doctor's surgery. However to make my system more efficient I will need a number of search formats. Searching is where I can look for a specific patient in my system through a search that will be similar to the one below. I will display all the search formats I am going to incorporate. Search Screens Above is a search for an patient. This would be useful if I need to find a patient if the details need to be changed (e.g. the person has moved houses) and instead of searching through every member I could just find them using a search. The search procedure will be executed when a patients details need to be changed or information needs to be retrieved about a member. ...read more.

Conclusion

However the add new member button will be located on the last person of the patients form or on the mainform (this is the form where you can access any part of the database from. As I briefly touched upon before I will have a splashboard, which will enable me to easily access and view all areas of my system. The inputs of my system will be such things as adding a patient, deleting a patient and making appointments. The processes in my system will be such as searching for a patient and the outputs will be making reports. Of course when I click on a area on my splashboard I want to go, I will get taken to its respected form with a back button at disposal just in case I want to get back to my splashboard. These links from different areas of my system will require the use of macros and I feel that the above shown splashboard buttons are all that is needed for my system. However this is at the time of writing so there might be another button required or an idea that I can add, which is beyond me at this moment. ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our GCSE ICT Systems and Application section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related GCSE ICT Systems and Application essays

  1. The Advantages of Using ICT Over Manual Meethods. Using Paint and Access.

    Microsoft access opened. There should have been pictures inside it to show it more easily I am testing to make a letterhead. To make a letterhead first you insert your slogan and logo wherever you want then you type in the address where want it to go then you type in the postcode.

  2. System administration report

    Each heading is analysed to the administration of the system. Management procedures It is well-structured procedures with regard to management as there is regular meetings each week to highlight important issues such as running of the network, how the network can be improved, and employee's welfare with regard to ICT.

  1. Database design.

    Entity types - VIDEO STORE Unnormalised Customer (Customer_ID, Customer_surname, Customer_firstname, customer_street, customer_town, customer_postocde, customer_phone (Video_name, category, cert, rental_price, date_out, date_returned, video_copies)) 1NF Remove repeating groups Customer (Customer_ID, Customer_surname, Customer_firstname, customer_street, customer_town, customer_postocde, customer_phone, Video_ID) Video (Video_ID, Video_name, Video_category, Video_cert, Video_rental_price, date_out, date_returned video_copies)

  2. Benefits of using my IT system in the Travel Agents.

    * Then, you should go on Blank Database. * Finally, you can start creating your table. Using Formats (in Dates) * First, you should go on Microsoft Access. * Then, you should go on Blank Database. * After that, you should Right Click on Table and click on Design View.

  1. ICT Access

    Another Method that the current system can be improved is by the organization of files into alphabetical headings and entering them into separate files labeled clearly however this possesses many faults as it would require a lot of space and would take a long time to organize each clients files.

  2. Create an IT system for my karate club.

    Outputs Once I have gathered all the information and put it into table form for the Sensei to see I will then need certain print outs and things for the club: 1 I will need to printout a new form, which will be given out to members so they can

  1. The system chosen for this application is the computerised system. This computerised system works ...

    This makes the obvious choice the Application Specific software types. Other important features that are included are: 1. The data that is stored is undivided and can be viewed altogether so there is not time is switching back and forth between records.

  2. My ICT based solution.

    Another disadvantage would be the cost of the whole system; a teacher would have to be employed just to record the details of the books borrowed. The first is that it can be as fast as possible, and this is achievable because unlike a computer, this system can be operated by the user's speed.

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work