Microsoft Office Access 2007 Inside Out 1st Edition

by Jeff Conrad (Author), John Viescas (Author)

83 ratings

ISBN-13: 978-0735623255

ISBN-10: 0735623252

Why is ISBN important?

Share <Embed>

Other Sellers

from

Other Sellers

See all 2 versions

Used: Good | Details

Sold by Jenson Books Inc

Fulfilled by Amazon

Access codes and supplements are not guaranteed with used items.

Get Fast, Free Shipping with Amazon Prime

FREE delivery Monday, January 17 if you spend $25 on items shipped by Amazon. Order within 7 hrs 13 mins

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.

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

Start reading Microsoft Office Access 2007 Inside Out on your Kindle in under a minute.

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Product details

Publisher ‏ : ‎ Microsoft Press; 1st edition (April 11, 2007)
Language ‏ : ‎ English
Paperback ‏ : ‎ 1488 pages
ISBN-10 ‏ : ‎ 0735623252
ISBN-13 ‏ : ‎ 978-0735623255
Item Weight ‏ : ‎ 4.79 pounds
Dimensions ‏ : ‎ 7.29 x 2.65 x 9.08 inches

Best Sellers Rank: #2,714,416 in Books (See Top 100 in Books)
- #358 in Desktop Database Books
- #451 in Microsoft Access Database Guides
- #1,112 in Microsoft Office Guides

Customer Reviews:
83 ratings

About the author

Follow authors to get new release updates, plus improved recommendations.

Jeff Conrad

Brief content visible, double tap to read full content.

Full content visible, double tap to read brief content.

Discover more of the author’s books, see similar authors, read author blogs and more

Customer reviews

5 star		64%
4 star		14%
3 star		14%
2 star		5%
1 star		2%

How are ratings calculated?

Top reviews from the United States

There was a problem filtering reviews right now. Please try again later.

K. Snell

Comprehensive Presentation on 2007 ACCESS

Reviewed in the United States on May 14, 2007

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

64 people found this helpful

Helpful

Woodworker22

Excellent Answer to "Why a Database?"

Reviewed in the United States on May 3, 2013

Verified Purchase

Huge book, exhaustive treatment of all of the Access capabilities. Makes a great reference since it includes all the example database applications on a CD from which they can be loaded and run. Also includes the pdf version of the entire book so can be downloaded to your Kindle or other PC. For those who insist that Excel is good enough for their database needs, this is required reading. It will change your mind.

One star off since there's way too much Visual Basic implementation in the examples, would have preferred that they stuck to macro execution examples. Had VB been a prereq, might have eased the pain.

Bottom line, you should have this in your Access development library. When supplemented by the online Access 'help', might be the only information you need.

Helpful

Pamela Scott

Overwhelming

Reviewed in the United States on October 17, 2011

Verified Purchase

I studied AccessDatabase using SQL in college years ago. I needed to create a new database for a long-term project and bought this book to brush up on a few things. It's VERY thorough and covers theory as well as practical application. There is a lot of information that can be helpful to both the novice and a more experienced Access user but overall I think this book would be quite overwhelming for the novice user. The step-by-step sections are not formatted well and are difficult to follow - especially for a nivoce. OVerall this book is very informative. For someone who wants to get into heavy (regular) database creation this may be a good choice. For the novice or someone who wants to create a database fairly quickly but still learn the functionality of a relational database I think that Access 2007: The Missing Manual would be a better choice. This book is just too deep and quite overwhelming. You really have to read through an entire chapter to gain understanding and STILL refer back to previous chapters in the process.

3 people found this helpful

Helpful

Dee

Great Reference Guide!

Reviewed in the United States on January 1, 2014

Verified Purchase

I love all of the Inside Out Reference Manuals and this one is just has helpful to me in my collection. It gives great information especially when learning how to use the VBA. Of course, you can't have just one reference guide but, this one will be my go to first. It was also nice to spend just a few dollars on and get a great looking copy free of highlighting as well. This manual does assume that you have prior knowledge of Access but, don't let that stop you from obtaining this manual if you don't use it often. You also find many ways to use it outside of an office situation for home and for study.

Helpful

J. Evans

Excellent Access Book (even though the CD is glitchy)

Reviewed in the United States on May 19, 2011

Verified Purchase

I had the 2003 version of this text and wore it out. It was the one Access book I read the most, and I had several. I bought this version when my department upgraded to Access 2007 (this year!). I still think it is the best all around Access book on the market.

If you don't know already, then I'll tell you. Access 2007 is a completely different animal from 2003. Not only does it look different and act different, it has features and capabilities that 2003 never dreamed of. I'm not an Access pro, but I'm not a rank beginner either. I started with chapter one and I'm working my way through the entire book. I'm surprised at how much I've learned already. The book is particularly useful on the many occasions when I yank it off the shelf to answer one of those "How in the heck do I do [x]?" questions. Not all books can perform equally well as a comprehensive textbook and a handy reference guide. This one does.

