Note 9 for Web Publishing

Note 9 for Web Publishing II

Watch & Read:

Create a site for Dreamweaver

Follow the directions for Setting up a Database Connection using Dreamweaver.

For your homework, you will need to modify or create a new database.

Open up Access
Save the database on D drive using your userid as the name of the database (example: JStorslee.mdb)
Select Create Table in Design View

Create a Table with the following field name or create your own field names:

Table Setup (example)
Field Name Description of Field

PNumber for Part Number limit the field to 10 Text characters

Pname for Product Name limit the field to 30 Text characters

Pdescribe for Product Description limit the field to 500 Text characters

Pgraphic for file name of graphic limit the field to 15 Text characters

Price for Price of product limit the field to 8 Text characters

Table Setup (example)
Field Name	Description of Field
PNumber for Part Number	limit the field to 10 Text characters
Pname for Product Name	limit the field to 30 Text characters
Pdescribe for Product Description	limit the field to 500 Text characters
Pgraphic for file name of graphic	limit the field to 15 Text characters
Price for Price of product	limit the field to 8 Text characters

Review the following:

Dreamweaver Tutorials

Terms you need to Lookup:

ASP, PHP,

Databases: Access, MySQL, SQL Server

Homework:

You will need to create a dynamicly created page using ASP or PHP

You should be reading Chapters 22 -25 in your Deamweaver book.

Final Step:

Review in your mind everything we covered in class and remember to cover it again before you go to bed so your mind to process this information while you sleep.