02 Jul END USER SYSTEM “FOR YOUR TEETH OUR SMILE”
End User System “For your teeth our smile”
Referencing: In the main body of your submission you must give credit to authors on whose research your work is based. Append to your submission a reference list that indicates the books, articles, etc. that you have read or quoted in order to complete this assignment (e.g. for books: surname of author and initials, year of publication, title of book, edition, publisher: place of publication).
TASK DESCRIPTION
(Lecturer please insert task(s) / questions / what the student must do, here)
A local cosmetic dentist ?�Your Teeth our Smile, specialises in the treatment of tooth alignment and repair, Hollywood veneers and denture creation or replacement plus general cosmetic repair.
The dental hospital has ten dental surgeries and one operating theatre. Each surgery is identified by its room number. All patients admitted to the hospital are assigned to a particular room. However during their treatment, which can last up to 12 hours they may be transferred to different rooms. If a general anaesthetic is required use is made of the operating theatre and patients must stay over night in one of the four private rooms available.
Patients are admitted for treatment which may involve several procedures. Treatment may require general surgery, in which case and operation is scheduled.
Patients are referred to the hospital from their NHS / private dentist. They are then diagnosed, and arrangements are made for future admission. Patients are sent notification of scheduled admissions one week in advance.
The hospital calls all patients back for a check up one month after they have been finished their treatment.
Due to the various factors such a prompt and friendly service and much media coverage of this new facility the hospital are gaining an ever-increasing customer base. To maintain their level of service, the hospital has decided that fast information retrieval and processing is a must.
They realise it is time to computerise. Currently they are booking appointments using a hand written and over full diary. They are writing out invoices, by hand, on pre-printing stationary generated in MS-Word. Initially they would like to use a system that would automatically update a schedule for each room and the operating theatre and print out customer invoices and then record relevant information in a simplistic invoice list database, thus keeping a record of the income generated from patient appointments.
Additional information
After you initial investigation the following user requirement were highlighted: –
They would like to be able to select appointment times from a standard list of rooms and available time slots and for this information to be placed onto an appointment cards containing patient details. (For this example assume the booking will only record for one month at a time)
The user would like a system that would provide them with a designed invoice that they could view on screen and print out once a patient has completed their treatment.
When all relevant information has been placed onto the onscreen invoice they would like to be able to print this out for customers.
Once the invoice has been successfully printed they would like the system to proved a facility to abstract relevant information from the on screen invoice and place it in the invoice details database. Once information has been extracted the on screen invoice can be cleared ready for the next set of information.
GUIDANCE FOR STUDENTS IN THE COMPLETION OF TASKS
(Lecturer please insert guidance for students here. Please link the task to the five common assessment criteria overleaf)
Summary of Design and Development tasks
You have used the above scenario and implemented a solution for ?�Your Teeth our Smile using MS-Excel as a development platform. As part of your investigation into suitable platform for End User Development you must now build a solution to the above using MS-Access as your main development platform. You may wish to call upon other programs within the Ms-Office suite (e.g. Ms-Excel, Ms-Word) to add functionality to the overall system.
From the given scenario to develop the system you should complete the following tasks: –
• Design a system using MS-Access (and other Ms-office applications if required) that will perform the procedures as requested by the user.
• Provide facilities that will automate the user activities.
• Provide facilities that will allow the user to print out any part of the system automatically.
• Provide a brief user guide to your system
• Provide a user-friendly system.
Task Part 2)
Critically appraise the two systems that you have developed and comment on the advantages and disadvantages of using each end user development environment.
(1500 word)
Please hand in the following: –
1. A disk containing the system ( suitable labelled and safely attached to your assignment solution)
2. A report of the system you have designed including hard copy printouts of your workbook. (suitably bound)
3. A report for part 2
4. Evidence of system testing.
5. A user guides.
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
About Writedemy
We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.
How It Works
To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Are there Discounts?
All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.