Building Access Web Sites

I: PLANNING.

1. The Web Connection.


Internet Background. A Chronological History of the Internet. The Internet Today. What Is the Web? What Are Intranets? What Is a Web Database and Why Have One? Intranet Database Application Benefits. Advantages of Web Database Applications for the User. Moving On.

2. Web Commerce.


Today's Competitive Business Environment. Why Do Business on the Web? The Role of Databases in Web Applications. Moving On.

3. Choosing a Programming Language.


Which Language to Use? Microsoft Access 97. Useful MS Access URLs. C. Shell Script. Visual Basic. PowerBuilder. Visual Basic Script. COBOL. Moving On.

4. Overview of Java and JavaScript.


Introduction to Java. Benefits of Java. Java and Object-Orientation. The Java/Web Concept. Is It Java or Coffee? Who Owns Java? Introduction to JavaScript. Strengths and Weaknesses of JavaScript. Moving On.

5. Application Development Suites.


4W Publisher and 4W Publisher Pro. A-XOrion Web Database Server. Amazon. Autobahn. Centura Web Data Publisher. DbWeb. Delphi. DynaWeb. Edify Electronic Workforce. FoxWeb. HAHTsite IDE. IQ/Live Web. Krakatoa. LivePAGE WebMaster. LiveWire and LiveWire Pro. Microsoft FrontPage 97. Personal Web Site (PWS) Toolbox. PowerBuilder 5.0. Sapphire/Web. SiteBase. Software Engine. Tango. WebHub. Webinator. WebObjects. Moving On.

6. Overview of HTML.


Introduction to HTML. Structure of HTML. Advanced HTML Topics. Good HTML Practices. The Future of HTML. Moving On.

7. Overview of CGI.


CGI Introduction. CGI Architecture. CGI Generation of HTML. CGI Programming Principles. CGI Program Architectures. Moving On.

II: INTERNET DATABASE DESIGN.

8. Web Application Design and Development.


Advantages of Deploying an Application on Your Chosen Platform. The Design Process Described. Web Database Application Components. Web Application Design Primer. Web Database Application Design. Application Partitioning. Application Partitioning Summary. Moving On.

9. Introduction to Access 97.


What Is Access 97? What's New in Access 97? DDL, DML, and Access 97. Creating Databases and Database Objects. Creating a Database. Creating a Table. Moving On.

10. Access 97 Queries.


Introduction to Access 97 Queries. Query Boundaries. The QBE Grid. Setting Query Properties. Joining Tables in a Query. Accessing External Data. Moving On.

11. Designing Advanced MS Access Queries.


SELECT Statement Clauses. Parameter Queries. Nested Queries. Action Queries. Optimizing Queries. Analyzing Query Performance with Analyzer. Moving On.

III: INTERFACING WITH THE INTERNET USER.

12. HTML Forms and Database Access.


Objects. Syntax of HTML Markups. Overcoming Limitations of Placing Objects on HTML Forms. Database Queries and HTML. Database Updates and HTML. Form Design Tips. Moving On.

13. Accessing Web Databases Using CGI Programs.


Basics of CGI Programs. Reading User Data into CGI Programs. Common Web Database Access Methods. Why Use Custom CGI Programs for Database Access? Choosing a CGI Programming Language. Accessing Web Databases Using CGI Programs. Contents of the CGI Profile File. Querying a Database. Inserting Rows in a Database from a Web Application. Deleting a Row from a Database Using a Web Application. Updating a Database Row from a Web Application. Providing Full Database Access from Your Web Application. Moving On.

14. MIME and Advanced Data Presentation.


What Is MIME? Uses for MIME on the Web. MIME Types and Subtypes. MIME Perspectives. Moving On.

15. Managing Web Database Access and the Application State.


What Is Application State? Using Forms to Maintain State. Using Database Tables to Maintain State. Using Persistent Cookies to Maintain State. Moving On.

16. Improving the Performance of Web Database Applications.


Application Optimization. Access 97 Database Optimization. Moving On.

IV: ADVANCED TOPICS IN INTERNET DATABASE PUBLISHING.

17. Migrating Data from Enterprise Data Stores to Server-Based Databases.


What to Migrate. Replication. Synchronization. Backing Up a Web Database. Restoring a Web Database. Moving On.

18. Using Firewalls and Security Components to Protect Your Data.


Access 97 Security. Web Site Security—The Problem. Security of Your Web Server. Secure Sockets Layer (SSL). CGI Security. Firewalls. Other Resources. Moving On.

19. Designing an Internet Course Delivery System.


Background. XYZ's Existing Environment. Project Analysis. The Design Process Described. The Development Process. Implementation. Post-Implementation Analysis. Moving On.

20. Building a Simple Class Registration System.


Application Configuration. Web Database Internet Components in the Application. Web Database Intranet Components in the Application. Maintain Course Dates Page. Moving On.

APPENDICES.

Appendix A. CD-ROM Contents.


CD-ROM Contents. Limits of Liability and Disclaimer of Warranty. Technical Support.

Appendix B. Frequently Asked Questions.


What Is the Internet? What Is the Web? What Are Intranets? What Is a Web Database and Why Have One? What Types of Databases Are Accessible in a Web Database Application? What Are the Advantages of Web Database Applications for the User? What Are the Advantages to a Company of Building a Web Database Application? What Is the Role of Databases in Web Applications? What Are the Components in a Web Database Application? What Should I Consider When Choosing a Programming Language? What Are Some of the Languages Available to Help Me Build a Web Database Application? What Are Web Database Application Development Suites? What Are Some of the Benefits and Limitations to HTML? What Is a CGI Program? How Does a CGI Program Fit in the Architecture of a Web Database Application? How Does Data Get Passed from an HTML Page to a CGI Program? Are There Any Programming Principles That I Should Be Aware of When Writing CGI Programs? Where Should Security Exist in a Web Database Application? What Are Some of the New Features in Access 97 That Are Specific to Web Database Applications? What Types of Join Relationships Are Recognized in Access 97? What Types of Objects Are Allowed on HTML Forms? How Can I Format and Submit a Database Query from within an HTML Page? Why Should You Use Custom CGI Programs for Database Access? What Is MIME?

Appendix C. WWW Database Development Resources.


Databases. Other. Programming Languages. Reference Material. Security. Web Servers.

Index.