Dreamweaver Level 3

     

Private courses can be held at your site or one of our training venues, and can be customised to fit your requirements.

You can choose to have a private course based on an existing outline or you can choose the most applicable lessons from a number of different outlines and consolidate them into one course.

We can also write bespoke courses to fit your specific requirements, whether you require training on a standard application or a bespoke inhouse system.

Please contact us to discuss this further on 0191 377 8377.

Background to the internet and ASP

The internet, Electronic Mail, File Transfer
The World Wide Web
Dynamic content
Active Server Pages (ASP)
Coldfusion- an overview
Java Server Pages - an overview

Dreamweaver facilities

Live Data View
Defining an ASP site in Dreamweaver
Recordsets
Creating the connection
SQL (Standard Query Language)
How to define the Connection
DSN (Data Source Name)
DSN-less Connection

Defining the content of the recordset

Placing content onto the web page
Using the Repeat Region server behaviour
Sorting records
Paging through recordsets
Adding and hiding Previous and Next functionality
Adding a First and Last link
Live Objects: Previous/Next tools
Adding a Navigation bar and status
Removing a server behaviour

Searching for information

Master detail pages
Creating the master-detail page set
Live Objects: A master-detail page set
Searching a database
How a search page works
Applying Filters
Effecting a web Search
Use of Operators
Informing the user of how many results match

Formatting fields within a recordset

Editing a recordset and insertion of records
How to prevent duplicate records
Check new username server behaviour
Live objects: creating insert tools
Editing records
Populating a form from a recordset
Live objects: an update page
Deleting records
Performing the delete on one page
Confirming a delete request

Dynamic Elements

Creating droplists from recordsets
Adding multiple fields to a drop list
Creating a dynamic select list using a server behaviour
Creating HTML tags dynamically
Displaying the current date
Advanced and multiple field searching
Detecting an empty recordset
Preventing unwanted values in a drop list
Preventing a submission with ASP
Allowing the user to choose a sort order
Informing the user of the sorted order

Cookies and Session Variables

What is a Cookie and creating a Cookie
Extracting from a Cookie and detecting a Cookie Value
Creating a Session Variable
Storing and passing data with Session Variables
Detecting a Session variable
Using cookies/session variables in recordsets

Making the Connection

Connecting to a Database Without a Data SourceName
Defining the Site and Connecting to a Database
Connecting to a Database Using an OLE DB Connection
Creating a Connection Using the MapPath Method

Login Applications and Access Rights

Creating password-protected login application
Incorporating access Levels

Training Options

What's Included