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.
Editorial Reviews
From the Inside Flap
Your personal guide to a powerful,easy-to-use, database-management system
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.
Create tables and design bulletproof databases
Integrate Access with other applications
Organize, view, analyze, and share data
From the Back Cover
Your personal guide to a powerful,easy-to-use, database-management system
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.
Create tables and design bulletproof databases
Integrate Access with other applications
Organize, view, analyze, and share data
About the Author
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.
Wow! eBook
