This paper explains how to use Microsoft Outlook 2000, Microsoft Access 2000, and Microsoft Exchange Server 5.5 in a sample application called the Student Attendance Form . This form collects information in Outlook and stores it in an Access database for later retrieval. You can analyze the information in Access-based reports and queries or display the information in forms. The forms can then remain in either Access or Outlook.
Access makes it easy to track information in e-mail or in forms.
You type information into an Outlook form that can be sent to an Access database for analysis and later retrieval. Information collected from Outlook forms and stored in an Access database can be used to analyze the data in simple or complex reports. If users are unfamiliar with Access, they can review information in an Outlook Form. The Student Attendance Form demonstrates one method for collecting student attendance information for a school. The form includes a drop-down list box that, when selected, displays the homeroom information collected from the database.