Database Design and Programming with Access, SQL and Visual Basic

Contents - overview

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 - SELECT statement - single tables and joins
7. Access query design using SQL - 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. Appendix 1 - Example databases
14. Appendix 2 - Differences between database programming commands in VB versions
15. Appendix 3 - Definitions
16. References - Books, Websites, News Groups, Help files
17. Index