Survey 1

This lesson will continue to introduce you to the FrontPage Database Results Wizard, (DRW). After following these basic steps, you will create a database driven online survey with a built in password protected editor.

Note: If you have not completed the GUESTBOOK lesson then please make sure you do that lesson first.

! See this lesson in action....(select a lesson below)

• Take the online survey
  • basic online survey
  • uses dropdown list and option boxes
• View the survey results in a table
  • presents each record in a table
  • tables are one choice for reports
• Sort the survey results by class period
  • user must enter the class period
  • user needs to know the EXACT way to enter a class period
• Sort using a  DROPDOWN box! (hey, this is COOL Mr. C.)
  • user can select class period from a dropdown list
  • more difficult due to web form sends data to database results wizard
  • web form needs to use SQL DISTINCT query
• Sort using MULTIPLE QUERIES
  • combine a sort query with a dropdown query
  • demonstrate your learning

! Follow these steps to make your own online survey.