- Shopping Bag ( 0 items )
Want a NOOK? Explore Now
Whether 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.
Review database and Access terminology
lan tables and work with Access data types
Construct queries and utilize Datasheet view
Create great-looking and effective forms and reports
Take advantage of VBA programming and development techniques applicable to both Access 2010 and Access 2007
Handle application errors and exceptions
Customize the Access 2010 Ribbon and use the Windows API
Publish Access tables, forms, and reports on SharePoint® sites
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 most chapters, along with other useful documents, images, and help files that accompany the examples.
All 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
Searchable PDF of the book
System Requirements: See the CD-ROM appendix for details and complete system requirements.
Acknowledgments.
Introduction.
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 Form.
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: The Access Event Model.
Chapter 13: Accessing Data with VBA Code.
Chapter 14: Debugging Your Access Applications.
Chapter 15: Using Access Data Macros.
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: Handling Errors and Exceptions.
Part IV: Professional Database Development.
Chapter 24: Optimizing Access Applications.
Chapter 25: Advanced Data Access with VBA.
Chapter 26: Bulletproofing Access Applications.
Chapter 27: Using the Windows Application Programming Interface.
Chapter 28: Object-Oriented Programming with VBA.
Chapter 29: Customizing Access Ribbons.
Chapter 30: Using Access Macros.
Chapter 31: Distributing Access Applications.
Part V: Access and Windows SharePoint Services.
Chapter 32: Understanding Windows SharePoint Services.
Chapter 33: Integrating Access with SharePoint.
Chapter 34: Understanding Access Services.
Chapter 35: Deploying Access Applications to SharePoint.
Part VI: Access as an Enterprise Platform.
Chapter 36: Client/Server Concepts.
Chapter 37: SQL Server as an Access Companion.
Chapter 38: Upsizing Access Databases to SQL Server.
Part VII: Appendixes.
Appendix A: Access 2010 Specifications.
Appendix B: What’s New in Access 2010.
Appendix C: What’s on the CD-ROM.
Index.
Anonymous
Posted Fri Aug 12 00:00:00 EDT 2011
No text was provided for this review.
Anonymous
Posted Fri May 13 00:00:00 EDT 2011
No text was provided for this review.
Anonymous
Posted Tue May 24 00:00:00 EDT 2011
No text was provided for this review.
Overview
Whether 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, ...