Lessons

Resources

Full Course Outline
Video ZIP File (34 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 303
Get notifications when this page is updated

Intro

In lesson ASP 303, we will learn how to add log-on security to our customer website using standard ASP 3.0, requiring users to enter a username and password to access and modify customer data. We will also add a search form to look up customers by various fields, work with drop-down boxes for selecting values like state, and preset their values on edit forms. Additionally, I will show you how to create a menu bar header for site navigation and a system message display across the top of your pages. We will be working with Microsoft Access 2003 as the database backend.

Transcript

Welcome to ASP303, brought to you by ASPLearningZone.com. I am your instructor, Richard Rost.

In this lesson, we are going to learn about log-on security. We will actually make it so that people have to log on to our customer website with a username and password.

We have been building that customer website where we can list our customers, add a customer, delete a customer, and edit the information in the last couple of lessons.

As of right now, anyone can log on and change things, so we want to add some username and password security to that.

Then, we are going to add a search form so you can search for customers by last name, first name, how long they have been a customer, and so on.

Next, we are going to learn how to work with drop-down boxes so we can pick a state, for example, from a list of states.

I will show you how you can use your ASP code to automatically show what state was picked when we go to edit the customer to preset the drop-down box value.

We will learn how to create a menu bar header with some different options in there. That menu bar will be across the top of all of our pages.

We will also learn how to create a system message that will show up across the top of the page as well.

This class follows ASP 302. I strongly recommend you take 301 and 302 before this class, and, of course, all my beginner and intermediate classes as well.

If you are serious about learning database development, I recommend my Microsoft Access 101 class as well.

I will be using standard ASP 3.0 on a Windows 2000 server. I will be using FrontPage 2003 as my webpage editor of choice. Of course, you can use any editor you would like. I will be connecting to a Microsoft Access 2003 database.

If you have any questions about today's class, please feel free to post them in the student forums. You will find a link to the forums on my website at ASPLearningZone.com. You should also see a link to the student forums appear if you are watching this course online.

Quiz

Q1. What is the main security feature being added in this lesson?
A. Firewall protection
B. Log-on with username and password
C. Email verification
D. Two-factor authentication

Q2. What functionality has already been implemented in the customer website prior to this lesson?
A. Importing customers from Excel
B. Listing, adding, deleting, and editing customers
C. Generating sales reports
D. Sending automated emails to customers

Q3. Which feature will allow users to find customers based on criteria like last name or how long they have been a customer?
A. Log-in form
B. Search form
C. Admin panel
D. Data export tool

Q4. Why is it important to preset the drop-down value when editing a customer?
A. It saves bandwidth
B. It helps remember previously visited pages
C. It shows the previously selected state so the user can see and change it if needed
D. It encrypts the state value for security

Q5. What is being added to provide navigation across all the web pages?
A. Footer disclaimer
B. Print button
C. Menu bar header
D. Animated banner

Q6. What type of message will be displayed across the top of the page as learned in this lesson?
A. Promotional advertisement
B. Debugging information
C. System message
D. Username greeting

Q7. Which software and technology combination is primarily used in the course?
A. ASP.NET and SQL Server
B. PHP and MySQL
C. ASP 3.0, Microsoft Access 2003, and FrontPage 2003
D. JavaScript and Oracle

Q8. What prior knowledge is strongly recommended before taking ASP 303?
A. HTML and CSS basics
B. Only ASP 301
C. ASP 301, ASP 302, and beginner to intermediate classes
D. Visual Basic programming

Q9. Where can students go for help or to ask questions about the class?
A. The live chat support
B. Student forums at ASPLearningZone.com
C. Instructor's direct email only
D. Social media groups

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

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 focuses on adding log-on security to our customer website. I am going to show you how to require users to enter a username and password before they can access or change any information on the site. Up to this point, anyone who visits the site is able to view and modify customer data, so introducing this kind of security is important to protect your information.

We have been working on a customer website where you can list, add, delete, and edit customer records. Now, it's time to tighten things up with authentication, and then move forward to some additional features.

Next, I will teach you how to build a search form. This form will let you look up customers by last name, first name, or by how long they have been a customer, plus other options. Having a search feature will make it much easier to manage and find your customers quickly.

We will also cover how to use drop-down boxes on your forms, such as selecting a state from a list. I'll explain how to get your ASP code to automatically display the correct state that was already selected when you edit a customer's details. That way, the drop-down box will show the right value by default.

Another topic for this lesson is creating a menu bar header. This menu will appear across the top of all your webpages, giving you a consistent place for navigation options. Along with the menu bar, I'll also demonstrate how to add a system message that appears across the top of the page. This can be useful for displaying notifications or important information to your users.

Please note that this class follows up on ASP 302, so make sure you have completed ASP 301 and 302, as well as my beginner and intermediate courses, so you have the background knowledge needed.

If you are serious about database development, I also recommend starting with my Microsoft Access 101 class.

For this course, I am using ASP 3.0 running on a Windows 2000 server, with FrontPage 2003 as my webpage editor. You are welcome to use a different editor if you prefer. The website will be connected to a Microsoft Access 2003 database.

If you have questions about this lesson, please use the student forums on my website. You can find a link to the forums at ASPLearningZone.com.

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

Adding log-on security with username and password
Restricting website access to authorized users
Creating a customer search form
Searching customers by last name, first name, and duration
Implementing drop-down boxes for selecting states
Presetting drop-down box values when editing customers
Creating a menu bar header with navigation options
Displaying a system message across the top of the page