The expert guidance you need to get the most out of Access 2010 Get the Access 2010 information you need to succeed with this comprehensive reference. If this is your first encounter with Access, you'll appreciate the thorough attention to database fundamentals and terminology. If you're familiar with earlier versions, you can jump right into Access 2010 enhancements such as the new Access user interface and wider use of XML and Web services.
Takes you under the hood of Microsoft Access 2010, the database application included with Microsoft Office 2010 Explores the latest enhancements, such as a new user interface and wider use of XML and Web services; also, how to exchange data with Word, Excel, PowerPoint, and other Office apps Covers how to create tables, manipulate datasheets, and work with multiple tables Explains the seven database objects and how to use a seven-step design method to build a database tailored to your needs Shows you how to build forms, use Visual Basic and the VBA Editor, automate query parameters, create functions and subroutines, use XML to create data access pages, and more Includes a CD with all source code from the book and working examples, plus bonus shareware, freeware, trial, demo and evaluation programs that work with or enhance Microsoft Office
You'll want to keep this soup-to-nuts Access reference close at hand!
Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.
By:
MR Groh Imprint: John Wiley & Sons Inc Country of Publication: United States Dimensions:
Height: 244mm,
Width: 189mm,
Spine: 45mm
Weight: 1.956kg ISBN:9780470475348 ISBN 10: 047047534X Series:Bible Pages: 1392 Publication Date:23 April 2010 Audience:
Professional and scholarly
,
Undergraduate
Format:Paperback Publisher's Status: Active
Acknowledgments xxxiii Introduction xxxv Part I: Access Building Blocks 1 Chapter 1: An Introduction to Database Development 3 Chapter 2: Creating Access Tables 25 Chapter 3: Designing Bulletproof Databases 91 Chapter 4: Selecting Data with Queries 129 Chapter 5: Using Operators and Expressions in Access 171 Chapter 6: Working with Datasheet View 215 Chapter 7: Creating Basic Access Forms 251 Chapter 8: Working with Data on Access Forms 289 Chapter 9: Presenting Data with Access Reports 319 Part II: Programming Microsoft Access 375 Chapter 10: VBA Programming Fundamentals 377 Chapter 11: Mastering VBA Data Types and Procedures 417 Chapter 12: The Access Event Model 451 Chapter 13: Accessing Data with VBA Code 473 Chapter 14: Debugging Your Access Applications 523 Chapter 15: Using Access Data Macros 551 Part III: More-Advanced Access Techniques 577 Chapter 16: Working with External Data 579 Chapter 17: Importing and Exporting Data 609 Chapter 18: Advanced Access Query Techniques 637 Chapter 19: Advanced Access Form Techniques 679 Chapter 20: Advanced Access Report Techniques 709 Chapter 21: Building Multiuser Applications 751 Chapter 22: Integrating Access with Other Applications 789 Chapter 23: Handling Errors and Exceptions 819 Part IV: Professional Database Development 839 Chapter 24: Optimizing Access Applications 841 Chapter 25: Advanced Data Access with VBA 881 Chapter 26: Bulletproofing Access Applications 897 Chapter 27: Using the Windows Application Programming Interface 939 Chapter 28: Object-Oriented Programming with VBA 969 Chapter 29: Customizing Access Ribbons 1009 Chapter 30: Using Access Macros 1049 Chapter 31: Distributing Access Applications 1083 Part V: Access and Windows SharePoint Services 1101 Chapter 32: Understanding Windows SharePoint Services 1103 Chapter 33: Integrating Access with SharePoint 1117 Chapter 34: Understanding Access Services 1135 Chapter 35: Deploying Access Applications to SharePoint 1145 Part VI: Access as an Enterprise Platform 1181 Chapter 36: Client/Server Concepts 1183 Chapter 37: SQL Server as an Access Companion 1199 Chapter 38: Upsizing Access Databases to SQL Server 1223 Part VII: Appendixes 1243 Appendix A: Access 2010 Specifications 1245 Appendix B: What's New in Access 2010 1253 Appendix C: What's on the CD-ROM 1267 Index 1271
Michael R. Groh is a well-known authority on Microsoft Access, having written or contributed to more than 20 books and over 200 articles on the topic. Mike has also spoken at dozens of Access conferences throughout the world.