Access 2007 Bible
"I recommend this book for anyone who wants a strong foundation in Access."\ —Jeff Lenamon, CIBC World Markets\ Updated edition with exciting new Access 2007 features!\ 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...
Search in google:
"I recommend this book for anyone who wants a strong foundation in Access."—Jeff Lenamon, CIBC World Markets Updated edition with exciting new Access 2007 features! 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 techniquesConstruct efficient databases using a five-step design methodDesign efficient data-entry and data display formsUtilize the improved Access report designerUse Visual Basic® for Applications and the VBA Editor to automate applicationsBuild and customize Access 2007 ribbonsSeamlessly exchange Access data with SharePoint®Employ advanced techniques such as the Windows® API and object-oriented programmingAdd security and use data replication in your Access applications What's on the CD-ROM? Follow the examples in the book chapter by chapter using the bonus materials on the CD-ROM. You'll find separate Microsoft Access database files for each chapter and other working files, includingAll the examples and databases used in the book, including database files, images, data files in various formats, and icon files used in the book's examplesA complete sample application file, including queries, reports, objects, and modules, that you can use as a reference See the CD-ROM appendix for details and complete system requirements.
Acknowledgments. Foreword. 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 B: What’s on the CD-ROM. Appendix C: What’s New in Access 2007. Index. Wiley Publishing, Inc. End-User License Agreement.
\ From Barnes & NobleThe Barnes & Noble Review\ Making the most of Access 2007 means mastering its built-in features, extending them programmatically, and integrating your databases with your broader environment. Access 2007 Bible covers all that and more. You could start as a beginner, grow into an enterprise developer, and still find great value here. \ The authors teach everything through an extensive example application that links theory and technique with business problem solving. Using it, you learn all the basics in nine chapters: from designing databases to navigating Access 2007's revamped interface to creating reports.\ The authors next turn to VBA, linking concepts to useful techniques such as creating functions to calculate taxes. There's an up-to-the-minute section on integration, from basic data import/export to leveraging SharePoint team sites. You'll find practical insight into database optimization, bulletproofing, security, distribution, even using Access alongside SQL Server. This isn't just a tour of Access: It's a tour de force. Bill Camarda, from the February 2007 Read Only\ \ \
