Hands-On Microsoft Access(c) A Practical Guide to Improving Your Access Skills

Hands-On Microsoft Access: A Practical Guide to Improving Your Access Skills

ISBN: 0321245458
EAN: 2147483647

Year: 2005
Pages: 169

Authors: Bob Schneider

BUY ON AMAZON

Hands-On Microsoft Access: A Practical Guide to Improving Your Access Skills
Table of Contents
Copyright
Praise for Hands-On Microsoft Access
Preface
How Will This Book Help Me Use Access More Effectively?
Is This Book Meant for Me?
Why Is Understanding Database Principles So Essential for Using Access?
How Is This Book Different from All Other Access Books?
How Much Access Do I Need to Know to Use This Book?
What Topics Does (and Doesn t) This Book Cover?
How Should I Read This Book?
What Teaching Devices Does This Book Use?
Which Version(s) of Access Does This Book Cover?
What s So Great About an Access Database Anyway?
Acknowledgments
About the Author
Chapter1.Getting Started
Key Terms
Data Types
Primary Keys
It s About Nothing: Null Values and Zero-Length Strings
Conclusion
Chapter2.Database Design
Learning About Database Design
Getting Started
Midchapter Review
Relational Database Principles
Organizing Fields into Tables
Refine the Fields
Keys
Multivalue Fields
Conclusion
Chapter3.Understanding Relationships
The Primacy of Primary Keys
One-to-Many Relationships
Many-to-Many Relationships
Final List of Fields and Relationships
Exclusive Identification
Refining Field Names
Table Types
What Is Normalization?
Conclusion
Chapter4.Establishing Relationships
Viewing and Creating Relationships
Referential Integrity
Overriding Referential Integrity
The Mechanics of the Relationship Window
Test Data and Conclusion
Case Example
Chapter5.Building Tables
Understanding Lookup Fields
Creating Access Tables
Creating Fields
Assigning Field Properties
Making Changes to Tables and Fields
Table Properties
Conclusion
Case Example
Chapter6.Entering, Editing, and Displaying Data
Tables Are the Center of the Access Universe
Data Entry in Table, Form, and Query Datasheets
How Form Controls Inherit Field Characteristics
Data Entry Methods
Data Entry: Form Versus Substance
Conclusion
Case Example
Chapter7.Find and Filter
Find and Replace
Filters
Filters in Reports
Expressions
Conclusion
Case Example
Chapter8.Queries
The Nature of Queries
Building Queries
Adding Calculated Fields
Top Values Property
Multitable Queries
Relationships Versus Joins
Inner Versus Outer Joins
SQL
Updating Records in a Query
Find Duplicates Query Wizard
Conclusion
Chapter9.Queries, Part II
Parameter Queries
Totals Queries
Crosstab Queries
Action Queries
Conclusion
CASE EXAMPLE
Chapter10.Reports
Learning How to Create Reports
The Asia Database
Begin the Report by Creating a Query
Beginning a Report in Design View
Detail Section
Page Header and Footer
Using Concatenation
Report Header and Footer
Creating a Report Using the Report Wizard
Comparing the From-Scratch and From-Wizard Reports
Conclusion
Case Example
Chapter11.FormsSubforms
Form Overview
Exploring Form Tools
Using the Form Wizard
Refining Your Form
Conclusion
Case Example
Chapter12.FormReport Design Elements
Adding Pictures and Other Objects
Visual Elements and Tools
Manipulating Controls
Macros
Multipage Forms
Switchboard Manager
Other Report Types
Conclusion
Case Example
Chapter13.Importing and Exporting
ImportExport Overview
Move Access Data to a Word Processor or Text Editor
Move Access Data to Excel
E-mail an Access Object
Import Access Data into Outlook
Importing Data into Access
Importing Access Data
Linking Versus Importing
Conclusion
Case Example
Chapter14.Pivot Tables and Pivot Charts
Getting Started with Pivot Tables
Pivot Tables Using Queries
Pivot Table Properties
Creating Pivot Charts
Conclusion
Case Example
GLOSSARY
Index
SYMBOL
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
Y