Flylib.com
Hands-On Microsoft Access: 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
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
Database Modeling with MicrosoftВ® Visio for Enterprise Architects (The Morgan Kaufmann Series in Data Management Systems)
ORM Constraints
Conceptual Model Reports
Creating a Basic Logical Database Model
Editing Logical Models”Advanced Aspects
Other Features and Best Practices
Beginners Guide to DarkBASIC Game Programming (Premier Press Game Development)
Characters, Strings, and Text Output
Game Graphics Learning to Use Bitmaps
Adding Sound Effects to Your Game
Playing Intro Movies and Cut-Scenes
Multiplayer Programming The Crazy Carnage Game
FileMaker Pro 8: The Missing Manual
Printing and Preview Mode
Layout Mode
Table Occurrences
Date and Time Calculations
Sharing Over the Internet
MySQL Clustering
Using Multiple Management Nodes
Query Execution
Load Balancing and Failover
B Management Commands
C Glossary of Cluster Terminology
Information Dashboard Design: The Effective Visual Communication of Data
Designing an Unattractive Visual Display
Summary
Organize the Information to Support Its Meaning and Use
Design for Use as a Launch Pad
Sample Sales Dashboard
Special Edition Using FileMaker 8
Creating Ranged Relationships
Getting Started with Calculations
Getting Out What You Put In
Custom Web Publishing Versus XML Export
Deploying to Handheld Devices
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies