Access 2010 For Dummies

( 5 )


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

See more details below
$14.86 price
(Save 40%)$24.99 List Price

Pick Up In Store

Reserve and pick up in 60 minutes at your local store

Other sellers (Paperback)
  • All (31) from $9.26   
  • New (19) from $12.75   
  • Used (12) from $9.26   


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.

Read More Show Less

Product Details

  • ISBN-13: 9780470497470
  • Publisher: Wiley
  • Publication date: 5/3/2010
  • Series: For Dummies Series
  • Edition number: 1
  • Pages: 456
  • Sales rank: 113,974
  • Product dimensions: 7.30 (w) x 9.10 (h) x 1.30 (d)

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

Read More Show Less

Table of Contents

Introduction 1

About This Book 1

Conventions Used in This Book 2

What You Don't Have to Read 2

Foolish Assumptions 3

How This Book Is Organized 3

Part I: Basic Training 4

Part II: Getting It All on the Table 4

Part III: Data Mania and Management 4

Part IV: Ask Your Data, and Ye Shall Receive Answers 5

Part V: Plain and Fancy Reporting 5

Part VI: More Power to You 5

Part VII: The Part of Tens 5

Appendix: Getting Help 6

Icons Used in This Book 6

Where to Go from Here 7

Part I: Basic Training 9

Chapter 1: Getting to Know Access 2010 11

What Is Access Good For, Anyway? 12

Building big databases 12

Creating databases with multiple tables 13

Databases with user forms 16

Databases that require special reporting 18

What's New in Access 2010? 21

New and improved features 21

Reach out with SharePoint 24

How Access Works and How You Work with It 26

Opening Access 26

Selecting a starting point 28

Now what? 34

Chapter 2: Finding Your Way Around Access 37

Diving Right In 39

Working with On-Screen Tools in Access 42

Clicking tabs 43

Using buttons 44

The File tab and Quick Access tools 46

Accessing panes, panels, and context-sensitive tools 47

Customizing the Access Workspace 48

Repositioning the Quick Access toolbar 48

Adding buttons to the Quick Access toolbar 49

Removing buttons from the Quick Access toolbar 51

Minimizing the Ribbon 52

Working with ScreenTips 54

Mousing Around 56

Navigating Access with the Alt Key 57

Chapter 3: Database Basics 59

Database Lingo 59

Data, no matter how you pronounce it 60

Fields of dreams (or data) 60

Records 61

Tables 61

The database 62

Field Types and Uses 62

Choosing Between Flat and Relational Databases 67

Isolationist tables 68

Tables that mix and mingle 68

Building a Database 69

Adding and Removing Tables 73

One more, please 74

Oops, I didn't mean to do that 76

Part II: Getting It All on the Table 79

Chapter 4: Keys, Relationships, and Indexes 81

The Primary Key to Success 81

The Iowdown on primary keys 82

Creating a primary key 83

Making Tables Get Along 85

Rules of relationships 85

Relationship types 85

Building Table Relationships 87

The Relationships window 88

Table relationships 89

Indexing for Faster Queries 93

Create your own index 94

Adding and removing indexes 95

Chapter 5: Remodeling Your Data 99

Opening a Table for Editing 100

Inserting Records and Fields 103

Adding a record 103

Inserting a field 105

Deleting a field 108

Modifying Field Content 109

Name-Calling 110

Renaming fields 110

Renaming a table 112

Turn Uh-Oh! into Yee-Hah! 114

Chapter 6: What's Happening Under the Table? 115

Access Table Settings 115

Field Data Formats 118

Text and memo fields 118

Number and currency fields 121

Date/time fields 123

Yes/No fields 125

Gaining Control of Data Entry 127

You really need to put a mask on those fields 127

To require or not to require 133

Making your data toe the line with validation 134

Give your fingers a mini vacation by default 136

Part III: Data Mania and Management 139

Chapter 7: Creating Data Forms 141

Generating Forms 141

Keeping it simple: AutoForm 143

Granting most wishes: The Form Wizard 144

Customizing Form Parts 148

Taking the Layout view 149

The theme's the thing 150

Managing form controls 150

Chapter 8: Importing and Exporting Data 155

Retrieving Data from Other Sources 156

Translating file formats 156

Importing and linking 159

Get This Data Out of Here 164

Export formats 164

Exporting table or query data 165

Chapter 9: Editing Data Automatically 169

Please Read This First! 169

Creating Consistent Corrections 172

Using Queries to Automate the Editing Process 174

Looking for duplicate records 175

Running the Find Duplicates Query Wizard 176

Chapter 10: Gather Locally, Share Globally 181

Access and the Web 181

Click! Using Hyperlinks in Your Access Database 182

Adding a hyperlinks field to your table 183

Typing your hyperlinks 185

Fine tuning your hyperlinks 186

Testing links 187

Embedding Web Content into Your Access Forms 187

Adding hyperlinks to your form 188

Publishing Your Data to the Web 194

Publishing your Access tables 195

Part IV: Ask your Data, and Ye Shall Receive Answers 201

Chapter 11: Fast Finding, Filtering, and Sorting Data 203

Using the Find Command 204

Finding anything fast 204

Shifting Find into high gear 206

Sorting from A to Z or Z to A 208

Sorting by a single field 209

Sorting on more than one field 209

Fast and Furious Filtering 210

Filtering by a field's content 210

Filter by selection 212

Filter by Form 213

Unfiltering in a form 216

Filter by excluding selection 217

Chapter 12: I Was Just Asking for Answers 219

Simple (Yet Potent) Filter and Sort Tools 220

Filter things first 220

