Using Access for any other suitable database management softwarel, set up a single table database to store the PATIENT records using the fields given previously:

FirstName, FamilyName, DateOfAdmission, Consultant, WardNumber. Bed Number. Choose a suitable data type for each field. Include validation checks to make sure that the ward number has whole number values from 1 to 10, and that the bed number has whole number values from 1 to 8. Enter the following data in the PATIENT table: Winnie Sing, 12/10/2022, Mr Smith, 6, 8 Steve Chow, 23/10/2022, Miss Abebe, 6, 3 Chin Wee, 30/10/2022, Mr Jones, 7, 1 Min Hoo, 1/11/2022, Mr Smith, 6, 1 Peter Patel, 12/11/2022. Mr Jones. 7, B Sue Sands, 19/11/2022, Miss Abebe, 6, 2 Farouk Khan, 22/11/2022, Mr Jones, 7, 4 Ahmad Teo 22/11/2022, Mr Jones, 7, 2 You may want to look at the instructions on how to set up the Cub Scout database later in this chapter if you have not set up a database before.