Access™ 2007 Bible
Michael R. Groh, Joseph C. Stockman,
Gavin Powell, Cary N. Prague,
Michael R. Irwin, and Jennifer Reardon
Michael R. Groh, Joseph C. Stockman,
Gavin Powell, Cary N. Prague,
Michael R. Irwin, and Jennifer Reardon
Copyright © 2007 by Wiley Publishing, Inc., Indianapolis, Indiana
Library of Congress Control Number: 2006936763
ISBN-13: 978-0-470-04673-9
ISBN-10: 0-470-04673-2
Acknowledgments ........................................xxxix
Foreword ........................................................xli
Part I: Access Building Blocks . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1
Chapter 1: An Introduction to Database Development ..............3
Chapter 2: Creating Access Tables ................................................23
Chapter 3: Designing Bulletproof Databases.................................87
Chapter 4: Selecting Data with Queries .......................................123
Chapter 5: Using Operators and Expressions in Access ............161
Chapter 6: Working with Datasheet View.....................................203
Chapter 7: Creating Basic Access Forms.......................................237
Chapter 8: Working with Data on Access Forms ........................269
Chapter 9: Presenting Data with Access Reports........................297
Part II: Programming Microsoft Access . . . . . . . . . . . . . . . . . . . 345
Chapter 10: VBA Programming Fundamentals ...........................347
Chapter 11: Mastering VBA Data Types and Procedures ...........385
Chapter 12: Understanding the Access Event Model ..................417
Chapter 13: Using Expressions in Queries and VBA Code ..........443
Chapter 14: Accessing Data with VBA Code....................................471
Chapter 15: Using the VBA Debugging Tools .................................497
Part III: More Advanced Access Techniques . . . . . . . . . . . . . . . 523
Chapter 16: Working with External Data ......................................525
Chapter 17: Importing and Exporting Data ..................................555
Chapter 18: Advanced Access Query Techniques ........................581
Chapter 19: Advanced Access Form Techniques ..........................617
Chapter 20: Advanced Access Report Techniques .......................647
Chapter 21: Building Multiuser Applications .................................685
Chapter 22: Integrating Access with Other Applications ............723
Chapter 23: Integrating Access with SharePoint .........................749
Chapter 24: Using ActiveX Controls...............................................769
Chapter 25: Handling Errors and Exceptions ..............................801
Part IV: Professional Database Development . . . . . . . . . . . . . . 821
Chapter 26: Optimizing Access Applications ..............................823
Chapter 27: Advanced Data Access with VBA...........................863
Chapter 28: Bulletproofing Access Applications .........................877
Chapter 29: Securing Access Applications ...................................909
Chapter 30: Using the Windows API ............................................951
Chapter 31: Using the Access Replication Features ....................987
Chapter 32: Object-Oriented Programming with VBA ............1037
Chapter 33: Reusing VBA Code with Libraries .........................1079
Chapter 34: Customizing Access Ribbons ...................................1089
Chapter 35: Distributing Access Applications..............................1117
Chapter 36: Using Access Macros................................................1133
Part V: Access as an Enterprise Platform . . . . . . . . . . . . . . . . . 1163
Chapter 37: Using XML in Access 2007 .....................................1165
Chapter 38: SharePoint as a Data Source ..................................1191
Chapter 39: Client/Server Concepts ...........................................1209
Chapter 40: SQL Server as an Access Companion .................1223
Chapter 41: Upsizing Access Databases to SQL Server .......1249
Part VI: Appendixes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1265
Appendix A: Access 2007 Specifications ...............................1267
Appendix B: What’s on the CD-ROM .....................................1275
Appendix C: What’s New in Access 2007................................1279
Index ...........................................................................................1291
Wiley Publishing, Inc. End-User License Agreement ..........1362
เล่มนี้ครบถ้วน ชัดเจนครับ
หากอ่านเรื่อง VBA ยังไม่เต็มอิ่ม ต่อด้วยเล่มนี้เลยครับ
จำนวน 1155 หน้า
Access™ 2007 VBA
Programmer’s Reference
Teresa Hennig
Rob Cooper
Geoffrey Griffith
Programmer’s Reference
Teresa Hennig
Rob Cooper
Geoffrey Griffith
Armen Stein
Copyright ©2007 by Wiley Publishing, Inc., Indianapolis, Indiana
ISBN: 978-0-470-04703-3
ISBN: 978-0-470-04703-3
ผมคิดว่าสองเล่มที่แนะนำไปข้างต้นจะตอบโจทย์ได้หลายข้อเลยครับ และโอกาสต่อไปผมจะได้แนะนำการปฎิบัติการจริงต่อไปครับ ขอบคุณครับ...