Data Files needed for this Case Problem: OBrien.accdb (cont. from Tutorial 3) and Tests.bmp O'Brien Educational ServicesKaren O'Brien is using the OBrien database to track and analyze the business activity of her educational consulting company. To make her work easier, you'll create a form and report in the OBrien database. Complete the following-
1 . Open the OBrien database you created and worked with in Tutorials 1 through 3, and then click the Enable Content button next to the security warning, if necessary.
2. Create the form shown in Figure
3 Using the form you just created, navigate to the second record in the subform for the third main record, and then change the Assessment Complete field value to yes.
4. Use the Find command to move to the record for Samuel Glick, and then Chan the value in the Groups Only field to no.
5. Use the appropriate wildcard character to find all records with a Hire Date field value that begins with the month of March (3). Change the Hire Date field value for Alameda Sarracino (Tutor ID 51-7070) to 3/27/2016. Save and close the form.
6. Create the report shown in Figure 4-30.
7. Scroll to the bottom of the report; note that the page number might not be completely within the page border (the dotted vertical line). If necessary, select and move the box containing the text "Page 1 of 1" until the entire text is positioned to the left of the dotted vertical line marking the right page border.
8. Preview each page of the report, verifying that all the fields fit on the page. If necessary, return to Layout view and make changes so the report prints within the margins of the page and so that all field names and values are completely displayed.
9. Save the report, print its first page (only if asked by your instructor to do so), and then close the report.
10. Compact and repair the OBrien database, and then close it.