Database Design & Programming 2nd Edition

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.

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