9780470770467

Summary

The expert guidance you need to get the most out of Access 2010Get 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 OfficeYou'll want to keep this soup-to-nuts Access reference close at hand!

Acknowledgments
Introduction
Access Building Blocks
An Introduction to Database Development
Creating Access Tables
Designing Bulletproof Databases
Selecting Data with Queries
Using Operators and Expressions in Access
Working with Datasheet View
Creating Basic Access Form
Working with Data on Access Forms
Presenting Data with Access Reports
Programming Microsoft Access
VBA Programming Fundamentals
Mastering VBA Data Types and Procedures
The Access Event Model
Accessing Data with VBA Code
Debugging Your Access Applications
Using Access Data Macros
More-Advanced Access Techniques
Working with External Data
Importing and Exporting Data
Advanced Access Query Techniques
Advanced Access Form Techniques
Advanced Access Report Techniques
Building Multiuser Applications
Integrating Access with Other Applications
Handling Errors and Exceptions
Professional Database Development
Optimizing Access Applications
Advanced Data Access with VBA
Bulletproofing Access Applications
Using the Windows Application Programming Interface
Object-Oriented Programming with VBA
Customizing Access Ribbons
Using Access Macros
Distributing Access Applications
Access and Windows SharePoint Services
Understanding Windows SharePoint Services
Integrating Access with SharePoint
Understanding Access Services
Deploying Access Applications to SharePoint
Access as an Enterprise Platform
Client/Server Concepts
SQL Server as an Access Companion
Upsizing Access Databases to SQL Server
Appendixes
Access 2010 Specifications
What's New in Access 2010
What's on the CD-ROM
Index
Table of Contents provided by Publisher. All Rights Reserved.

Supplemental Materials

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.