At Course Completion: Upon successful completion of this course, students will be able to: - establish database connectivity. - work with recordsets. - create interactive page elements. - administer database records. - create a user authentication system. - administer websites.
Prerequisite(s) or equivalent knowledge: Access 2003 - Level 1 HTML 4.01: Web Authoring (Second Edition) - Level 1 Dreamweaver CS3 - Level 1 Dreamweaver CS3 - Level 2
Outline: Lesson 1: Establishing Database Connectivity Connect to a Server Using Server Technologies Identify the Components of a Database-Driven Site Creating a Connection to the Database
Lesson 2: Working with Recordsets Create Recordsets Display Records Page Through Recordsets
Lesson 3: Creating Interactive Page Elements Create Master and Detail Pages Create Search and Result Pages Use Dynamic Form Elements
Lesson 4: Administering Database Records Insert Records Edit Records Delete Records
Lesson 5: Creating a User Authentication System Create a User Registration Form Secure Your Web Pages
Lesson 6: Administering Websites Transferring Files to Servers Manage Websites