Beginning and intermediate programmers will gain a solid
understanding of
database theory by following the examples
presented in this
Visual Basic guide. The information
necessary for integrating
Visual Basic programs and
databases is incorporated into this book through an
application development example. Every aspect of database
design and integration is covered, including tables,
records, fields, field types, primary and foreign keys,
referential integrity, Microsoft Access, ActiveX
Data
Objects, queries,
SQL basics, DBGrid control, and
recordsets. The book's question and answer format solves
common programming problems and offers new programming
options.
Table of Contents
- Chapter 1: The China Shop Revisited
- Chapter 2: Database Primer
- Chapter 3: Database Design
- Chapter 4: Basic Data Access with the Data Control
- Chapter 5: More on Data Access: the Recordset
- Chapter 6: More on the Recordset
- Chapter 7: Updating the Recordset
- Chapter 8: Completing Staff Functions
- Chapter 9: Enhancing the User Interface
- Chapter 10: Completing the China Shop Program
- Appendix A: Student Biographies
- Appendix B: Installing the China Shop
- Appendix C: The Systems Development Life Cycle