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. 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 tag examples
Appendix 4 SQL SELECT statement summary