4.5. Summary

So, you now know how to create an InfoPath form based on a database. InfoPath performs quite a bit of the work for you, one part of which is supplying the Data Connection Wizard.

The Data Connection Wizard walks you through locating the database you want to use, as well as the tables, queries, and fields necessary. If desired, more than one table or query can be used, and the wizard will help to create or modify relationships if necessary. Once the data source is specified, and the Finish button clicked, InfoPath creates a form that contains a header section, data section, and query section for you.

In this chapter, you also saw and experienced how easy it was to drag and drop the fields onto the form, and choose what kind of repeating sections you want to use. You then saw how to preview a form, query a database, and modify data from the database. Finally, you saw how to modify a data source.