Accessibility
 
Home > Products > Dreamweaver > Support > Working with Studio MX
Dreamweaver Icon Macromedia Dreamweaver Support Center - Working with Studio MX
Creating the database

The final step is creating the database using a database system like Microsoft Access, SQL Server, Oracle 9i, or MySQL. For more information, consult your database vendor's documentation.

You can download a Microsoft Access version of the Wildlife Project database here:

Download the Windows wildlife.mdb source file (12K)

The Wildlife Project database contains a single table called CONTACT_INFORMATION.

Within the table there are seven columns: ID, CONTACT, STREET, CITY, STATE, ZIP_CODE, and PHONE. The ID column contains the primary key ID. The rest of the columns contain the contact information for Wildlife Project branches in various U.S. cities. Currently, there are only twelve records in the database. This will be sufficient for displaying the results retrieved by the search application later on.

If you are using a database other than Microsoft Access (such as MySQL), and cannot use the sample Microsoft Access database, you'll need to create your own database before you can perform the application development tutorials in this series. You can duplicate the sample database by creating a table with eight columns as described above, and populating the fields with information. It is important that you create a distinct column for STATE in your database. Later, you will use the two-letter abbreviation for U.S. state when you define the search application's search parameter. Additionally, don't forget to include a primary key ID column as the first column in your database.

Submit feedback about this tutorial.

To Table of Contents Back to Previous document