{"product_id":"access-2010-bible-isbn-9780470475348","title":"Access 2010 Bible","description":"\u003cb\u003eThe expert guidance you need to get the most out of Access 2010\u003c\/b\u003e  \u003cp\u003eGet 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.\u003c\/p\u003e \u003cul\u003e \u003cli\u003eTakes you under the hood of Microsoft Access 2010, the database application included with Microsoft Office 2010\u003c\/li\u003e \u003cli\u003eExplores 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\u003c\/li\u003e \u003cli\u003eCovers how to create tables, manipulate datasheets, and work with multiple tables\u003c\/li\u003e \u003cli\u003eExplains the seven database objects and how to use a seven-step design method to build a database tailored to your needs\u003c\/li\u003e \u003cli\u003eShows 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\u003c\/li\u003e \u003cli\u003eIncludes 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\u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003eYou’ll want to keep this soup-to-nuts Access reference close at hand!\u003c\/p\u003e \u003cp\u003e\u003cb\u003eNote:\u003c\/b\u003e CD-ROM\/DVD and other supplementary materials are not included as part of eBook file.\u003c\/p\u003e  \u003cp\u003eAcknowledgments xxxiii\u003c\/p\u003e \u003cp\u003eIntroduction xxxv\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart I: Access Building Blocks 1\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 1: An Introduction to Database Development 3\u003c\/p\u003e \u003cp\u003eChapter 2: Creating Access Tables 25\u003c\/p\u003e \u003cp\u003eChapter 3: Designing Bulletproof Databases 91\u003c\/p\u003e \u003cp\u003eChapter 4: Selecting Data with Queries 129\u003c\/p\u003e \u003cp\u003eChapter 5: Using Operators and Expressions in Access 171\u003c\/p\u003e \u003cp\u003eChapter 6: Working with Datasheet View 215\u003c\/p\u003e \u003cp\u003eChapter 7: Creating Basic Access Forms 251\u003c\/p\u003e \u003cp\u003eChapter 8: Working with Data on Access Forms 289\u003c\/p\u003e \u003cp\u003eChapter 9: Presenting Data with Access Reports 319\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart II: Programming Microsoft Access 375\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 10: VBA Programming Fundamentals 377\u003c\/p\u003e \u003cp\u003eChapter 11: Mastering VBA Data Types and Procedures 417\u003c\/p\u003e \u003cp\u003eChapter 12: The Access Event Model 451\u003c\/p\u003e \u003cp\u003eChapter 13: Accessing Data with VBA Code 473\u003c\/p\u003e \u003cp\u003eChapter 14: Debugging Your Access Applications 523\u003c\/p\u003e \u003cp\u003eChapter 15: Using Access Data Macros 551\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart III: More-Advanced Access Techniques 577\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 16: Working with External Data 579\u003c\/p\u003e \u003cp\u003eChapter 17: Importing and Exporting Data 609\u003c\/p\u003e \u003cp\u003eChapter 18: Advanced Access Query Techniques 637\u003c\/p\u003e \u003cp\u003eChapter 19: Advanced Access Form Techniques 679\u003c\/p\u003e \u003cp\u003eChapter 20: Advanced Access Report Techniques 709\u003c\/p\u003e \u003cp\u003eChapter 21: Building Multiuser Applications 751\u003c\/p\u003e \u003cp\u003eChapter 22: Integrating Access with Other Applications 789\u003c\/p\u003e \u003cp\u003eChapter 23: Handling Errors and Exceptions 819\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart IV: Professional Database Development 839\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 24: Optimizing Access Applications 841\u003c\/p\u003e \u003cp\u003eChapter 25: Advanced Data Access with VBA 881\u003c\/p\u003e \u003cp\u003eChapter 26: Bulletproofing Access Applications 897\u003c\/p\u003e \u003cp\u003eChapter 27: Using the Windows Application Programming Interface 939\u003c\/p\u003e \u003cp\u003eChapter 28: Object-Oriented Programming with VBA 969\u003c\/p\u003e \u003cp\u003eChapter 29: Customizing Access Ribbons 1009\u003c\/p\u003e \u003cp\u003eChapter 30: Using Access Macros 1049\u003c\/p\u003e \u003cp\u003eChapter 31: Distributing Access Applications 1083\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart V: Access and Windows SharePoint Services 1101\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 32: Understanding Windows SharePoint Services 1103\u003c\/p\u003e \u003cp\u003eChapter 33: Integrating Access with SharePoint 1117\u003c\/p\u003e \u003cp\u003eChapter 34: Understanding Access Services 1135\u003c\/p\u003e \u003cp\u003eChapter 35: Deploying Access Applications to SharePoint 1145\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart VI: Access as an Enterprise Platform 1181\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 36: Client\/Server Concepts 1183\u003c\/p\u003e \u003cp\u003eChapter 37: SQL Server as an Access Companion 1199\u003c\/p\u003e \u003cp\u003eChapter 38: Upsizing Access Databases to SQL Server 1223\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart VII: Appendixes 1243\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eAppendix A: Access 2010 Specifications 1245\u003c\/p\u003e \u003cp\u003eAppendix B: What’s New in Access 2010 1253\u003c\/p\u003e \u003cp\u003eAppendix C: What’s on the CD-ROM 1267\u003cbr\u003e \u003cbr\u003e Index 1271\u003c\/p\u003e \u003cb\u003eMichael R. Groh\u003c\/b\u003e 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.  \u003cb\u003eYour personal guide to a powerful,easy-to-use, database-management system\u003c\/b\u003e  \u003cp\u003eWhether you want to use the power of Access 2010 to manipulate datasheets, build forms with wizards, or automate query parameters, this book shows you how. Discover enhancements in this version such as wider integration with SharePoint. Find examples that show you the types of tables, queries, forms, and reports you'll need to create when performing common business activities. Packed with pages of tips, techniques, and instruction, this is the guide you need to succeed with Access 2010.\u003c\/p\u003e \u003cul\u003e \u003cli\u003e \u003cp\u003eReview database and Access terminology\u003c\/p\u003e \u003c\/li\u003e \u003cli\u003e \u003cp\u003elan tables and work with Access data types\u003c\/p\u003e \u003c\/li\u003e \u003cli\u003e \u003cp\u003eConstruct queries and utilize Datasheet view\u003c\/p\u003e \u003c\/li\u003e \u003cli\u003e \u003cp\u003eCreate great-looking and effective forms and reports\u003c\/p\u003e \u003c\/li\u003e \u003cli\u003e \u003cp\u003eTake advantage of VBA programming and development techniques applicable to both Access 2010 and Access 2007\u003c\/p\u003e \u003c\/li\u003e \u003cli\u003e \u003cp\u003eHandle application errors and exceptions\u003c\/p\u003e \u003c\/li\u003e \u003cli\u003e \u003cp\u003eCustomize the Access 2010 Ribbon and use the Windows API\u003c\/p\u003e \u003c\/li\u003e \u003cli\u003e \u003cp\u003ePublish Access tables, forms, and reports on SharePoint® sites\u003c\/p\u003e \u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003e\u003cb\u003eWhat's on the CD-ROM?\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eFollow 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 most chapters, along with other useful documents, images, and help files that accompany the examples.\u003c\/p\u003e \u003cul\u003e \u003cli\u003e \u003cp\u003eAll 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 examples\u003c\/p\u003e \u003c\/li\u003e \u003cli\u003e \u003cp\u003eSearchable PDF of the book\u003c\/p\u003e \u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003eSystem Requirements: See the CD-ROM appendix for details and complete system requirements.\u003c\/p\u003e \u003cul\u003e \u003cli\u003eCreate tables and design bulletproof databases\u003c\/li\u003e \u003cli\u003eIntegrate Access with other applications\u003c\/li\u003e \u003cli\u003eOrganize, view, analyze, and share data\u003c\/li\u003e \u003c\/ul\u003e","brand":"Wiley","offers":[{"title":"Default Title","offer_id":47988652867813,"sku":"NP9780470475348","price":49.99,"currency_code":"USD","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1842\/7735\/files\/9780470475348.jpg?v=1761781128","url":"https:\/\/k12savings.com\/es\/products\/access-2010-bible-isbn-9780470475348","provider":"K12savings","version":"1.0","type":"link"}