| |
Dreamweaver Ultradev/MX Access
Database search tutorial.
This tutorial will explain how to create a database search page,
a results page and a detail page using Dreamweaver Ultradev
4 and Microsoft Access. You will need both these applications
and a PC with Windows 98 or Windows NT with PWS (Personal Web
Server) or Windows 2000 with IIS (Internet Information Server)
installed in order to complete the tutorial.
NOTE: This tutorial was originally
written for Ultradev 4, however, with the exception of a few
interface differences, the process is almost identical for Dreamweaver
MX and you shouldn't have any problems following the
tutorial.
Take
a look at the working demo
to see how the finished pages will work.
Download TDSFTutorial.zip
(2Mb), this contains the entire tutorial as both an Adobe Acrobat
pdf file and a Microsoft Word 2000 document, the database, and
the completed web pages.
The completed web pages are provided for you to reference, in
particular you will need to refer to the code for originalresults.asp
in which the VBScript has been extensively commented.
A completed database is provided to save time entering test
data, but ideally you should be familiar with access.
   |
| |
Table
of Contents.
|
| 1 |
Before
We Start. |
| |
A brief note about the document
conventions.
|
| 2 |
Specifications
for the search pages. |
| |
A description of the functional
capabity of the search pages.
|
| 3 |
Where
to put everything. |
| |
Explains where to put the
files once you have downloaded TDSFTutorial.exe.
|
| 4 |
The
Database. |
| |
An overview of the demo
database and the relationships.
|
| 5 |
Connecting
to the Database. |
| |
Describes how to set up
and OLE DB connection.
|
| 6 |
Defining
the Site. |
| |
Describes how to define
the site within Ultradev to allow you to preview the site in
your browser.
|
| 7 |
The
Search Page. |
| |
The step by step instructions
for creating the search page.
|
| 8 |
The
Results Page. |
| |
The step by step instructions
for creating the results page.
|
| 9 |
Adding
and Modifying VBScript. |
| |
Some
basic VBScript notes for use in conjunction with the Results
Page Code.
|
| 10 |
The
Details Page. |
| |
The step by step instructions
for creating the details page.
|
| 11 |
Improving
the Search Pages. |
| |
Some modifications to improve
the functionality of the pages and prevent error messages.
|
| 12 |
Food
for Thought. |
| |
Some considerations when
designing databases and implementing searches.
|
| 13 |
Further
Reading. |
| |
Some links to
other useful Ultradev resources and feedback information.
|
