Advanced Active Server Pages

Advanced Active Server Pages

Full Description

Advanced Active Server Pages Active Server Pages is the latest server-based technology from Microsoft. It makes it easy to create dynamic, interactive pages for your World Wide Web site or corporate Intranet. In this course you will build a dynamic, database driven website from the ground up. The project will involve building a complete classified ads site involving secure logins, ad entry and management, as well as ad searches and display. With the knowledge gained, students will be able to program almost database intensive website imagined.

Outcomes:

Outcomes A. Create an efficient Access database B. Create a DSN-less or DSN connection to an Access database C. Insert, Update, and Delete records in a database using Access and Structured Query Language (SQL). D. Add form data to an Access database E. Open ADO recordsets and display in tables. F. Troubleshoot SQL statements G. Fill a list box with a recordset. H. Search a database a display the results I. Secure your site with a login procedure. J. Understand recordset parameters K. Clean SQL statements and deal with Null values L. Put all this valuable knowledge to good use. M. Use Include Files to improve efficiency on the site. N. Use Session variables to track users.

Assessment:

Assessment During the course, students will be constructing a completely database driven website. The site itself will be checked and graded based on functionality and absence of errors.

Week 1 Activities
We will spend most of our time in Microsoft Access. Students will construct the database used in the project.

Week 2 Activities
Students will create the pages needed to complete the project and create and test the database connection on the site. This is when each student will write his or her first SQL statement.

Week 3 Activities
Time to set up the interface that allows users to input ads into the system. This will also involve creating a login system to track users. This section will take 2 weeks to finish.

Week 4 Activities
Students will complete the seller’s interface and login process. At this point, users will be able to add, edit, and delete ads after logging in to the site.

Week 5 Activities
In this week students will begin to create how prospective buyers will search for and view ads. Three areas will be involved. A search page, a list page, and a page to display individual ads.

Week 6 Activities
In week six, students will complete the site and ad finishing touches. At this point they will beta test and debug any errors encountered.

Contact Hours: 30