Step 22: Now that we have built the IT Specialist survey form we need to enable it to transmit the data collected from the input fields directly into a database. We can accomplish this fairly easy by
first renaming the Web page or survey's file name extension from html to "asp". The latter extension stands for Active Server Pages (ASP), developed by Microsoft to handle dynamic Web content such as our survey.
The easiest way to rename a Web page in FrontPage is to use the Folders view located on the left side of the Navigation Pane as shown in Figure 13.
Step: 22a Change to the folders view by clicking on the Folder icon and a directory with individual files listings similar to Windows Explorer will appear.
Step 22b: Next, select the survey file, mcptechsurvey.html, by clicking on it in the right pane. Once the file is highlighted you can right click on it to bring up a shortcut menu. On the shortcut menu select the option to rename the
file. The file name will then be highlighted in blue whereby you can immediately overwrite the old name, including its extension. Change just the file extension from html to asp, then hit enter.
Figure 13 The FrontPage Navigation and Editing panes.
Step 23: After renaming the file, and while still in Folders view, double click on the newly renamed .asp file to open it. Alternatively, you can highlight the file, right click on it and select open from the shortcut menu. This puts you in Page
view automatically and opens the survey file.
Step: 24: We are now prepared to configure a connection from the survey form to a database. With the survey form open, right click anywhere within the form boundaries which are represented by dashed lines and a shortcut menu appears. Select the option Form
Properties and a dialog box similar to Figure 14 appears. Notice the default setting was to send to an HTML form. That was the setting we gave the save results option initially in Step 21.
