---

Absolute Beginners Guide to Microsoft Office Access 2003

ISBN: 0789729407
EAN: 2147483647

Year: 2002
Pages: 124

Authors: Susan Sales Harkins, Mike Sales Gunderloy

BUY ON AMAZON

• Main Page
• Table of content
• Copyright
• About the Author
• Acknowledgments
• We Want to Hear from You
• Introduction
• Some Key Terms
• Some Things to Keep in Mind
• The Basic Structure of This Book
• Conventions Used in This Book
• Contacting the Authors
• Part I: Getting to Know Access
• Chapter 1. Welcome to Databases
• What Can You Do with a Database?
• Why Not Just Use Excel?
• A Sample Database: Northwind Traders
• Chapter 2. Take a Quick Tour of Access
• Launching Access
• Opening a Database
• Opening an Existing File
• Converting
• Exploring the Access User Interface
• Making a Grand Exit
• Chapter 3. Exploring the Database Window
• What s in the Database Window?
• Organizing Database Objects
• Part II: Building and Using a Database
• Chapter 4. Planning a Database
• The Goal
• Determining the Database s Purpose
• The Discovery ProcessFinding the Data
• Identifying Possible Forms
• Planning Possible Reports
• Chapter 5. Building Your First Tables
• What s in a Table?
• How to Create a Simple Table
• Working with Data in Your Tables
• How to Find Information
• Chapter 6. Tapping the Power of Relationships
• Using the Lookup Wizard
• Using the Table Analyzer to Create Relationships
• Using the Relationships Window
• SubdatasheetsA Product of Relationships
• Chapter 7. Retrieving Data with Queries
• How to Create Simple Queries
• Using Query Design View
• Part III: Putting a Friendly Face on Your Data
• Chapter 8. Creating and Using Data Entry Forms
• Creating Simple Forms
• Entering Data Through Forms
• Finding Information with Forms
• Chapter 9. Printing Information with Reports
• Building Reports
• Using Reports
• Chapter 10. Take Your Data to the Web with Pages
• A Quick Overview of the Page Object
• Creating Simple Pages
• Using Pages
• How You ll Use Pages
• Part IV: Making Access Work Your Way
• Chapter 11. Customizing Your Tables
• Using Data Types Wisely
• Setting Field Properties
• Working with Indexes
• Chapter 12. Getting Down to Business with Queries
• Running the Query Wizards
• Working in Query Design View
• Chapter 13. Customizing Forms
• Setting Form Properties
• Using the Field List
• Using the Toolbox
• Working with Sections and Subforms
• Object Dependencies
• Chapter 14. Dressing Up Your Reports
• Formatting Reports
• Specialized Wizards
• Part V: Letting Access Do Your Work for You
• Chapter 15. Automating Your Database
• Using the Switchboard Wizard
• Setting Startup Options
• Writing Macros
• Chapter 16. Sharing Data
• Exporting Data to Excel
• Using Excel Data in Access
• Copying Linked Data
• Exporting Access Data to a Text File
• Importing Text Files into Access
• Publishing to Word
• Merging Access Data with Word Documents
• Sending Access Objects in Email
• More Compatible Formats
• Chapter 17. Using Common Office Features
• The Helpful AssistantNot
• Running SpellCheck
• About AutoCorrect
• Getting Help When You Need It
• Customizing Access Toolbars
• Index
• Index A
• Index B
• Index C
• Index D
• Index E
• Index F
• Index G
• Index H
• Index I
• Index J
• Index L
• Index M
• Index N
• Index O
• Index P
• Index Q
• Index R
• Index S
• Index T
• Index U
• Index V
• Index W
• Index Y