THE LZ’S TIME MANAGEMENT MATRIX

Welcome to Online Course on Web Form Technology Using ASP with FrontPage 2000 and Access 2000! The course segments are arranged according to the LZ Time Management Matrix. This is a self paced course. You can work on one segment a day, or a week. You can also watch a movie () if you want to see how a particular section is done step-by-step. You'll need to have Windows Media Player installed to play the movie. Enjoy!

OCAIR HOME FAQ CONTACT THE TRAINERS

ABOUT THE LZ’S TIME MANAGEMENT MATRIX

LZ'S TIME MANAGEMENT MATRIX	Manual Intensity		Hands-on Intensity
Overview of Course Materials and Logistics: Hands-on, will focus more on "How-to" instead of "Why"
Technical Overview of Web Based Technology
System Requirements
Overview of Technical Environment for a Web Based Form Project
Segment One: Introduction of FrontPage 2000 and FrontPage Extensions
Segment Two: Making Your PC a Web Server using PWS
Segment Three: Check ASP
Segment Four: Designing Your First Form Create a new web Create Form
Segment Five: Managing Form Database Create Database Clean Database Define Form Fields
Segment Six: Publish Your Form Create Database Connection Publish Web Check Web Connection Bonus: More Form (1) Bonus: More Form (2) Bonus: More Form (3) Bonus: More Form (4)
Segment Seven: On-line Querying of Database
Glossary
Web Resources and References

DOWNLOAD THE ENTIRE MANUAL (The sequence is different from above).

A Word On This Unusual Matrix (LZ’S TIME MANAGEMENT MATRIX)

This is a graphical measure of the amount of time spent on learning the manual or doing hands-on practice. For either learning the manual or hands-on, there are two boxes representing three levels of intensity: all blank equals low, one blank and one gray equals medium, and all gray equals intense. For example, for Segment Two, learning the manual and hands-on are about equal.

Web and Other Resources:

To Learn More about PWS

Getting Started with Microsoft Personal Web Server, available as C:\Program Files\WEBSVR\DOCS\GETSTART.HTM. As the document title suggests, this is a good place to start to get familiar with your PWS.
Microsoft PWS 4.0 Release Notes, available as C:\WINDOWS\HELP\pws\htm\core\iisread.htm. This document contains information abut new features, important product considerations and installation instructions
Personal Web Server Administration, available as C:\Program Files\WEBSVR\DOCS\ADMIN.HTM. This document provides information about administering and configuring your Web site in PWS.
FP98: How to Upgrade to the Microsoft Personal Web Server 4.0 available as http://support.microsoft.com/support/kb/articles/q182/8/02.asp (Article ID Q182802). If you installed FP 98 or earlier version before, this is a must to read regarding the upgrading and tweaking.

PWS Trouble Shooting

For error message: PWS Cannot Bind to Port 80, refer to http://support.microsoft.com/support/kb/articles/q149/8/43.asp.
For error message: An Unknown Error Occurred While Making MTS Specific Changes to the System Registry, refer to http://support.microsoft.com/support/kb/articles/q246/0/81.asp

To Learn More about FP Server Extensions

1. FP2000: FrontPage 2000 Server Extensions Service Release 1.1 available as http://support.microsoft.com/support/kb/articles/q265/1/34.asp. It's a good idea to keep your software updated with the latest version of service release.

2. Installing the FrontPage Server Extensions on Windows, available as http://officeupdate.microsoft.com/frontpage/wpp/serk/inwindow.htm

3. Updated FrontPage 2000 Server Extensions Resource Kit, for downloading information, check http://officeupdate.microsoft.com/2000/articles/Fpserk.htm

4. FrontPage Features That Require the FrontPage Server Extensions, available as http://officeupdate.microsoft.com/2000/articles/FPSEreqs.htm

To Learn More about FP2000 and ASP

1. ASP Web Wizard 2000 for Databases: http://support.microsoft.com/support/kb/articles/q206/0/19.asp

2. Setting Up Your Database Connection Using ODBC http://support.microsoft.com/support/frontpage/fp2000/aspweb/page00003.asp

3. Retrieve Information from a Database with a Form http://support.microsoft.com/support/frontpage/fp2000/aspweb/page00004.asp

4. Setting Up Your Database Connection Using ADO http://support.microsoft.com/support/frontpage/fp2000/aspweb/page00005.asp

5. FrontPage 2000 Creates Access 2000 Database Files http://support.microsoft.com/support/kb/articles/q233/4/06.asp

6. Use a From to Post Information to a Database http://support.microsoft.com/support/frontpage/fp2000/aspweb/page00006.asp

7. Other Advanced Database Examples http://support.microsoft.com/support/frontpage/fp2000/aspweb/page00008.asp

8. Create an Active Hyperlink Using a Database Field http://support.microsoft.com/support/frontpage/fp2000/aspweb/page00009.asp

9. Display an Image Using Data from a Database http://support.microsoft.com/support/frontpage/fp2000/aspweb/page00010.asp

10. How to Create a Registration Web http://support.microsoft.com/support/kb/articles/q207/2/88.asp

11. How to Set Up a Form to Post Results by E-mail http://support.microsoft.com/support/kb/articles/q196/4/61.asp

12. How to Update Information in a Microsoft Access Database Using FrontPage 2000 and ASP http://support.microsoft.com/support/kb/articles/q240/0/90.asp

13. How to Delete a Record from Microsoft Access 2000 http://support.microsoft.com/support/kb/articles/q240/2/00.asp

14. How to Submit Form Results to Multiple Files, People http://support.microsoft.com/support/kb/articles/q205/7/56.asp

15. How to Return a List of Records as Hyperlinks Using ASP http://support.microsoft.com/support/kb/articles/q205/9/80.asp

ASP Trouble Shooting

1. Error 80004005, check http://support.microsoft.com/support/kb/articles/q183/0/60.asp

2. Error Message "Cannot update the database", check http://support.microsoft.com/support/kb/articles/q265/1/91.asp

3. Error message "Operation Must Use an Updateable Query", check http://support.microsoft.com/support/kb/articles/q175/1/68.asp

4. Error message "Database Connection Undefined After Publishing Web" http://support.microsoft.com/support/kb/articles/q204/1/52.asp

5. Error message "'http:<Web Site>' Isn't Accessible", check http://support.microsoft.com/support/kb/articles/q264/7/49.asp

6. Error message "The folder '/Cgi-bin' Is Marked Executable", check http://support.microsoft.com/support/kb/articles/q215/3/65.asp

References:

Callahan E. (1999) Microsoft Access2000 Visual Basic for Applications Fundamentals. Microsoft Press. Redmond, WA.

Francis, B., Kauffman, J., Llibre, J.T., Sussman, D., and Ullman, Chris. (1998). Beginning Active Server Pages 2.0.Birmingham, UK: Wrox Press Ltd., Arden House.

Mathews, M. S., and Poulsen, E. B. (1999). FrontPage 2000: The Complete Reference. Berkley, CA: Osborne/McGraw Hill.

Nelson, S., Gerend J. (2001). Effective Executive's Guide to FrontPage Web Sites: Seven Steps for Designing, Building, and Maintaining Front Page 2000 Web Sites. Redmond Technology. Inc.

Wagner L., Callihan S. (1999) Create FrontPage 2000 Web Pages in a Weekend. Prima Tech. Rocklin, CA.