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