Sams Teach Yourself Database Programming with Visual Basic 6 in 24 Hours

(NOTE: Each chapter concludes with a Summary, Q&A and a Workshop.) Hour 1. Database Basics. What is Database Programming? What is a Database? Hour 2. Examining the Data Form Wizard Project. Opening the Project. Hour 3. Introducing the Data Control. How Does the Data Control Relate to a Database Application? Creating a Data Control Application. Using the Data Control from Scratch. Hour 4. General Database Concepts. What is the Structure of a Database? How Do I Decide What Goes in My Database? Hour 5. Constructing Databases. The Visual Data Manager. Creating Your First Database. Hour 6. Visual Data Manager. Visual Data Manager Overview. Data Form Designer. Query Builder. Entering Initial Information. Creating an Index for the todo Table. Creating One More Table. Hour 7. Data Environment. Data Environment in the Project Window. Creating a Data Project. Adding Data Environments to a Project. Binding the Data Environment to a Control. Data View Window. Hour 8. Data-Aware Controls. Data-Aware Controls Overview. Setting Up a Test Environment. Using the Bound Controls. DataList and DataCombo Controls. Hour 9. Creating an ActiveX Control and Using the Data Repeater. How is the Data Repeater Used? Hour 10. Multitable Relations. What is a Relational Database? Multiple Tables. Hour 11. Creating a User Interface. Interface Design Process. Database Specifics. Other Interface Guidelines. Hour 12. Multitable Forms. Constructing a Two-Form Application. Creating the Main Form. Creating the ToDo Entry Form. Hour 13. Data Reporting. Data Report Overview. Creating a Report from the Northwind Database. Toolbox Controls. Hour 14. Graphing Data. Overview of the Graph Control. Binding the Graph Control. Chart Type Constants. Hour 15. Multi-User Database Design. Sharing with a File Server. Database Locking. Hour 16. Object Diagrams. How Do Objects Work? Reading an Object Diagram. Using the Object Browser. Controlling Excel from VB. Hour 17. Understanding ActiveX Database Objects (ADD). What Can ADO Do? What Does ADO Look Like? ADO Object Model. Other ADO Objects. Hour 18. Using SQL. What is SQL? Experimenting with the Visual Data Manager. SQL Keywords. Hour 19. Database Application Deployment. Optimizing Database Applications. Using Multiple Indexes. End- User Considerations. Application Setup Wizard. User Login. Asynchronous Processing. Hour 20. Accessing Outlook. Accessing Outlook. Adding an Appointment from VB. Creating a New Contact from VB. Accessing Contact Information. Hour 21. Sharing the Database. Data Integrity. Transactions in Visual Basic. Hour 22. Database Security. Why Should I Worry About Database Security? Planning Database Security. Visual Basic Security. Implementing Security on hr5.mdb. Hour 23. Older VB. Data Object Models. Upgrading Legacy Projects. Sharing Data with a 16-Bit System. Hour 24. Raw Data Conversion and Migration. Reading a Simple File. File Types. File System Objects. Appendixes. Appendix A. Error Handling. Error Handling Routines. Database Error Problems. Appendix B. Glossary. Appendix C. Answers. Hour 1. Hour 2. Hour 3. Hour 4. Hour 5. Hour 6. Hour 7. Hour 8. Hour 9. Hour 10. Hour 11. Hour 12. Hour 13. Hour 14. Hour 15. Hour 16. Hour 17. Hour 18. Hour 19. Hour 20. Hour 21. Hour 22. Hour 23. Hour 24. Index.