Access 2007 All-in-One Desk Reference For Dummies [Paperback]

Alan Simpson (Author), Margaret Levine Young (Author), Alison Barrows (Author), April Wells (Author), Jim McCarter (Author)

Book Description

ISBN-10: 0470036494 | ISBN-13: 978-0470036495 | Publication Date: December 26, 2006 | Edition: 1

• Updated to cover all the latest features and capabilities of Access 2007, this resource provides new and inexperienced Access users with eight task-oriented minibooks that cover begininning to advanced-level material 
• Each minibook covers a specific aspect of Access, such as database design, tables, queries, forms, reports, and macros
• Shows how to accomplish specific tasks such as database housekeeping, security data, and using Access with the Web
• Access is the world's leading desktop database solution and is used by millions of people to store, organize, view, analyze, and share data, as well as to build powerful, custom database solutions that integrate with the Web and enterprise data sources

Editorial Reviews

From the Back Cover

Give your Access confidence a boost by mastering the new interface!

Your one-stop guide to the revised, mode user-friendly release of Access.

Access 2007 got a total makeover, and this all-in-one guide helps you work with confidence even if you're all new to Access. The individual work with confidence even if you're all new to Access. The individual minibooks show you how to create and work with tables, queries, forms, reports, and macros; manage databases; and program Access with VBA.

Discover how to:

• Create a database quickly and easily from templates
• Sort, find, and filter data
• Use queries to gather data
• Perform calculations in forms
• Automate actions with macros
• Secure your Access database

About the Author

Alan Simpson is the author of over 115 computer books on all sorts of topics: Windows, databases, Web-site design and development, programming, and network administration. His books are published throughout the world, in over a dozen languages, and have sold millions of copies. Though definitely in the techno-geek category, we let him contribute anyway because sometimes people like that come in handy.

Margaret Levine Young has co-authored several dozen computer books about the Internet, UNIX, WordPerfect, Access, and (stab from the past) PC-File and Javelin, including The Internet For Dummies (Wiley) and Windows XP Home Edition: The Complete Reference (Osborne/McGraw-Hill). She met her future husband Jordan in the R.E.S.I.S.T.O.R.S., a high-school computer club before there were high-school computer clubs. Her other passions are her children, music, Unitarian Universalism (www.uua.org), reading, and anything to do with cooking or eating.

Alison Barrows has authored or co-authored books on Windows, the Internet, Microsoft Access, WordPerfect, Lotus 1-2-3, and other topics. In addition to writing books, Alison writes and edits technical documentation and training material. In real life she hangs out with her “guys” — Parker, 6, and Mason, 4, and Evan 2 — and tries to carve out some time to practice yoga. Alison lives with her family in central Massachusetts.

April Wells is a graduate of the University of Pittsburgh and holds an MBA from West Texas A&M. She is a database administrator with expertise in a wide variety of enterprise database software programs, including Oracle, DB2, MySQL, and Access. She is the author of several books and white papers on database software and is a frequent public speaker, trainer, and consultant.

Product Details

• Paperback: 768 pages
• Publisher: For Dummies; 1 edition (December 26, 2006)
• Language: English
• ISBN-10: 0470036494
• ISBN-13: 978-0470036495
• Product Dimensions: 9.1 x 7.4 x 1.6 inches
• Shipping Weight: 2.4 pounds (View shipping rates and policies)
• Average Customer Review: 4.3 out of 5 stars  See all reviews (6 customer reviews)
• Amazon Best Sellers Rank: #101,499 in Books (See Top 100 in Books)
  • #65 in Books > Computers & Technology > Databases > Database Management Systems

More About the Author

Alan Simpson is the author of over 115 computer books on all sorts of topics: Windows, databases, Web-site design and development, programming, and network administration. His books are published throughout the world, in over a dozen languages, and have sold millions of copies. Though definitely in the techno-geek category, we let him contribute anyway because sometimes people like that come in handy.

Customer Reviews

Most Helpful Customer Reviews

19 of 21 people found the following review helpful:

1.0 out of 5 stars Terrible and not for anyone, especially "dummies", March 1, 2009

By 

drumlinds (Boston, MA) - See all my reviews

This review is from: Access 2007 All-in-One Desk Reference For Dummies (Paperback)

I've never used Access before and spent about 2 days tinkering with it before I decided I needed a book to get any further. This is the first one I picked up. It gives you step-by-step instructions on how to do the simplest of tasks: open a new database, create a new table, use one of the various wizards within Access, how to navigate the new ribbon, etc. But they gloss over anything more complicated than that. That's a big problem when you're trying to learn a program as powerful and easily complicated as Access. I was really looking for help designing queries and I got nothing out of this book - it actually left me a little more confused. I'm pretty good with computers. I can't imagine how confused someone would be if they were actually a "dummy" when it came to computers. Thankfully, I got this book from the library so I didn't waste any money on it, but I did waste my time reading through the first third of the book before I abandoned it. I would recommend Access 2007: The Missing Manual instead - that book walks you through everything, often with screen shots of the program.

6 of 7 people found the following review helpful:

5.0 out of 5 stars Access 2007 for Dummies, March 29, 2010

By 

Gadgetlover "Bob" (Redwood City, CA, USA) - See all my reviews

Amazon Verified Purchase

This review is from: Access 2007 All-in-One Desk Reference For Dummies (Paperback)

I have used Microsoft Access at home for about 10 years, but never fully utilized most of it's powerful features, because I didn't take the time to really study any of the manuals and guides that were available. Prior to Access, my experience with data base applications was limited to proprietary programs of the company I worked for. Then I talked to someone about Access 2007 for Dummies, and decided to try it. I have only been using it for about 2 months and already I am pleased with my decision. The way it is written has allowed me to quickly identify some things I have always wanted to do with the program, as well as, show me some things I had never really considered in data analysis or record keeping. I am 75 years of age and semi-retired, so most of my use of the program is limited to keeping my personal, family and financial records, logging activities, generating forecasts, travel, sports data, etc. Knowing more about how Access works has enabled me to also reduce the amount of time spent updating and consolidating data.

3 of 4 people found the following review helpful:

5.0 out of 5 stars Simson's Access 2007, June 7, 2010

By 

Brother Joe - See all my reviews

Amazon Verified Purchase

This review is from: Access 2007 All-in-One Desk Reference For Dummies (Paperback)

Simpson's Access 2007 All-in-One Desk Reference for Dummies, bought through Amazon, is one of the best introductions to Access 2007.
I had worked with Access 2002 and 2003 for several years. I soon realized that, for version 2007, I needed a thorough
relearning of Access object management.
Simpson's numbered steps provide clear and graduated instructions for each procedure. The marginal book and chapter headings are helpful in looking up related topics.
Brother Joe Bouchard