Independent Challenge 1 As the manager of Riverwalk, a multispecialty health clinic, you have created a database to manage the schedules that connect each healthcare provider with the nurses that provider needs to efficiently handle patient visits. In this exercise you will create a form that will help users find the objects (queries, forms, and reports) that they use to manage nurse and provider information. a. Start Access, open the IL_AC_6-3.accdb database from the location where you store your Data Files, then save it as IL_AC_6_Riverwalk. Enable content if prompted. b. Use the Blank Form tool to create a new, blank form. c. In Design View, add a tab control. d. Change the Name property for the Page1 tab to Nurse Info. e. Change the Name property for the Page 2 tab to Provider Info. f. On the Nurse Info tab, use the Command Button Wizard to add two command buttons, side by side in the middle of the page to do the following: - Open the NurseEntry form to show all of the records. Use the MS Access Form picture and a meaningful name of NurseEntryForm. - Preview the ScheduleByNurse report. Use the Preview picture and a meaningful name of PreviewScheduleByNurseReport. - Align the tops of the command buttons. Independent Challenge 1 (continued) g. On the Provider Info tab, use the Command Button Wizard to add two command buttons side by side in the middle of the page to do the following: - Open the ProviderEntry form to show all of the records. Use the MS Access Form picture and a meaningful name of ProviderEntryForm. - Preview the Schedule report. Use the Preview picture and a meaningful name of PreviewScheduleReport. - Align the tops of the command buttons. h. Save the form with the name Switchboard then switch to Form view. Test all four command buttons then close all open objects. i. Open the Switchboard form in Form Design View. j. Open the Property Sheet for the Switchboard form and change the following properties on the Format tab of the Property Sheet: Record Selectors: No Navigation Buttons: No Scroll Bars: Neither Control Box: No Min Max Buttons: None k. Save the Switchboard form then view it in Form View to review the property changes, as shown in FGURE 6-34. Close the Switchboard form, compact and close the IL_AC_6_SupportDesk database, then exit Access