The Unofficial Guide to Microsoft Office Access 2007 [Paperback]

Jim Keogh (Author)

Book Description

ISBN-10: 0470045973 | ISBN-13: 978-0470045978 | Publication Date: April 9, 2007 | Edition: 1

The inside scoop...for when you want more than the official line!

Microsoft Access 2007 may be a major new update, but to use it with confidence, you'll need to know its quirks and shortcuts. Find out what the manual doesn't always tell you in this insider's guide to using Access 2007 in the real world. What's the best way to use the new features? What are "intelligent" forms? From setting up tables to encrypting databases, first get the official way, then the best way from an expert.

• Unbiased coverage of how to get the most out of Access, from using the Quick Launch Toolbar and Office Button to building a database from scratch
• Savvy, real-world advice on everything from using form views, PivotTables, and PivotCharts to writing questions in the form of a query
• Time-saving techniques and practical guidance on creating smart macros, collaborating with others using SharePoint(r), and adding pizzazz to reports
• Tips and hacks that help you work around Access quirks, avoid pitfalls, and increase your productivity
• Sidebars and tables on sorting rules for special characters, predefined sizes for number data types, and more

Editorial Reviews

From the Back Cover

The inside scoop...for when you want more than the official line!

Microsoft Access 2007 may be a major new update, but to use it with confidence, you'll need to know its quirks and shortcuts. Find out what the manual doesn't always tell you in this insider's guide to using Access 2007 in the real world. What's the best way to use the new features? What are "intelligent" forms? From setting up tables to encrypting databases, first get the official way, then the best way from an expert.

Unbiased coverage of how to get the most out of Access, from using the Quick Launch Toolbar and Office Button to building a database from scratch

Savvy, real-world advice on everything from using form views, PivotTables, and PivotCharts to writing questions in the form of a query

Time-saving techniques and practical guidance on creating smart macros, collaborating with others using SharePoint®, and adding pizzazz to reports

Tips and hacks that help you work around Access quirks, avoid pitfalls, and increase your productivity

Sidebars and tables on sorting rules for special characters, predefined sizes for number data types, and more

Watch for these graphic icons in every chapter to guide you to specific practical information:

• Bright Ideas are smart innovations that will save you time or hassle.
• Hacks are insider tips and shortcuts that increase productivity.
• When you see Watch Out! heed the cautions or warnings to help you avoid commonpitfalls.
• And finally, check out Inside Scoops for practical insights from the author. It's like having your own expert at your side!

About the Author

Jim Keogh is on the faculty of New York University and Saint Peter's College in Jersey City, New Jersey where he teaches Microsoft Access and other computer courses. He was a member of the faculty at Columbia University where he developed the e-commerce tract. Keogh has spent decades developing applications for major Wall Street corporations and is the author of more than 70 books including Java Database Programming for Dummies, Unix Programming For Dummies, and Linux Programming For Dummies.

Product Details

• Paperback: 638 pages
• Publisher: Wiley; 1 edition (April 9, 2007)
• Language: English
• ISBN-10: 0470045973
• ISBN-13: 978-0470045978
• Product Dimensions: 8.9 x 6 x 1.4 inches
• Shipping Weight: 1.7 pounds (View shipping rates and policies)
• Average Customer Review: 5.0 out of 5 stars  See all reviews (1 customer review)
• Amazon Best Sellers Rank: #233,038 in Books (See Top 100 in Books)
  • #100 in Books > Computers & Technology > Databases > Database Management Systems

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

3 of 3 people found the following review helpful:

5.0 out of 5 stars This is it, the Access Book You Really Want, February 8, 2011

By 

David Kirk (Upstate, New York USA) - See all my reviews
(REAL NAME)   

Amazon Verified Purchase

This review is from: The Unofficial Guide to Microsoft Office Access 2007 (Paperback)

Have you looked for a good overall reference for Microsoft Access 2007? Yes, I did too. Virtually every book review on them states something such as "it's good, BUT...." and then proceeds to tell all the shortcomings. And, probably like you, I bought several that had some information, but not what I was hoping for. Well, with this book, I hit pay dirt. This book is modestly priced, virtually unknown, no fancy color graphics, but the book delivers! Look at the table of contents and you'll be impressed. I had basic awareness of Access and could build simple databases, but there was always a question on something that I couldn't do... and I had given up on many books... but this book gives good advice, some of it regarding Access, and some on just good common design techniques.

For me, this isn't a book to sit and read. Instead, it's a book to use with its extensive index and its 18 page table of contents. (Yes, the table of contents is 18 pages long.) If you have to see pictures to learn, this book isn't for you, but if you need to see basic views and can follow good documentation, I think you will like this; I certainly did/do.