|
Tutorial 7:
- Objectives:
Use source control to manage access to web site
keep two users from saving at once thus losing data, keep another user from
saving over your work
Create a shared template
Assign Web pages to Categories
Create a site map
Create a dynamic Web Template
Attaché pages to a dynamic web template
Detach a dynamic Web Template from a Web Page.
Tutorial 8
1. Objectives:
Start Access and open and examine a
database
Field is a
number of bytes centered around a content area
A record is a
number of fields centered around a larger content area.
A table is a
number of records with the same number of fields, in the same order and same
data type.
A relational
database is a database in which common fields (must be the same data type) are
established in the tables so joins can be done between the tables.
A primary key is unique, not null and
the first index of the table
enforce referential integrity - can
not put data into foreign key in related table unless it already exist in the
primary key of the primary table.
cascade update - if primary key
contents are changed the foreign key in all related table will also change.
cascade delete - if primary key
record is deleted all the related records will also be deleted.
one to many, one to one, many to many
SQL - structure query language. Select, From, Where;
Create a database connection to a Web
site
Verify a database connection ands set
a Web site to run scripts.
Insert a Database Results region in a
web page
Use a Web page to search a database
Create form that sends data to an
access database
Create and use a data Access Page.
- Tutorial 9.
Objectives:
Use a layout table to organize a web pages contents
Include a web page in a layout cell
Create a layout cell in layout table
Format a layout cell.
Create user-defined styles in a web page
Create a cascading style sheet
Link a cascading style sheet to a web page
Use a template to create a cascading style sheet
Insert a spreadsheet component into a web page and import data into it.
Get help for an Offi8ce component
Insert a chart component in a web page
Format a chart component.
|