Contents – overview

Preface

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. The Internet, WWW and ASP

14. Creating web pages using HTML

15. Creating ASP web pages using HTML and VBScript

Appendix 1

Example databases

Appendix 2

Differences in database programming commands in

VB versions

Appendix 3

HTML summary

Appendix 4

SQL summary

Glossary

References

Books

Websites

News Groups

Help files

Index