Friday, March 9, 2007

Collecting data with Microsoft Office Access 2007 and InfoPath 2007

Did you know that you can use Microsoft Access to generate InfoPath forms which can be used with Outlook to gather data from people and automatically collate the responses to the email back into Access?

From the Access Help;

Microsoft Office Access 2007 makes it easy to gather data from people who are located anywhere on the globe, such as members of your sales team, survey participants, or contacts. Office Access 2007 works with Microsoft Office Outlook 2007 to help you to generate and send an e-mail message that includes a data entry form. When the recipients fill out the forms and send them back to you, the replies are processed according to your specifications. For example, if you choose to have the replies automatically processed, the contents of the form are added to the appropriate table in your database as soon as the reply reaches your inbox. This new feature, the Collect data through e-mail messages Wizard, can save you hours that you might have otherwise spent entering data on behalf of your users.

No comments:

About Me

Based on the NSW Central Coast near Sydney Australia I am passionate about technology including Office 365, SharePoint and K2 technologies. I have a particular interest in how simple solutions can have a big impact and challenging the 'way it is always done'. Speaking of simple, I am very focused on user experience and making sure the solutions we build get used...