125% T E View Zoom Add Page Insert Table Chart Text Shape Media Comment Collaborate Format Document Pages Section Question 8 for MS Access Quiz (Q Background Partial credit is possible so do all of the work/steps that you can. Total Points: 28 Headers & Footers Question/Task Point Hide on first page of section Value Match previous section a Open the "Question 8 base file" .accdb file and save a new copy with your last name 3 appended to the file name Page Numbering b Enable the content security warning 0 Format C Open the PurchaseOrders table and modify the row height to 20 3 1 , 2 , 3 d Go to the design view in the PurchaseOrder table and set all fields to "required" w Numbering Save the table (click yes for the integrity rules) and close the table . Continue from previous section e Open the EmployeeInformation table in Design View. Update the field properties in this 6 Start at: 1 9 table to reflect the information below. Note: You will need to add the Hire Date (short text, no description) to the field list before updating the properties: Create a new section Field Name Field Size Format Required EmployeeID 10 Yes Sections allow you to start a new header and footer, page numbering, or page LastName Yes background. FirstName Yes AssignedDepartment 20 Yes ManagerName No DeskPhone 10 Yes Email Yes HireDate Medium Date No Create an input mask for the DeskPhone field in the format using the default format, an 5 asterisk (*) for the placeholder character, and select "without the symbols in the mask, like this" radio button. Finish and save the table. g Open the EmployeeInformation table in Datasheet view. Input the information from 6 the table below. Save the table EmployeeID . LastName . FirstName . AssignedDep . ManagerNan . DeskPhone . Email . Hire Date . 750003456 Smith John Engineering Bamberg (555) 234-7788 john.smith@company.com 03/05/1990 750003457 Jones Marcia Engineering Bamberg (555) 234-8947 marcia.jones@company.com 01/01/1 50003555 Li June Engineering Bamberg (555) 234-0000 june.li@company.com 02/01/1999 750003244 Mason Lewis Engineering Bamberg (555) 234-3489 lewis.mason@compny.com 06/15/1980Pages File Edit Insert Format Arrange View Share Window Help 67% Tue 12:34 PM Q OE Question 8 (2) ... 125% E View Zoom Add Page Insert Table Chart Text Shape Media Comment Collaborate Format Document Pages AssignedDepartment 20 Yes Section Get home ManagerName No Background DeskPhone 10 Yes Get connecte Email Yes Receive answ HireDate Medium Date No Headers & Footers Hide on first page of section 1. Ask your qu Match previous section f Create an input mask for the DeskPhone field in the format using the default format, an 5 asterisk (*) for the placeholder character, and select "without the symbols in the mask, BIU like this" radio button. Finish and save the table. Page Numbering g Open the EmployeeInformation table in Datasheet view. Input the information from 6 the table below. Save the table. Format View 1 , 2 , 3 C Numbering EmployeelD . LastName . FirstName . AssignedDep . ManagerNan . DeskPhone . Email Hire Date . 750003456 Smith John Engineering Bamberg (555) 234-7788 john.smith@company.com 03/05/1990 . Continue from previous section 750003457 Jones Marcia Engineering Bamberg (555) 234-8947 marcia.jones@company.com 01/01/1985 50003555 Li June Engineering Bamberg (555) 234-0000 june.li@company.com 02/01/1999 Start at: 1 750003244 Mason Lewis Engineering Bamberg (555) 234-3489 lewis.mason@compny.com 06/15/1980 Create a new section Sections allow you to start a new header and footer, page numbering, or page background. h Save the file and upload onto HuskyCT for problem 6. 2 Drag and NOV 8 city125% T E View Zoom Add Page Insert Table Chart Text Shape Media Comment Collaborate Format Document Pages Section Background Question 9 for MS Access Quiz (Quiz #4) Headers & Footers Total 28 points Hide on first page of section Partial credit is possible - do all of the work that you can Match previous section Step Question/Task Point Value Page Numbering a Open the "Question 9 base file" .accdb file and save a new copy with your last name 3 appended to the file name Format b Enable the content security warning 0 1 , 2 , 3 Numbering C Create a query using the Members and Race Results table 6 . Continue from previous section d Add the following fields to the query: MemberID, City, State, Division, Age Group, and Start at: 1 9 Place e Create a query that shows the count of the runners per city. 6 Show only the City and the number of runners. Save query as "CountofRunners" Create a new section f Create a query that shows the count of the female "F" division runners per city. 5 Sections allow you to start a new header Show only the City and the number of female runners (e.g. count of MemberID). Save and footer, page numbering, or page query as "CountofFemaleRunners" background. G Save the file and upload onto HuskyCT for problem 9. 2 Total possible points: 30