A D V E R T I S E M E N T
Use Microsoft Office InfoPath 2003 to design a form that's connected to a
Microsoft Office Access 2003 database. Give form users the ability to add
records to the database by typing them into the form, and to use the form to
query the database for stored data that can be updated in the form.
Here's an effective use of InfoPath: Design a form that will help people work
with data in an existing Access database. Users of the form can then add new
records to the database by typing data into the form.
Other form controls enable users to query the database, modify records that
the query returns to the form, and submit the updated information back to the
database. This course tells you how to create a form that's connected to an
Access database and how to add functionality to the form
Since you can create robust forms in both Access and InfoPath, what are the
advantages of using one over the other to create your form?
Short answer: InfoPath's strength is in form creation and form usability in
the collection of data. Access's strength is in managing databases, particularly
data storage and reporting. Using the programs together combines the strengths