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 | Edition: PAP/CDR

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

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.

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.

Product Details

• Paperback: 1488 pages
• Publisher: Microsoft Press; PAP/CDR edition (April 11, 2007)
• Language: English
• ISBN-10: 0735623252
• ISBN-13: 978-0735623255
• Product Dimensions: 7.5 x 2.2 x 9.1 inches
• Shipping Weight: 2 pounds (View shipping rates and policies)
• Average Customer Review: 4.0 out of 5 stars  See all reviews (43 customer reviews)
• Amazon Best Sellers Rank: #410,633 in Books (See Top 100 in Books)
  • #11 in Books > Computers & Technology > Databases > Access

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.

Most Helpful Customer Reviews

60 of 60 people found the following review helpful

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

By K. Snell

Format:Paperback|Amazon Verified Purchase

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".

54 of 56 people found the following review helpful

5.0 out of 5 stars Excellent Book July 21, 2007

By Mark Boyle

Format: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.)

30 of 30 people found the following review helpful

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

By Robert Larson

Format: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.

29 of 30 people found the following review helpful

5.0 out of 5 stars A good introductory guide to Access 2007 October 22, 2007

By James Beswick VINE™ VOICE

Format:Paperback

Access 2007 introduces a significantly steeper learning curve that the previous two versions, with a raft of complex GUI changes and a radically ramped navigation system. This is an excellent book to get familiar with these new features, and the additional CD ROM provides a superb resource with a substantial amount of extra material not in the book itself.

I would like to have seen fewer chapters on subjects such as introducing VBA (reiterating conditional loops - excuse the pun - really isn't necessary anymore), and a little more on good database design conventions and ways to tackle medium to large-sized projects. Having said that, it's well pitched to cover the questions from the majority of its audience.

I've grown to be quite fond of the Microsoft Publishing line of titles, in that the quality of the content is very consistent and I've yet to find a single technical error. The "Please Buy Microsoft" subliminal messages are not as chokingly omnipresent in recent editions either. Overall, this is a great way to spend $30 and feel somewhat grounded after a couple of days work.

31 of 33 people found the following review helpful

3.0 out of 5 stars Access 2007 Inside Out March 3, 2008

By J. Robert Benson

Format:Paperback

I bought this book because of the excellent section by the same authors in "2007 Microsoft Office System - Inside Out". However I was disappointed in the book because at least 30-40% of the book is taken up by exercises rather than didactic instruction. It would take one year to work through this book if you indeed worked all the examples. I would much rather see them put practical exercises in a separate section at the end of each chapter or on the CD.
Instead the authors have left out some important components such as database design, normalization, and naming conventions and relegated them to the CD if covered at all.
There is a lot of good information in the book but it is sometimes difficult to find.

27 of 29 people found the following review helpful

5.0 out of 5 stars Fantastic! ...Thorough ... easy to understand May 13, 2007

By Crystal

Format:Paperback

I got my copy 3 days ago (a month before the order said it would be here <smile>) and can't put it down! Already, I am nearly 1/3 of the way through ...and that is saying a LOT considering it is one of the biggest books I have in my collection.

The flow is great and the material is presented in a logical order. This book is very easy to read and understand, and is *extremely* thorough! I really like the way that John and Jeff introduce and use terminology -- everything is correct and the definitions are accurate.

There are lots of tips and tricks and good examples. The book guides you to a very complete understanding of Access as well as how it interfaces with other applications.

I highly recommend 'Microsoft Office Access(TM) 2007 Inside Out', by John Viescas and Jeff Conrad, to anyone who is using or plans to use Access 2007.

-- Crystal

Microsoft Access MVP 2007

*

have an awesome day :)

*

13 of 13 people found the following review helpful

5.0 out of 5 stars Very helpful, well organized text February 16, 2008

By Em

Format:Paperback|Amazon Verified Purchase

I opened to Queries, immediately I was able to use what I read in a short time to my work. It's well organized, you can go directly to the chapter of the subject you need to know about. If you don't create tables or databases but just need how to query, you can go directly to that. It's probably the most comprehensive book on Access 2007 out there. I highly recommend.