Lab 1: Editing Forms and Working with Form Data in InfoPath 2003
This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.
Summary: Learn how to complete a form, add new sections to the form, and merge and export data and signing data with a digital certificate. (4 printed pages)
Updated August 2007
Applies to: Microsoft Office InfoPath 2003
Download the odc_INF03_Labs.exe sample file.
Each member of the IT department at Contoso Corporation should be familiar with the editing capabilities of Microsoft Office InfoPath 2003. In particular, they must know the fundamentals of filling out forms, including how to merge data from several forms into a single form, how to export data to a Microsoft Office Excel 2003 worksheet, and how to sign the form with a digital signature.
In the following exercises, you fill out a simple sales report form, merge data from that form with a sales report form, and send data to Excel.
Exercise 1: Filling Out Form Fields
To open a form
Start InfoPath 2003.
Under Open a form in the Fill Out a Form dialog box, click Open.
In the Open dialog box, locate the folder that you installed the training files in, and double-click the Lab 1 folder.
Select Lab1Template.xsn, and then click Open. The Contoso sales report form opens in InfoPath. After you have opened the form, you can start filling it out.
To fill out the form
In the Sales Representative field, type your name, and then press TAB to move to the next field.
Fill out the Period, E-mail Address, and Department fields.
In the Customer Name field, type a customer name.
In the Name, Price, and Units Sold fields, type sample text. InfoPath fills in the Total box for you.
To add another row to the table, press CTRL+ENTER or click the Insert item label directly underneath the table.
To add an optional Notes section into which you can type comments about the customer, click Click here to insert notes.
When you move your pointer over certain controls in a form, such as repeating sections or optional sections, a shortcut menu button appears in the upper-left corner of the control. If you click this button, you can gain access to menu commands that let you work with the controls. In the next part, you use this button to add an additional customer section to the form.
To insert an additional customer section
Move your pointer over the Customer Name label, and then click the shortcut menu button that appears immediately to the left of the label.
On the shortcut menu, click Insert customer above. An empty customer section appears directly above the one you just filled out.
Exercise 2: Merge Data into the Form
Imagine that you have another sales report form. In this exercise, you merge data from that form with the sales report form you just created.
To merge forms into your form
With the form from Exercise 1 still open, on the File menu, click Merge Forms.
In the Merge Forms dialog box, locate and open Lab1Report.xml.
You find this file in the Lab 1 folder, in the directory where you installed your training files.
To merge the data in the Lab1Report.xml form with your latest form, click Merge.
Exercise 3: Export Data to Excel
If you want to view the data from one or more forms in a worksheet, you can use the Export to Excel feature in InfoPath to send data directly to Excel. In Excel, you can filter, sort, and analyze the data. You can export data from one form at a time or from several forms at once. In this exercise, we export data from a single form.
To export data to Excel
With the form from Exercise 1 still open, point to Export To on the File menu, and then click Microsoft Office Excel.
On the first page of the Export to Excel Wizard, click Next.
On the second page of the wizard, click Form fields and this table or list.
Because you want to analyze sales data, click items in the list.
Do one of the following:
To export the data from the sales report form, click Finish.
To further customize export options, or to export data from multiple forms, follow the remaining steps in the wizard.
Exercise 4: Add a Digital Signature to Part of the Form
When filling out a form, you can add a digital signature to part or all of the form, depending on the form's design. You can digitally sign forms only if they are designed to accept digital signatures. You can also remove or review digital signatures.
Once signed, the signed form or part of the form that is signed cannot be altered without invalidating the signature.
To digitally sign part of the form
With the form from Exercise 1 still open, click the Click here to sign this section commandat the bottom of the form.
The Digital Signature Wizard opens.
In the Select the certificate that you want to use to sign the form list, click the certificate you want to use as your digital signature, and then click Next.
In the Comment box, type a comment to save with the signature, and then click Finish.
Closely review what you are signing, including the image of the form content, the comment, and the information associated with the signature, and then select the I have verified this content before signing check box.
Move your pointer over the fields in the customer name section. Because you digitally signed this part of the form, a digital signature icon appears in the upper-right corner of each field in the section.