Microsoft® Office Access(TM) 2007 Inside Out (Inside Out (Microsoft)) [Paperback]

John Viescas (Author), Jeff Conrad (Author)

Book Description

Publication Date: April 11, 2007 | ISBN-10: 0735623252 | ISBN-13: 978-0735623255

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® for Applications
• Customize the Office Fluent Ribbon
• Explore using XML and Windows® SharePoint® 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® Product Guide eReference and other eBooks

A Note Regarding the CD or DVD

The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via OReilly Medias Digital Distribution services. To download this content, please visit OReillys web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). 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. Please direct any questions or concerns to [e-mail].

Editorial Reviews

From the Publisher

Key Book Benefits:

-Discover what's new in Microsoft Access 2007
-Award-winning INSIDE OUT format makes hundreds of tips, tricks, and workarounds easy to find and easy to use
-Drills into the most-used features and functions in Access, delivering comprehensive details--but no fluff--in a single volume
-Learn how to develop a database design strategy, create relationships on multiple fields, add indexes, and explore advanced table design
-Includes a companion CD with customer resources, eBooks, and more

About the Author

John L. Viescas is a database expert who provides consulting and training services to companies around the globe. He is the author of numerous books, including Running Microsoft Access 97, Running Microsoft Access 2000, Microsoft Office Access 2003 Inside Out, Building Microsoft Access Applications, and Microsoft Office Access 2007 Inside Out. John has been recognized as a Microsoft MVP since 1993.

Home Page: Viescas Consulting, Inc.

Jeff was awarded Microsoft's Most Valuable Professional award from 2005 to 2007 before joining Microsoft for his continual involvement with the online Access community. He maintains a Web site with a wealth of information and resource links for those needing guidance with Access (http://www.AccessJunkie.com). He is the author of Microsoft Access 2010 Inside Out and co-authored the Microsoft Office Access 2007 Inside Out book with John Viescas. Jeff is currently employed by Microsoft as a Software Design Engineer in Test working with the Access development team.

Product Details

• Paperback: 1488 pages
• Publisher: Microsoft Press (April 11, 2007)
• Language: English
• ISBN-10: 0735623252
• ISBN-13: 978-0735623255
• Product Dimensions: 9 x 7.4 x 2.2 inches
• Shipping Weight: 2 pounds (View shipping rates and policies)
• Average Customer Review: 3.9 out of 5 stars  See all reviews (38 customer reviews)
• Amazon Best Sellers Rank: #24,417 in Books (See Top 100 in Books)
  • #14 in Books > Computers & Technology > Databases > Database Management Systems

More About the Author

John L. Viescas provides database consulting for a variety of small to large businesses and corporations worldwide. He is the author of numerous books, including Running Microsoft Access 97, Running Microsoft Access 2000, Microsoft Office Access 2003 Inside Out, and Building Microsoft Access Applications (Microsoft Press). He is also the co-author of SQL Queries for Mere Mortals (Addison-Wesley). He has written numerous articles for technical publications and has lectured at conferences and user group meetings around the world. He has been recognized as a "Most Valuable Professional" every year since 1993 by Microsoft Product Support Services for his assistance on public support forums.

Customer Reviews

Most Helpful Customer Reviews

56 of 56 people found the following review helpful:

5.0 out of 5 stars Comprehensive Presentation on 2007 ACCESS, May 14, 2007

By 

K. Snell (Rochester Hills, MI USA) - See all my reviews
(REAL NAME)   

Amazon Verified Purchase

This review is from: Microsoft® Office Access(TM) 2007 Inside Out (Inside Out (Microsoft)) (Paperback)

This book is valuable to the beginnner and the expert developer. If you're a beginner, it presents ACCESS 2007 in a step-by-step manner so that you can quickly be using the software. If you've used previous versions of ACCESS, this book identifies the differences (some are improvements, some are still waiting to be "characterized" in my mind < grin >) between the previous versions and this new version; as a developer, this was very useful for me to quickly learn of what's new and how it's new.

Lots of sample databases...and code...and tips/tricks... and a PDF version of the book with extra chapters on the accompanying CD.

The style is similar to those in John's previous books, so you'll like this one if you've read the earlier ones. Definitely worth the money...the first time you need to learn "how do I do this?", it'll pay for itself in the time it would take you to learn "by trial and error".

52 of 54 people found the following review helpful:

5.0 out of 5 stars Excellent Book, July 21, 2007

By 

Mark Boyle (NY, US) - See all my reviews
(REAL NAME)   

This review is from: Microsoft® Office Access(TM) 2007 Inside Out (Inside Out (Microsoft)) (Paperback)

If your looking for a comprehensive training guide, this is your book! I have had no experience with access before this book, but I was asked to do a project in access, and this book brought me from being utterly confused to having a very solid knowledge of the program. I update this review as I progress through the book. I am now roughly 1000 pages into the book, and I have not been disappointed yet, very easy to read, and very hands on, the quality is consistent as you go on through the chapters, it's very rare to find a spelling error or reference error(although there are a few.)

29 of 29 people found the following review helpful:

5.0 out of 5 stars A Fantastic Resource, October 26, 2007

By 

Robert Larson "Bob Larson" (Portland, OR) - See all my reviews
(REAL NAME)   

This review is from: Microsoft® Office Access(TM) 2007 Inside Out (Inside Out (Microsoft)) (Paperback)

I am a Super Moderator on an Access forum and I see questions about Access and Access 2007 all of the time. This book is a fantastic resource for someone wanting to find out about Access 2007 and how to use it. However, it is more than that! There are excellent reference materials within the book that would make it a "keeper" for anyone working with Microsoft Access, regardless of version.

There are plenty of examples and screenshots, making it one of the easier reference books on Access to understand.

I highly recommend this book to anyone wanting a better "Access" experience.