- A Note Regarding Supplemental Files
- Preface
- I. Database Design
- 1. Introduction
- 2. The Entity-Relationship Model of a Database
- 3. Implementing Entity-Relationship Models: Relational Databases
- 4. Database Design Principles
- II. Database Queries
- 5. Query Languages and the Relational Algebra
- 5.1. Query Languages
- 5.2. Relational Algebra and Relational Calculus
- 5.3. Details of the Relational Algebra
- 6. Access Structured Query Language (SQL)
- 6.1. Introduction to Access SQL
- 6.2. Access Query Design
- 6.3. Access Query Types
- 6.4. Why Use SQL?
- 6.5. Access SQL
- 6.6. The DDL Component of Access SQL
- 6.7. The DML Component of Access SQL
- 5. Query Languages and the Relational Algebra
- III. Database Architecture
- IV. Visual Basic for Applications
- 8. The Visual Basic Editor, Part I
- 9. The Visual Basic Editor, Part II
- 9.1. Navigating the IDE
- 9.2. Getting Help
- 9.3. Creating a Procedure
- 9.4. Run Mode, Break Mode, and Design Mode
- 9.5. Errors
- 9.6. Debugging
- 9.6.1. Tracing
- 9.6.1.1. Step Into (F8 or choose Step Into from the Debug menu)
- 9.6.1.2. Step Over (Shift+F8 or choose Step Over from the Debug menu)
- 9.6.1.3. Step Out (Ctrl+Shift+F8 or choose Step Out from the Debug menu)
- 9.6.1.4. Run to Cursor (Ctrl+F8 or choose Run To Cursor from the Debug menu)
- 9.6.1.5. Set Next Statement (Ctrl+F9 or choose Set Next Statement from the Debug menu)
- 9.6.1.6. Breaking out of Debug mode
- 9.6.1. Tracing
- 10. Variables, Data Types, and Constants
- 10.1. Comments
- 10.2. Line Continuation
- 10.3. Constants
- 10.4. Variables and Data Types
- 10.4.1. Variable Declaration
- 10.4.2. The Importance of Explicit Variable Declaration
- 10.4.3. Numeric Data Types
- 10.4.4. Boolean Data Type
- 10.4.5. String Data Type
- 10.4.6. Date Data Type
- 10.4.7. Variant Data Type
- 10.4.8. Access Object Data Types
- 10.4.9. Arrays
- 10.4.10. Variable Naming Conventions
- 10.4.11. Variable Scope
- 10.4.12. Variable Lifetime
- 10.4.13. Variable Initialization
- 10.5. VBA Operators
- 11. Functions and Subroutines
- 12. Built-in Functions and Statements
- 13. Control Statements
- V. Data Access Objects
- 14. Programming DAO: Overview
- 15. Programming DAO: Data Definition Language
- 16. Programming DAO: Data Manipulation Language
- 16.1. Recordset Objects
- 16.2. Opening a Recordset
- 16.3. Moving Through a Recordset
- 16.4. Finding Records in a Recordset
- 16.5. Editing Data Using a Recordset
- 16.5.1. Editing an Existing Record
- 16.5.2. Deleting an Existing Record
- 16.5.3. Adding a New Record
- 16.5.3.1. Notes
- VI. ActiveX Data Objects
- 17. ADO and OLE DB
- 17.1. What Is ADO?
- 17.2. Installing ADO
- 17.3. ADO and OLE DB
- 17.4. The ADO Object Model
- 17.5. Finding OLE DB Providers
- 17.6. A Closer Look at Connection Strings
- 17.7. An Example: Using ADO over the Web
- 18. ADOX: Jet Data Definition in ADO
- 17. ADO and OLE DB
- VII. Programming Problems
- 19. Some Common Data Manipulation Problems
- VIII. Appendixes
- A. DAO 3.0/3.5 Collections, Properties, and Methods
- A.1. DAO Classes
- A.2. A Collection Object
- A.3. Connection Object (DAO 3.5 Only)
- A.4. Container Object
- A.5. Database Object
- A.6. DBEngine Object
- A.7. Document Object
- A.8. Error Object
- A.9. Field Object
- A.10. Group Object
- A.11. Index Object
- A.12. Parameter Object
- A.13. Property Object
- A.14. QueryDef Object
- A.15. Recordset Object
- A.16. Relation Object
- A.17. TableDef Object
- A.18. User Object
- A.19. Workspace Object
- B. The Quotient: An Additional Operation of the Relational Algebra
- C. Open Database Connectivity (ODBC)
- C.1. Introduction
- C.2. The ODBC Driver Manager
- C.3. The ODBC Driver
- C.4. Data Sources
- C.5. Getting ODBC Driver Help
- C.6. Getting ODBC Information Using Visual Basic
- D. Obtaining or Creating the Sample Database
- E. Suggestions for Further Reading
- A. DAO 3.0/3.5 Collections, Properties, and Methods
- Index
- Colophon
- Copyright
Part IV. Visual Basic for Applications
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.