Dreamweaver Advanced 1 (ASP) - 2 days

This course is designed for those who are familiar with all basic Dreamweaver features such as site definition, the use of templates and the creation of websites using HTML and JavaScript. It focuses on the creation of dynamic web sites where web page content is linked to a database back-end. Although an overview of server side coding is provided, this course does not involve any programming, rather it shows how to use Dreamweaver's built-in features to generate ASP sites.

Getting started
	What is ASP Server-side vs. client-side scripts VBScript and JavaScript Requirements for running ASP Internet Information Server Personal Web Server Defining a new ASP site

Connections
	Databases and dynamic sites What is a database connection Creating a DSN Creating a DSNless connection Connection string parameters Dreamweaver's connection folder

Recordsets
	What is a recordset? Creating a recordset Simple and advanced modes What is SQL? The SELECT statement The ORDER BY clause

Display records
	Adding dynamic content to pages Creating Repeat Regions Using Recordset Paging Using Show Region Displaying the current page Using Live Data View

Filtering records
	The use of variables Setting default values Setting run-time values Naming variables Creating the WHERE clause Filtering numeric fields Filtering text fields Filtering date fields Using wildcards

Searches and results
	Creating search pages Designing and naming fields Buttons and search forms Get and Post methods Passing parameters across pages Go to Detail Page Go to Related Page

Writing to databases
	Insert Record Naming form fields Update Record Repopulating the update form Delete Record

Dynamic elements
	Making HTML attributes dynamic Dynamic text Dynamic images Dynamic links Dynamic drop-down menus Dynamic radio buttons

User authentication
	Creating a registration page Check User Name Creating a log in page Log In User Restrict Access to Page Log Out User Using levels in authentication