You're beyond the basics, so dive right in and really put your database skills to work! This supremely organized reference is packed with hundreds of timesaving solutions, troubleshooting tips, and workarounds. It's all muscle and no fluff. Discover how the experts tackle Access 2010 -- and challenge yourself to new levels of mastery!

Master essential data management and design techniques Import and link to data from spreadsheets, databases, text files, and other sources Use action queries to quickly insert, update, or delete entire sets of data Create custom forms to capture and display data Design reports to calculate, summarize, and highlight critical data--and learn advanced techniques Automate your application with macros and Visual Basic for Applications (VBA) Use Access Services to extend your database application to the Web Try out the sample client and web database applications in both 32-bit and 64-bit versions A Note Regarding the CD or DVD

The print version of this book ships with a CD or DVD. The sample client and web database applications are provided in both 32-bit and 64-bit versions. Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions.

For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.


You're beyond the basics, so dive right in and really put your database skills to work! This supremely organized reference is packed with hundreds of timesaving solutions, troubleshooting tips, and workarounds. It's all muscle and no fluff. Discover how the experts tackle Access 2007-and challenge yourself to new levels of mastery!





Create tables that support your database design strategy
Import and link to data from spreadsheets, text files, databases, and other ODBC data sources
Build simple to complex queries to manipulate data
Learn advanced techniques for building and customizing user interface forms
Design attractive reports to calculate and analyze large sets of data
Automate your application with Microsoft Visual Basic(R) for Applications
Customize the Office Fluent Ribbon
Explore using XML and Windows(R) SharePoint(R) Services to create Web-based applications



CD includes:



Fully searchable eBook-plus bonus chapters
Sample database applications-including query, form, and report examples
Articles from the experts: designing databases, understanding SQL, exporting data, and more
Links to demos, blogs, and user communities
References for finding Access 2003 commands in Access 2007
Windows Vista(R) Product Guide eReference and other eBooks



For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.