Lessons

Resources

Full Course Outline
Video ZIP File (36 MB)
Skills Test Quiz - Under Construction
Certificate of Completion
Post-Class Survey

Questions?

Please feel free to post your questions or comments below. If you have questions about a specific lesson, please specify the lesson number and the time index in the lesson where the issue occurs. Thank you!

Subscribe for Updates

If you would like to be notified whenever changes are made to this page, new lessons are posted, or comments are made, click on the subscribe button.

Subscribe to ASP 304
Get notifications when this page is updated

Intro

In lesson ASP304, you will learn how to build a contact management system using ASP 3.0, including setting up a relational database with multiple related tables for customers and contacts. We will see how to display information from several tables on one ASP page, create a custom dlookup function to look up values, and design a contact form to track notes, dates, and customer interactions. This lesson uses Microsoft Access 2003 as the database and integrates with FrontPage 2003 on a Windows 2000 server.

Transcript

Today's class is all about contact management. We're going to learn how to create a relational database where we have multiple tables that are related to each other, and we'll see how to display data from multiple tables on the same ASP page.

We're going to have customers and contacts, with contacts for each customer. We're going to create our own dlookup function, which allows us to look up a value from a table. We will also see how we can create a contact form to keep track of all the notes every time we talk to a customer: what was said, the customer name, the contact date, and so on.

This is ASP304. It follows ASP303. I strongly recommend you take ASP301, 302, and 303 before this class. There is a lot of advanced stuff in today's class, and of course, all my beginner and intermediate ASP courses as well.

Today we're going to be talking about relational databases, which means multiple tables that are related to each other by some field. I cover relational databases in great detail in my Microsoft Access 201 class, so I recommend you take a look at that one first. It is not required, and I am going to go over the bare necessities in today's class. Going over Access 201 first will definitely give you a leg up on this class.

I'm going to be using standard ASP3.0 with a Windows 2000 server. I'm also going to be using FrontPage 2003 and Access 2003.

If you have any questions, you can post them in the student forum for this class. You can find a link to the forums at ASPLearningZone.com. If you are watching this class online, the student forum should appear next to your video window.

Quiz

Q1. What is the main topic of today's class?
A. Creating web graphics
B. Contact management and relational databases
C. Web security in ASP
D. E-commerce solutions

Q2. What is an example of a relational database setup discussed in the video?
A. A table for only customers
B. A table for only contacts
C. Customers and contacts, with contacts for each customer
D. Separate unrelated tables

Q3. What custom function will be created in today's class?
A. DSum
B. DLookup
C. DMax
D. DMin

Q4. What is the purpose of the contact form described in the class?
A. To register new users
B. To log web traffic data
C. To keep track of notes for each customer interaction
D. To display price lists

Q5. What prerequisite courses are recommended before taking this class?
A. ASP305 and 306
B. ASP301, 302, and 303
C. Web Design 101
D. HTML and JavaScript Basics

Q6. What software versions are being used in this class?
A. FrontPage 2000 and Access XP
B. ASP2.0, Windows XP, FrontPage 2000
C. ASP3.0, Windows 2000 Server, FrontPage 2003, Access 2003
D. Visual Studio 2019 and MySQL

Q7. Where can questions about the class be posted?
A. Instructor's email
B. Microsoft support forum
C. The student forum at ASPLearningZone.com
D. GitHub repositories

Q8. Why does the instructor recommend reviewing Access 201 class before this class?
A. It covers software installation steps
B. It explains advanced Visual Basic programming
C. It details relational database concepts more thoroughly
D. It focuses on server hosting

Answers: 1-B; 2-C; 3-B; 4-C; 5-B; 6-C; 7-C; 8-C

DISCLAIMER: Quiz questions are AI generated. If you find any that are wrong, don't make sense, or aren't related to the video topic at hand, then please post a comment and let me know. Thanks.

Summary

Today's video from ASP Learning Zone is focused on contact management and how to build a relational database using Active Server Pages (ASP). In this lesson, I am going to guide you through the process of setting up multiple tables that will be related to each other, and I'll show you how you can display information from these different tables together on a single ASP page.

We will work with tables for customers and for contacts, where each customer can have multiple associated contacts. I am also going to walk you through creating a custom Dlookup function, which is a tool you'll use to retrieve specific values from a table as needed. In addition, I will demonstrate how to design a contact form so you can log details of every interaction with a customer, including what was discussed, the customer's name, the date of contact, and other relevant information.

This class is ASP304 and is a continuation of ASP303. If you have not already done so, I highly recommend completing ASP301, 302, and 303 ahead of this one, since we will be covering advanced concepts. It will also help to be familiar with the material from my beginner and intermediate ASP courses.

We are going to focus on the concept of relational databases, which involves organizing data across multiple tables that connect through shared fields. I cover this topic in much greater depth in my Microsoft Access 201 class, so you may wish to review that as well. It is not strictly required, and I will explain the essential points needed for today's class, but studying Access 201 first will definitely make today's material easier to understand.

For this lesson I am using standard ASP 3.0 on a Windows 2000 server, and I am working with FrontPage 2003 along with Access 2003.

If any questions come up, you are welcome to use the student forum dedicated to this class. The forum link can be found at ASPLearningZone.com, and if you are watching this class online, you should see the forum located beside your video window.

You can find a complete video tutorial with step-by-step instructions on everything discussed here on my website at the link below. Live long and prosper, my friends.

Topic List

Creating a relational database with customers and contacts
Establishing relationships between multiple tables
Displaying data from multiple tables on a single ASP page
Building a custom dlookup function in ASP
Designing a contact form for customer interactions
Recording customer notes with related details
Storing and retrieving contact dates and information