Access 2010 For Dummies (For Dummies (Computer/Tech)) [Paperback]

Laurie Ulrich Fuller (Author), Ken Cook (Author)

Book Description

ISBN-10: 0470497475 | ISBN-13: 978-0470497470 | Publication Date: May 10, 2010 | Edition: 1

A friendly, step-by-step guide to the Microsoft Office database application

Access may be the least understood and most challenging application in the Microsoft Office suite. This guide is designed to help anyone who lacks experience in creating and managing a database learn to use Access 2010 quickly and easily.

In the classic For Dummies tradition, the book provides an education in Access, the interface, and the architecture of a database. It explains the process of building a database, linking information, sharing data, generating reports, and much more.

• As the Microsoft Office database application, Access may be the least understood and most challenging part of the Office suite
• Access 2010 For Dummies walks newcomers through building and using their first database
• Covers linking information in a database, setting relationships, modeling data, and building tables
• Explores how to extract data from Access and get specific answers, create forms, and export data in reports
• A section for more experienced users looks at analyzing errors and creating an interface

Fully updated for the newest version, Access 2010 For Dummies gets new Access users up to speed and helps veterans get the most from the Office database application.

Editorial Reviews

From the Back Cover

Organize and use your data to create snappy-looking reports that put your genius on display

Access 2010 provides plenty of tools for building a database. You'll also need a bit of help to create a database that delivers the reports that drive business decisions. That's why you need this book. It covers the latest Access features and tools and explains how they assist in organizing and mining data to get the information and reports you need.

• Get down to basic training — find out about the new features and tools in Access 2010 as you navigate and master the Access workspace

• Set the table — create relationships between tables, customize the way data is stored in tables, and control how data is entered

• Dive into data — discover smart ways to share your Access data online or with other programs and bring data from applications into Access

• Find the answers — learn how to sort, filter, and query your data to get at the information in your database

• Spice up your reports — use timesaving tools that let you create customized, professional reports with ease

• Make it all better — tune up your database for better performance and create a user interface to control what people see

Open the book and find:

• How to open a table, insert records, and name fields

• Techniques for importing, exporting, and editing data

• TIps for sharing your database

• Ways to find, filter, and sort data

• How to get the answers to your database queries

• Secrets for designing cool reports

• Steps for using Analyzer tools

• How to create and test a Navigation form

Learn to:

• Navigate the Access interface andunderstand database architecture

• Build tables to organize data and forms for easy data entry

• Share data and create forms and reports

• Use the power of queries to find and maintain your data

About the Author

Laurie Ulrich Fuller is a highly experienced tech author, consultant, and Office trainer. Her consulting firm, Limehat & Company, offers training, Web development, and marketing services.

Ken Cook is a database design expert, consultant, and author of several books on Office and Excel.

Product Details

• Paperback: 456 pages
• Publisher: For Dummies; 1 edition (May 10, 2010)
• Language: English
• ISBN-10: 0470497475
• ISBN-13: 978-0470497470
• Product Dimensions: 9.3 x 7.4 x 1 inches
• Shipping Weight: 1.5 pounds (View shipping rates and policies)
• Average Customer Review: 3.1 out of 5 stars  See all reviews (7 customer reviews)
• Amazon Best Sellers Rank: #11,711 in Books (See Top 100 in Books)
  • #5 in Books > Computers & Technology > Databases > Database Management Systems

Customer Reviews

Most Helpful Customer Reviews

5 of 5 people found the following review helpful:

4.0 out of 5 stars Great for someone new to Access, August 7, 2011

By 

Grandma M (Oklahoma) - See all my reviews

Amazon Verified Purchase

This review is from: Access 2010 For Dummies (For Dummies (Computer/Tech)) (Paperback)

Having only a rudimentary knowledge of Microsoft Word in older versions, I bought Microsoft Office 2010. There were big changes so I bought two books, Microsoft Office 2010 all-in-one for dummies and this one on Access. I've never used Access but wanted to see if it could replace an ancient DOS database program we've used for decades in our businesses.

I wanted a book that wasn't intimidating and was quick to get me started. This one is a bit basic, but it is very clear and leads you through all the steps needed to set up a database. Because I have to work on this between deadlines, I haven't finished setting up my database yet, but I feel confident this book will provide all the information I need.

I'd recommend it for anyone just delving into Access 2010 for the first time.

2 of 2 people found the following review helpful:

4.0 out of 5 stars no dummy, April 12, 2011

By 

cat - See all my reviews

Amazon Verified Purchase

This review is from: Access 2010 For Dummies (For Dummies (Computer/Tech)) (Paperback)

The book is very informative. Microsoft Access has always been difficult for me to grasp, but this book makes it easy for me to learn Access 2010. I don't feel like a DUMMY!..... The author is also very humorous. I enjoy reading the book.

1 of 1 people found the following review helpful:

5.0 out of 5 stars Dummie no more!, October 26, 2011

By 

Karin (APACHE JUNCTION, AZ, United States) - See all my reviews
(REAL NAME)   

This review is from: Access 2010 For Dummies (For Dummies (Computer/Tech)) (Paperback)

I've been teaching Microsoft Office products for years yet never really felt truly confident about my Access skills until I worked through this book. It covered all of the basics and explains database terminology and concepts in a way that really made sense to me. I especially appreciated the way that Ulrich and Cook dealt with the topic of getting Access tables to play nicely with one another. (Like anything else in life, it's all about relationships! Check out pages 85 through 93!) I also found the chapter "Parts of Tens" to be really helpful in that it anticipated the most common difficulties a new Access user might experience and helped you over those hurdles. Lastly, the section titled "More Power To You" went beyond the basics and gave me the keys to the Access hot-rod by teaching me about the Access Analyzer - a tool that helps you tune up a database for optimum performance. Additionally, the sly humor throughout the book never failed to make me LOL. With section titles like "Beauty is Only Skin (Tables) Deep" and "The Words They are A-Changing" you know the writing is fun and easy to digest.