As a veteran Dreamweaver user, you've gone just about as far as you can go with static Web sites. Now you're ready to roll up your sleeves and get down to the real business: creating dynamic database-driven sites with your favorite authoring tool. You've come to the right place: As the only volume to cover the brand-new Dreamweaver MX 2004 from a purely database perspective, this guide provides just the combination of technical grounding and hands-on training you need to start building that e-commerce site you've been dreaming about. First, you'll learn about the technologies that fuel database-driven Web sites (so that you can select the correct tools). Then you'll begin the actual hands-on process of using Dreamweaver MX 2004, Access, and ASP.NET to build an intranet and, later, SQL Server and ColdFusion to build an organizational Web site. Author Sean Nicholson's companion Web site will include all of the code and other information necessary to build the book's demo applications.

Table of Contents:
I. INTRODUCTION TO DYNAMIC APPLICATIONS. 1. Choosing the Right Tools for Your Dynamic Application. Understanding How Database-Driven Web Applications Work. Choosing Your Web Server Software. Choosing a Dynamic Application Platform. Selecting a Database Management System. Summary. 2. Choosing Your Application Type. Web, Intranet, and Extranet Applications. Designing the Right Application for Your Needs. Planning Your Application. Bridging the Gap between Web Applications and Intranet/Extranet Applications. Summary. II. CREATING INTRANET-STRENGTH APPLICATIONS WITH MS ACCESS, ASP.NET/ColdFusion, and Dreamweaver MX 2004. 3. Building a Database for Dynamic Applications. Understanding the Structure of a Relational Database. What Is Involved in the Database Design Process? A Brief Introduction to Access. Building Our Access Database. Understanding the Limitations of an Access Database. Expanding Your Database Vocabulary. Summary. 4. Configuring Your Workstation for Application Development. Configuring Your Web Server Software. Installing and Configuring Your Web Application Server. Creating a Directory Structure for Your Application. Applying the Appropriate Directory Permissions. Establishing a Dreamweaver Site. Building a Connection to the Database. Transferring the Directory Structure to Your Testing Server. Summary. 5. Creating the Human Resources Management System. Reviewing the Database Table Structure. Creating the HR Page Template. Creating Pages for Adding New Employees. Creating Pages That Search for Existing Employee Records. Creating Pages to Edit Existing Employee Records. Testing the Application. Summary. 6. Creating the Information Services Asset Management System. Reviewing the Database Table Structure. Creating the Information Services Page Template. Creating Pages to Add Assets to the Database. Displaying the Asset Inventory. Testing the Application. Summary. 7. Creating the Departmental Page Management System. Reviewing the Database Table Structure. Creating the Page Management Template. Creating the Page Manager. Building Add, Edit, and Delete Pages. Securing the Pages. Testing the Application. Summary. 8. Building the Intranet User Interface. Creating the Intranet Template. Logging On Users. Creating Home Page Links and Departmental Home Pages. Customizing Content. Logging Out Users. Testing the Application. Summary. III. BUILDING WEB-STRENGTH APPLICATIONS WITH SQL SERVER, ASP.NET/ColdFusion, and Dreamweaver MX 2004. 9. Building a Database for Web Applications. Introducing SQL Server. Installing and Configuring SQL Server on Your Workstation. Understanding Security Issues Involved in Installing SQL Server. Using the Enterprise Manager to Create the KrystalClear Database and Tables. Setting Database Permissions. Summary. 10. Configuring Your Workstation to Build the Web Application. Installing and Configuring the Web Server Software and Application Server Software. Building the Directory Structure. Downloading the Support Files for the Internet Application. Creating a Dreamweaver Site for the Internet Application. Building the Database Connection. Summary. 11. Creating the Front End for the Web Application. Building the Basic Page Layout. Creating Static and Dynamic Hyperlinks. Creating Pages Templates for the Various Sections of the Web Application. Summary. 12. Building the Page Administration Module. Reviewing the Table Structure for the Administration Module. Creating the Login/Logout Pages for the Module. Building Pages That Manage Page Content. Adding Pages to the Application. Summary. 13. Adding Search Capabilities to the Web Applications. Understanding the Fundamentals of Searches. Using Hyperlinks to Conduct Searches. Building the Basic Search Page. Displaying the Basic Search Results. Expanding the Search Capabilities to Include Advanced Features. Placing the Data Placeholders for the Detail Pages. Summary. 14. Allowing Visitors to Create User Accounts. Reviewing the Database Tables. Building Pages That Allow Visitors to Create Custom Accounts. Providing a Way to Log In. Providing a Way to Log Out. Helping Users Retrieve a Lost Password. Building Links for Logging In, Logging Out, and Creating an Account. Summary. 15. Engaging in eCommerce. Reviewing the Database Tables. Building an Online Catalog. Building the Checkout Process. Summary. Index.