Computer scienec projet 7

W_CH07_EXPV2_H1_Instructions.docx

Office 2013 – myitlab:grader – Instructions Exploring Volume 2 - Homework 1

Travel Reimbursement Form

Project Description: The company you work for has a travel reimbursement form that all employees must print, fill in, and then submit via interoffice mail. You are responsible for converting that form so that it can be completed online and e-mailed to the accounting office.

Instructions: For the purpose of grading the project you are required to perform the following tasks: Step Instructions Points Possible 1 Start Word. Download and open the Word file named exploring_w07_grader_h1_Travel.docx. Save the document as exploring_w07_grader_h1_Travel_Solution. 0 2 Customize the Ribbon to display the DEVELOPER tab, if necessary. Begin to record a macro. Name the macro TextControl. Assign the keyboard combination CTRL+L to the macro. Close the dialog box. While recording the macro, be sure to follow the steps exactly as specified. Do not switch between windows between steps. 2 3 In recording mode, click the DEVELOPER tab, and then click Rich Text Content Control. Click Properties and then select the Content control cannot be deleted option. Close the Content Control Properties dialog box, and then stop recording the macro. Switch to Design Mode and delete the text control inserted while recording the macro. Turn off Design Mode. 6 4 Display the macro in the Visual Basic Editor window. Delete any empty comment lines or blank lines in the code, and then copy the entire TextControl macro from the Sub state to the End Sub statement inclusive. Close the VB Editor. Paste the code into the first line of Page 2 of the Word document. 2 5 In the Word document, use the TextControl macro to replace the asterisk to the right of the : (colon) following Name with a text control. 9 6 Replace the asterisk to the right of Request Date with a Date Picker control. 5 7 In the second column of the Shuttle row, insert a legacy text form field immediately after the : (colon) in To Airport:. Set the field type to number. 7 8 Assign a bookmark named ToAirport to the field created for the shuttle expense to the airport. 6 9 Edit the property for the Miles driven field in the Personal Car row to display Enter number of miles driven as the Help text. 6 10 In the Totals column of the Shuttle row, insert a legacy text form field that adds the expenses for the shuttle to the airport and from the airport. Use the form field bookmark names ToAirport and FromAirport to refer to the fields. 9 11 Use the TextControl macro to insert a text control in the first column, first row under Other Expenses. 8 12 In the last cell of the table, insert a legacy text form field using the formula =SUM(D2:D16) to calculate the total expenses. Format the field to display the results as currency. 12 13 On the blank line before page break on Page 1, insert a Microsoft Office Signature Line. Enter Employee Signature as the suggested signer and accept all other defaults. 12 14 Restrict formatting to a selection of styles setting the styles to None but do not remove them from the document. Restrict the type of editing to filling in forms. Enforce the protection without setting passwords. 16 15 Save and close the document. Exit Word. Submit the document as directed. 0 Total Points 100

Updated: 08/14/2013 1 W_CH07_EXPV2_H1_Instructions.docx