Database Design and Programming with Access, SQL, Visual Basic and ASP
John Carter

ISBN: 0077099869,
Division: Higher Education,
Price: £39.99,
Pub Date: SEP-02,

Pages: 648
Edition: 02
Format: Paperback

Availability: In Stock

Description

The book explains all stages of database development, starting with a comprehensive database application systems development life cycle model, which clearly defines the areas of focus required for any new database developer. Database design using entity modelling and normalization are described in a clear and comprehensible manner. Covering inplementation in Access, SQL, Access forms, macros, modules and report writer, the text also addresses Visual Basic database programming using Data Control, DAO, ADO and Access modules. The second edition contains a new set of chapters on Active Server Pages with HTML and VBScript. The new material explains how to get your database onto the Internet and the benefits offered by web-based database applications. ASP is put into context with a discussion of web terminology and client and server side scripting in VBScript. Client-side scripting examples in Javascript are also included. HTML and ASP are given separate chapters, with an array of examples, screen shots and detailed code descriptions.

Features

  • Additional material covering internet specific database development
  • Takes a rational step-by-step approach to development
  • Theoretical and practical ideas are fully integrated using hundreds of examples, diagrams and screen-shots
  • Provides the complete course in Database design and programming using the most widely available and most popular software
    		•
    Table of Contents

    1. How to develop a database application

    2. Entity modelling and normalization

    3. Access database design

    4. Access query design using Query Design view

    5. Access query design using SQL ? DDL and DML statements

    6.Access query design using SQL ? the SELECT statement ? single tables and joins

    7. Access query design using SQL ? the SELECT statement ? further features

    8. Access Forms, Macros and Reports

    9. Visual Basic database programming using the Data Control

    10. Visual Basic database programming using Data Access Objects (DAO)

    11. Visual Basic database programming using ActiveX Data Objects (ADO)

    12. Visual Basic database programming using Access Modules

    13. Introduction to ASP

    14. HTML

    15. ASP

    Appendix 1
    Example databases

    Appendix 2
    Differences in database programming commands in VB versions

    Appendix 3
    HTML summary

    Glossary

    References
    Books
    Websites
    News Groups
    Help files

    Index



    Website: www.mcgraw-hill.co.uk Tel: +44 (0) 1628 502500