I need a website that is linked to an access database created for a fictitious medical office called Aspire Medical Center (AMC). AMC was a GP medical facility that started with three doctors, but, over the last 10 years, the center has grown and now offers specialized services in obstetrics-gynecology, pediatrics, cardiology, ophthalmology, and dermatology. With the most recent addition of the ophthalmology and dermatology departments, the original staff size of 8 has almost tripled and is projected to quadruple within two years.
AMC offers a variety of medical services in each field that includes consultations, evaluations, and in or outpatient surgery. Due to the many services provided, the Center currently has three different schedules for consultations and evaluations, outpatient surgery, and inpatient surgery that do not use the same platform and cannot be synced. During the scheduling process of a new or current patient, the receptionist must schedule the patient, book an exam or surgery room, and send the patient’s medical records to the right location via courier. With a high volume of appointments, the receptionist only has a few minutes to complete the scheduling process.
Despite AMC’s rapid growth, they do not have a singular database that reflects immediate changes and the user is unable to see a physician’s entire schedule. The inefficient process causes a substantial amount of loss for AMC in terms of maximum use of time and the substantial amount of money spent on courier fees.
The database will allow users to review all of the schedules simultaneously and schedule patients quickly. However, to increase efficiency, a web page can be created to allow new and existing patients to view and book available consultation times.
Once a time slot fills up, then it will immediately be known as unavailable to everybody else. This dramatically reduces the amount double scheduling in the system and dramatically decreases customer dissatisfaction. To make it even easier on everyone involved, we need to make a column for each department and within that department, will tell what doctors are available and the times available. For example, there will be one for obstetrics-gynecology, pediatrics, cardiology, ophthalmology, and dermatology. The doctors will be listed, along with the times that are available. For example, if Dr. John Doe of the pediatrics department works Monday through Thursday from 7AM to 5PM, then that will be displayed in the text. The times of appointments available will be mentioned when clicking on him for appointment. That will be the case for pretty much every doctor who works at AMC. The only difference between Dr. John Doe and the other doctors would be the days and times they work. Other than that, it will be practically in the same format.
All the doctor/patient data can be dummy data but it should have at least 15-20 doctors to choose from and an existing patient list of 100-150. The calendar should be loaded with existing schedules so that during the ‘test’ of the database, we can select times and be blocked from selecting times due to an already booked appointment. If a report or two can be generated that can show upcoming weekly schedules for each doctor, that would be great. Please let me know if you have any questions.
Try it now!
How it works?
Follow these simple steps to get your paper done
Place your order
Fill in the order form and provide all details of your assignment.
Proceed with the payment
Choose the payment system that suits you most.
Receive the final file
Once your paper is ready, we will email it to you.
EssayBrill has stood as the world’s leading custom essay writing services providers. Once you enter all the details in the order form under the place order button, the rest is up to us.
At EssayBrill, we prioritize on all aspects that bring about a good grade such as impeccable grammar, proper structure, zero-plagiarism and conformance to guidelines. Our experienced team of writers will help you completed your essays and other assignments.
Admission and Business Papers
Be assured that you’ll definitely get accepted to the Master’s level program at any university once you enter all the details in the order form. We won’t leave you here; we will also help you secure a good position in your aspired workplace by creating an outstanding resume or portfolio once you place an order.
Editing and Proofreading
Our skilled editing and writing team will help you restructure you paper, paraphrase, correct grammar and replace plagiarized sections on your paper just on time. The service is geared toward eliminating any mistakes and rather enhancing better quality.
We have writers in almost all fields including the most technical fields. You don’t have to worry about the complexity of your paper. Simply enter as much details as possible in the place order section.