Teach Yourself VISUALLY Access 2010

Faithe Wempen

• Publisher: Visual
• Year: 2011
• Print ISBN: 9780470577653
• eBook ISBN: 9781118081853
• Edition: 1
• Topic: Computer Science
• Subtopic: Databases
• Index: Computer Science

The visual way to get up to speed on Access 2010

It's one thing to gain access to Access. It's another thing entirely to figure out how to do all the things you want to do in Access, because the software is not all that intuitive. This full-color guide clearly shows you how to get the most out of Access 2010, including how to enter new records; create, edit, and design tables and forms; organize, analyze, and share data; generate concise reports; and much more.

With pages of step-by-step instructions, graphics, and helpful advice, this is the visual learner's Access book-keep this on your desk and flip to what you need, any time!

• Explores the very latest features, functions, and tools of Access 2010, a database software tool that is part of the new Microsoft Office 2010
• Teaches you how to enter new records and create, edit, and design tables and forms
• Explains how to organize, analyze, and share data; generate concise reports; add smart tags to tables, save backup copies of your data; and more
• Demonstrates through step-by-step instructions and numerous, full-color screen shots and graphics, so you can see exactly how to perform tasks

This unparalleled book contains everything you need to know to use Access 2010 effectively.

Chapter 1: Getting Started with Access 2010

Are you new to Access or upgrading to the latest version? This chapter explains how to create a database as well as how to navigate through the new-and-improved Microsoft Office Access 2010 interface.

An Introduction to Access 2010

Start and Exit Access 2010

Create a Blank Database

Close a Database

Create a Database by Using a Template

Open a Database File

Understanding the Access 2010 Interface

Change the Navigation Pane View

Open and Close an Object

View an Object

An Introduction to Access 2010

Microsoft Access 2010 is a program for creating databases to store business or personal data. You can use Access to create, retrieve, and manage large or small collections of information.

Relational Databases

Microsoft Access creates relational databases — that is, databases that can contain multiple tables with links between them. For example, a business may have a Customers table for storing customer contact information and an Orders table for storing information about orders placed. Each customer in the Customers table has a unique ID, and each order in the Orders table references a specific customer ID.

Tables, Records, and Fields

In Access, data is stored in tables, and each individual entry in the table is called a record. For example, in a Customers table, the information about each customer is a separate record. Each record is composed of one or more fields that contai...

Table of contents

• Cover
• Table of Contents
• Title Page
• Chapter 1: Getting Started with Access 2010
• Chapter 2: Entering and Editing Data
• Chapter 3: Working with Tables
• Chapter 4: Working with Fields
• Chapter 5: Working with Relationships and Lookups
• Chapter 6: Finding and Filtering Data
• Chapter 7:Creating Simple Queries
• Chapter 8: Creating More Complex Queries
• Chapter 9: Creating Forms
• Chapter 10: Modifying and Formatting Forms
• Chapter 11: Creating and Formatting Reports
• Chapter 12: Grouping and Summarizing Data
• Chapter 13: Creating Mailing Labels
• Chapter 14: Creating Charts
• Chapter 15: Working with External Data
• Chapter 16: Performing a Mail Merge with Microsoft Word
• Chapter 17: Maintaining a Database