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)
Reverse Engineering and Importing to ORM
Creating a Basic Logical Database Model
Editing Logical Models”Intermediate Aspects
Editing Logical Models”Advanced Aspects
Change Propagation and Round Trip Engineering
Crystal Reports 9 on Oracle (Database Professionals)
Optimizing: The Crystal Reports Side
Optimizing: Reducing Parses
The Crystal Repository
Appendix A Common Issues
Appendix B Functions
Qshell for iSeries
The Integrated File System
Archives and Compression
Writing Programs for Qshell
Accessing OS/400-Specific Objects
The Perl Utility
A+ Fast Pass
Domain 1 Installation, Configuration, and Upgrading
Domain 4 Motherboard/Processors/Memory
Domain 5 Printers
Domain 1 Operating System Fundamentals
Domain 2 Installation, Configuration, and Upgrading
Logistics and Retail Management: Emerging Issues and New Challenges in the Retail Supply Chain
Market Orientation and Supply Chain Management in the Fashion Industry
Fashion Logistics and Quick Response
Logistics in Tesco: Past, Present and Future
The Development of E-tail Logistics
Transforming Technologies: Retail Exchanges and RFID
MPLS Configuration on Cisco IOS Software
MPLS VPN Architecture and Terminology
Configuring MPLS TE
Virtual Private LAN Service (VPLS)
Command Reference
Case Study 4: Implementing Layer 3 VPNs over Layer 2 VPN Topologies and Providing L2 VPN Redundancy
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