Welcome to Online Course on Web Form Technology Using ASP with FrontPage 2000 and Access 2000! The course segments are arranged according to the ZL Time Management Matrix. This is a self paced course. You can work on one segment a day, or a week. 

This was a very successful workshop conducted by the trainers at
AIR Forum in Toronto June 2002. This course is a update to the successful workshop in 2001. If you want to use the previous workshop materials, please click here.

The updated course is Win2000 Pro based, which eliminated many of the problems with Windows 98SE and PWS. It uses IIS5 vs. PWS. The basic steps are still the same, but they are much easier and simpler to grapple with. The manual contains more information, better examples, ASP codes for password access site design and much more. 

We are only making part one of the manual available to you on this site. Please download the course manual and the published website example needed to teach you all the way to publishing your form (p39). If you find it useful and would like to obtain the full course manual including the ASP codes, we ask you to make a donation of $20 to OCAIR-a non-profit organization (instructions). Upon receiving your donation, we will release the entire manual plus the CD to you.
                                            
                                  OCAIR HOME     CONTACT THE TRAINERS
 
Table of New Course Contents

Course Objectives

1

Typographic Conventions

2

Technical Overview of Web-based Technology

2

The Web - The Next Generation

2

Why Using ASP?

2

What do I Need to Run ASP?

2

Overview of Technical Environment for a Web-based Form Design

3

Using the IIS Snap-In

6

FrontPage 2000

6

FrontPage Server Extensions

7

About the FrontPage MMC Snap-in

8

Knowing Your IIS Environment

10

Checking Out ASP Functions

11

What Is A Form?

14

Why online forms?

17

Getting Familiar With the Tools

17

Creating Your First Form

20

Creating Your Online Database

27

Creating/Defining Fields for the Database

29

Publish Your Form

35

Real-Time Query of Survey Database

40

Create a Password Protected Form to Control Accessibility

46

ADO Connection Object

50

ASP Objects

51

What Is An Object Anyway?

55

Planning a Data Flowchart

56

Using Data Verification to Establish Branching Conditions

59

Useful References and URLs

75

Web and Other Resources

78

References

79