Access 2010 For Dummies

by Ulrich, Laurie A.; Cook, Ken

• ISBN13: 9780470497470
• ISBN10: 0470497475
• Edition: 1st
• Format: Paperback
• Copyright: 2010-05-10
• Publisher: For Dummies

Summary

A friendly, step-by-step guide to the Microsoft Office database applicationAccess 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 interfaceFully 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.

Author Biography

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.

Table of Contents

Introduction

Basic Training

Getting to Know Access 2010

Finding Your Way Around Access

Database Basics

Getting It All on the Table

Keys, Relationships, and Indexes

Remodeling Your Data

What's Happening Under the Table?

Data Mania and Management

Creating Data Forms

Importing and Exporting Data

Editing Data Automatically

Gather Locally, Share Globally

Ask Your Data, and Ye Shall Receive Answers

Fast Finding, Filtering, and Sorting Data

I Was Just Asking . . . for Answers

I'll Take These AND Those OR Them

Queries That Think Faster Than You

Calculating with Your Data

Flying into Action Queries

Plain and Fancy Reporting

Quick and Not-So-Dirty Automatic Reporting

Dazzling Report Design

Headers and Footers and Groups, Oh My!

Magical Mass Mailings

More Power to You

Making It All Better with the Analyzer Tools

Hello! Creating an Interface to Welcome Database Users

The Part of Tens

Ten Common Problems

Ten Uncommon Tips

Index

Table of Contents provided by Publisher. All Rights Reserved.