How to Collect Data in Access 2007

Launch the Microsoft Access 2007 program and open the database file you want to use to collect data.

Right-click on the database form you want to use to collect information from the Navigation Pane on the left side of the window. Select the "Collect and Update Data via Email" option from the contextual menu that appears.

Press "Next" when the pop-up window opens.

Choose the radio button next to "HTML Form" and press "Next."

Choose whether you want to only accept new data or if you want users to be able to update existing records as well. Click "Next" when you are ready to continue.

Highlight the names of the fields you want to include in the HTML form, press the right arrow button and then click "Next" again.

Enter the subject and introduction you want to attach to your HTML form and press "Next" again.

Click "Create" to save the form's settings. Microsoft Outlook will automatically launch, and you will be able to send the form to the email addresses of your choice.

Source.