However, the one glaring weakness of this text is the accompanying CD. Some of the sample databases on the CD trigger errors in the VBA code when I try to open them. Apparently, I don't know enough VBA to figure out what's wrong, so they're basically useless. Other sample databases can't be used at all unless you first install Microsoft SQL Server 2005 Express, then figure out how to configure it, and the sample databases, so that the sample databases will open. Good luck with that, I still haven't managed it. In other words, the entire CD is basically a no-go. Without the examples, it's often difficult to follow along with explanations in the text. If you don't have a copy of a database that you can experiment with, I suggest you create one as you go. Save extra copies of it just in case you accidentally kill one. With a better CD I would have rated this text 5 stars instead of 3.

One more thing. This book will teach you how to use a piece of database software. It is not intended to be a textbook on database design. If you have no familiarity with relational databases and how to properly design them, I doubt that this or any other Access book will help you very much. This is one area in which a grounding in the fundamentals is essential. It will save you a ton of frustration and dozens of hours of wasted effort. Trust me, as one who learned the hard way.

3 people found this helpful

Helpful

C. Giguere

I got a lot more than I expected!

Reviewed in the United States on November 11, 2009

Verified Purchase

This book was thorough, VERY THOROUGH! It teaches you everything from using the Access templates to using HTML to post a database on the internet or the office intranet. It's over 1200 pages and the CD has even more material. The book itself can be read on the CD in PDF form. If you want to get your IT or MOUS certification, this is your book!

If you're looking for just an overview than check out Access 2007 for Dummies.

6 people found this helpful

Helpful

Top reviews from other countries

sproggit

Do Not Mistake Quantity for Quality - Expansive but Poor Quality

Reviewed in the United Kingdom on October 12, 2015

Verified Purchase

At 1,443 pages, this is a hefty tome, and no mistake. Broken into 8 major "Parts", 29 Chapters, 6 Articles and a companion CD that contains not just sample files but also additional content not printed with the book itself, this is by no means a lightweight piece of work. Content itself is pretty well organised, with individual chapters covering topics such as "Creating your Database and Tables", "Using Forms", "Automating Your Application with Macros" and so on.

But, sadly, I get the impression that the authors may have mistaken quantity for quality. For example, despite sticking with a superficially logical structure and approach, the first actual "do something useful" portion of the book doesn't start until page 141... They spend 80 pages, no less, "Exploring the New Look of Access 2007", but in so doing kick off this detailed volume with an exploration of features that even advanced users may actually not need... Now, of course, books are random-access resources and it is possible to simply skip-ahead, but this comes across as a very clumsy way to write: what is the point of structuring a book if you just encourage people to ignore vast sections of it?

Another curious item is the font size and weight in the book. Perhaps I have been unlucky enough to get a copy where the ink transfer was a little "off", but the font size is about 18 characters to the inch, or roughly an 4-point font... That's absolutely ridiculous.

On the plus side the paperback edition does come with a full PDF copy of the entire volume, which can be size-adjusted on your monitor, and read alongside your Access program...

Plus Points:-
1. Extensive coverage - likely most things you will need are to be found in here somewhere
2. The companion CD has a PDF of the entire book, which is very handy

Minus Points:-
1. Poor sequencing of content
2. Ridiculously tiny font size
3. Poor editing - splitting embedded tables and figures from texts across page boundaries in an unhelpful way

On balance I can't recommend it...

One person found this helpful

Billywhiz

Powerful features

Reviewed in the United Kingdom on August 1, 2019

Verified Purchase

Microsoft's office 2007 was a ground-breaker and even though its later incarnations offered extra bells and whistles the fundamentals remain the same. A very good book which provides a valuable reference to those designing Databases which will work on any computer as long as its running Windows that is.

Greg

Well laid out book

Reviewed in the United Kingdom on February 10, 2012

Verified Purchase

As a complete Access novice I did a simple online course, upon completion I started my first database. I didn't get very far at all before I'd met the bounds of my new knowledge. This book is great to learn Access from scratch, following the examples gives you the practical help you need. Hopefully by the end of the book (or the relevant bits atleast) I'll be able to get my rather complex database to do everything I need.

My only criticism is, it could do with some simple easy step reminder pages to do common tasks, as it is the information is spread over whole chapters and it's difficult to cherry pick the precise bit of info on how to perfrm some tasks.

Also you may need to reinforce your bookcase it's a hefty book.

2 people found this helpful

Dicky Barton

The book you need to use and understand Access 2007

Reviewed in the United Kingdom on March 22, 2013

Verified Purchase

I am slowly progressing through the book which shows the reader in a well organised process how to carry out the various tasks.
Loads of time saving solutions,tips and workarounds. A ideal reference book.

One person found this helpful

Andy Gillies

Reviewed in the United Kingdom on May 24, 2013

Verified Purchase

This is ok but not the easiest reference to use compared with the In Depth books (for more advanced users ) or the Step by Step ones (for beginners)
Wound be getting any more in future.

One person found this helpful

See all reviews

Microsoft Office Access 2007 Inside Out 1st Edition

Editorial Reviews

From the Publisher

About the Author

Product details

About the author

Jeff Conrad

Customer reviews

Top reviews from the United States

There was a problem filtering reviews right now. Please try again later.

Top reviews from other countries