---

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