Fact-finding with fun, fast filtering 222

Here's the "advanced" part 224

Select Queries 229

Solid relationships are the key to getting it all (from your tables) 230

Running the Query Wizard 231

Getting Your Feet Wet with Ad Hoc Queries 236

Adding the finishing touches 240

Saving the query 242

Running your query 242

Chapter 13: I'll Take These and Those Or Them 245

Working with and and/or OR 246

Data from here to there 247

Using multiple levels of AND 249

Establishing criteria with OR 250

Combining AND with OR and OR with AND 252

Chapter 14: Queries That Think Faster Than You 255

Kissing That Calculator Goodbye via the Total Row 255

Adding the Total Row to Your Queries 257

Giving the Total Row a Workout 258

Organizing things with Group By 258

Performing sums 260

Counting, the easy way 262

Narrowing the results with Where 263

Creating Your Own Top-Ten List 264

Choosing the Right Field for the Summary Instruction 265

Chapter 15: Calculating with Your Data 267

A Simple Calculation 268

Complex Calculations 270

Calculate until you need calculate no more! 271

Using one calculation in another 271

Daisy-chaining your words with text formulas 275

Expression Builder (Somewhat) to the Rescue 277

Chapter 16: Flying into Action Queries 283

Easy Update 284

Add Records in a Flash 288

Quick Cleanup 291

Part V: Plain and Fancy Reporting 295

Chapter 17: Quick and Not-So-Dirty Automatic Reporting 297

Fast and Furious Automatic Reporting 298

Creating a quick, one-table report 298

Starting the Report Wizard 304

Previewing Your Report 309

Zooming in and out and all around 311

Pop goes the menu 313

Beauty is Only Skin (Report) Deep 314

The Print Options tab 314

The Page tab 316

The Columns tab 317

Chapter 18: Dazzling Report Design 319

Taking Your Report In for Service 319

Report Organization 321

Structural devices 321

Page breaks 324

Formatting This, That, and the Other 326

Adding color 327

Relocation, relocation, relocation 329

One size does not fit all 331

Spaced-out controls 332

Borderline beauty 333

Tweaking your text 337

Sneaking a Peek 338

Getting a Themes Makeover 339

Adding More Design Elements 341

Drawing lines 341

Pretty as a picture 342

Chapter 19: Headers and Footers and Groups, Oh My! 345

A Place for Everything and Everything in its Place 346

Layout basics 346

Sections 348

Grouping your records 350

So you want more? 354

Customizing Properties 355

Controlling report and page headings 356

Adjusting individual sections 359

Itemized adjustments 361

Chapter 20: Magical Mass Mailings 367

Massive Mailings with the Label Wizard 367

Part VI: More Power to You 375

Chapter 21: Making It All Better with the Analyzer Tools 377

Convert Your Flat Files to Relational Tables with Analyzer 378

Record Database Object Details with the Database Documenter 382

Improve Database Performance without Steroids 385

Chapter 22: Hello! Creating an Interface to Welcome Database Users 389

The Comings and Goings of a Navigation Form 390

Creating a Navigation form 390

Am I in the Right Place? Testing Navigation Forms 393

Maintaining the Navigation Form 394

Edit a Navigation form item 394

Delete a Navigation Form tab item 395

Move a Navigation Form item 395

Displaying the Navigation Form at Startup 396

Part VII: The Part of Tens 399

Chapter 23: Ten Common Problems 401

That's Just Not Normal 401

You Type 73.725, but it Changes to 74 402

The Words They Are A-Changing 403

Was There and Now It's Gone 404

Undo 404

Search for the missing record 404

Backup recovery 405

You Run a Query, but the Results Aren't What You Expect 405

The Validation That Never Was 407

The Slowest Database in Town 407

Your Database File Is as Big as a Whale 408

You Get a Mess When Importing Your Spreadsheet 410

We're Sorry; Your Database File is Corrupt 410

Chapter 24: Ten Uncommon Tips 413

Document Everything as Though You'll be Questioned by the FBI 414

Keep Your Fields as Small as Possible 415

Use Number Fields for Real Numbers 416

Validate Your Data 416

Use Understandable Names to Keep Things Simple 416

Delete with Great Caution 417

Backup, Backup, Backup 417

Think, Think, and Think Again 418

Get Organized and Stay Organized 418

There's No Shame in Asking for Help 419

Index 421

Read More Show Less

Customer Reviews

Average Rating 3.5
( 5 )
Rating Distribution

5 Star


4 Star


3 Star


2 Star


1 Star


Your Rating:

Your Name: Create a Pen Name or

Barnes & Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation


  • - By submitting a review, you grant to Barnes & and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Terms of Use.
  • - Barnes & reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing all of 5 Customer Reviews
  • Posted February 12, 2012

    Wouldn't bother!

    I've always had my doubts about anything "for Dummies" but I thought I'd try it out.

    At the beginning I thought this is great but that fast fizzled out because there wasn't concrete examples for completing the more common task, then I just set the book aside and went on my own and I was able to make sense of it myself.

    I feel cheated for the $ I paid on the book but at least I can give concrete examples to other people who ask of my opinion. It doesn't even deserve 1 star as I am forced to render in this e-mail.

    Thanks but no thanks.

    0 out of 1 people found this review helpful.

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted May 4, 2011

    No text was provided for this review.

  • Anonymous

    Posted November 26, 2012

    No text was provided for this review.

  • Anonymous

    Posted February 3, 2012

    No text was provided for this review.

  • Anonymous

    Posted October 22, 2011

    No text was provided for this review.

Sort by: Showing all of 5 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)