Page 1 of 24PREVNEXT

Connect a form to a database

Form that's attached to database
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.

About this course

This course includes:

  • Three self-paced lessons and three practice sessions for hands-on experience.
  • A short test at the end of each lesson; tests are not scored.
  • A Quick Reference Card you can take away from the course.

Goals

After completing this course you will be able to:

  • Design a form that is connected to an Access database.
  • Give the form functionality by adding controls and applying formatting.
  • Select options for how data is submitted from the form to the database.
  • Use the form to add new records to the database and to query for existing records and modify them.

Before you begin

  • For this course, you should be familiar with relational database terminology.
  • To do the practice sessions, you need to have Access 2003 installed, from which you'll install the Northwind Sample Database. You must also have Microsoft Office InfoPath™ 2003 Service Pack 1 installed.

InfoPath or Access?

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 of each.

For a full discussion on this question, see Collect and store data using Access, InfoPath, or both.


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. To learn more, read this page fully, and then click Next.

Page 1 of 24PREVNEXT