Microsoft Office Access 2007 Bible (ENG)
Bạn nào thích lập trình với MS Access thì tham khảo cuốn sách này, rất hay và đầy đủ.
Harness the power of Access 2007 with the expert guidance in this comprehensive reference. Beginners will appreciate the thorough attention to database fundamentals and terminology. Experienced users can jump right into Access 2007 enhancements like the all-new user interface and wider use of XML and Web services. Each of the book’s six parts thoroughly focuses on key elements in a logical sequence, so you have what you need, when you need it. Designed as both a reference and a tutorial, Access 2007 Bible is a powerful tool for developers needing to make the most of the new features in Access 2007.
- Build Access tables using good relational database techniques
- Construct efficient databases using a five-step design method
- Design efficient data-entry and data display forms
- Utilize the improved Access report designer
- Use Visual Basic(r) for Applications and the VBA Editor to automate applications
- Build and customize Access 2007 ribbons
- Seamlessly exchange Access data with SharePoint(r)
- Employ advanced techniques such as the Windows(r) API and object-oriented programming
- Add security and use data replication in your Access applications
Table of contents
Part I: Access Building Blocks.
Chapter 1: An Introduction to Database Development.
Chapter 2: Creating Access Tables.
Chapter 3: Designing Bulletproof Databases.
Chapter 4: Selecting Data with Queries.
Chapter 5: Using Operators and Expressions in Access.
Chapter 6: Working with Datasheet View.
Chapter 7: Creating Basic Access Forms.
Chapter 8: Working with Data on Access Forms.
Chapter 9: Presenting Data with Access Reports.
Part II: Programming Microsoft Access.
Chapter 10: VBA Programming Fundamentals.
Chapter 11: Mastering VBA Data Types and Procedures.
Chapter 12: Understanding the Access Event Model.
Chapter 13: Using Expressions in Queries and VBA Code.
Chapter 14: Accessing Data with VBA Code.
Chapter 15: Using the VBA Debugging Tools.
Part III: More Advanced Access Techniques.
Chapter 16: Working with External Data.
Chapter 17: Importing and Exporting Data.
Chapter 18: Advanced Access Query Techniques.
Chapter 19: Advanced Access Form Techniques.
Chapter 20: Advanced Access Report Techniques.
Chapter 21: Building Multiuser Applications.
Chapter 22: Integrating Access with Other Applications.
Chapter 23: Integrating Access with SharePoint.
Chapter 24: Using ActiveX Controls.
Chapter 25: Handling Errors and Exceptions.
Part IV: Professional Database Development.
Chapter 26: Optimizing Access Applications.
Chapter 27: Advanced Data Access with VBA.
Chapter 28: Bulletproofing Access Applications.
Chapter 29: Securing Access Applications.
Chapter 30: Using the Windows API.
Chapter 31: Using the Access Replication Features.
Chapter 32: Object-Oriented Programming with VBA.
Chapter 33: Reusing VBA Code with Libraries.
Chapter 34: Customizing Access Ribbons.
Chapter 35: Distributing Access Applications.
Chapter 36: Using Access Macros.
Part V: Access as an Enterprise Platform.
Chapter 37: Using XML in Access 2007.
Chapter 38: SharePoint as a Data Source.
Chapter 39: Client/Server Concepts.
Chapter 40: SQL Server as an Access Companion.
Chapter 41: Upsizing Access Databases to SQL Server.
Part VI: Appendixes.
Appendix A: Access 2007 Specifications.
Appendix C: What’s New in Access 2007.
Wiley Publishing, Inc. End-User License Agreement.