The table below shows the medical records of a certain clinic
(a) Create a database called Medical Details.
(b) Design a table with appropriate data types in the design view called Patients.
(c) Enter the given data in the table.
(d) Assign a UGX symbol to the treatment fee field and change the date to medium format.
(e) Create a query to display all the details of patients who come from either Jinja or Busia. Save it as Eastern Patients.
(f) Create a query to display all the details that were not diagnosed with Malaria. Save it as No Malaria.
(g) Create a form from the table and save it as Main form
(h) If the Government pays 40% of the treatment fee for all patients, create a query to calculate the discounted fee. Put only Fname, DoB, Diagnosis, and Treatment Fee on the display. Save it as a Discounted fee.
(i) Create a report to display the information in the discounted fee query. Save it as a Discounted Report.
Create a tabular form from the discounted fee query showing all details and save it as a Patient’s form.
(j) Print your work.
#microsoft #microsoftaccess #database
More Video Lessons On Database Access By Kakuru Benard
Lesson 1: • Database Lesson 1
Lesson 2: • Database Lesson 2
Lesson 3: • Database Lesson 3
Lesson 4: • Database Lesson 4
Lesson 5: • Compressive Database L...
Lesson 6: • Database Lesson 6: How...
Lesson 7: • Database Lesson 7: How...
Lesson 8: • Everything You Need to...
Lesson 9: • Database Lesson 9 | Us...
Wakisha 2023: • Wakisha Sub ICT 2023 P...
UNEB 2023 Paper 2: • UNEB Sub ICT 2023 Pape...
UNEB 2023 Paper 3: • UNEB Sub ICT 2023 Pape...
UNEB 2023 Paper 1: • UNEB Sub ICT 2023 Pape...
Негізгі бет Database Lesson 1
Пікірлер: 28