Access.2010.The.Missing.Manual, Office 2010
[ Pobierz całość w formacie PDF ]
Access 2010
Matthew MacDonald
Beijing
•
Cambridge
•
Farnham
•
Köln
•
Sebastopol
•
Taipei
•
Tokyo
Access 2010: The Missing Manual
by Matthew MacDonald
Copyright © 2010 O’Reilly Media, Inc. All rights reserved.
Printed in the United States of America.
Published by O’Reilly Media, Inc., 1005 Gravenstein Highway North, Sebastopol, CA 95472.
O’Reilly Media books may be purchased for educational, business, or sales promotional use.
Online editions are also available for most titles:
safari.oreilly.com
. For more information,
contact our corporate/institutional sales department: 800-998-9938 or
corporate@oreilly.com
.
Printing History:
June 2010: First Edition.
Nutshell Handbook, the Nutshell Handbook logo, the O’Reilly logo, and “The book that should
have been in the box” are registered trademarks of O’Reilly Media, Inc.
Access 2010: The Missing
Manual
, The Missing Manual logo, Pogue Press, and the Pogue Press logo are trademarks of
O’Reilly Media, Inc.
Many of the designations used by manufacturers and sellers to distinguish their products are
claimed as trademarks. Where those designations appear in this book, and O’Reilly Media, Inc.
was aware of a trademark claim, the designations have been printed in caps or initial caps.
While every precaution has been taken in the preparation of this book, the publisher and author
assume no responsibility for errors or omissions, or for damages resulting from the use of the
information contained herein.
ISBN: 9781449382377
[M]
Table of Contents
The Missing Credits
. . . . . . . . . . . . . . . . . . . . . . . . . . .
xvii
Introduction
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
1
Part One: Storing Information in Tables
Chapter 1: Creating Your First Database
. . . . . . . . . . . . . . .
23
Understanding Access Databases
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
24
Getting Started with Your First Database
. . . . . . . . . . . . . . . . . . . . . . . . . . .
25
Understanding Tables
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
29
Creating a Simple Table
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
30
Editing a Table
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
34
Saving Databases
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
38
Making Backups
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
38
Saving a Database with a Different Name or Format
. . . . . . . . . . . . . . . . . .
40
Shrinking a Database
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
41
Opening Databases
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
42
Designating a Database as Trusted
. . . . . . . . . . . . . . . . . . . . . . . . . . . .
42
Opening Recent Databases
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
43
Opening More Than One Database at Once
. . . . . . . . . . . . . . . . . . . . . . .
44
Opening a Database Created in an Older Version of Access
. . . . . . . . . . . . . .
45
The Navigation Pane
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
47
Browsing Tables with the Navigation Pane
. . . . . . . . . . . . . . . . . . . . . . .
48
Managing Database Objects
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
50
Chapter 2: Building Smarter Tables
. . . . . . . . . . . . . . . . . . .
51
Understanding Data Types
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
51
Design View
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
52
Organizing and Describing Your Fields
. . . . . . . . . . . . . . . . . . . . . . . . .
54
How Updates Work in Design View
. . . . . . . . . . . . . . . . . . . . . . . . . . .
56
iii
[ Pobierz całość w formacie PDF ]